Posts by cbanks

  • Macro To Delete

    Re: Macro To Delete


    Sorry, should have tried a better search. I just kept getting macros to delete stuff, and not the macro itself. Roy is right. Trust must be changed.

  • Internet Explorer Buttons

    Hi, im working on a project that has exposed myself to something. I am familiar with navigating through many IE websites in VBA, but this one has me stumped. I have entered all my information via code, and now I need to progress to the next screen. Here is the button I need to click. All help is greatly appreciated. Thank you.


    <button name="btnRunSearch" accesskey="R"
    class="actionButtonBold"
    onclick="CSWCSC_runSearch(this.form)" onkeypress="return CSWCSC_submitenter(this,event)"><U>R</U>un Search</button>

  • Populating Userforms

    Is there a in vba to populate a form that has textboxes and such with labels from each column. Say i had a spreadsheet with data in it from a-az. Each column had a heading and I wanted to view that information in a form on line at a time. Column a would house the information i would want to select to view the rest by. if contents of cell a5 was 1, and i selected 1, then i would want all the information from b5-az5 to show in the boxes on this form. can this also be editable so i can submit changes?


    This is something that would be very useful. I know i can use data>form to create a form to view with, but what about one to select and edit?

  • Slow Down Macro

    Re: Slow Down Macro


    im sorry.. its working fine now.. i opened it through a shortcut which opened it in explorer and that cause the delay. thanks for your help.

  • Slow Down Macro

    My macro is moving so fast it error'rs. When i debug it works fine stepping through, but if i run it i get an error.


    errors here

    Code
    Workbooks(savepath).Activate

  • Open Folder

    Re: Open Folder


    Alot of them are not working. Why?


    Code
    Private Sub Command10_Click()
Dim WshShell As Object
    Set WshShell = CreateObject("WScript.Shell")
    WshShell.Run "\\r-cs-0570-01\clientdata$\n0114051\Desktop\Desktop\MPD Edit"
    Set WshShell = Nothing
'mpd edit
End Sub

  • Open Folder

    Re: Open Folder


    thanks, but is there not something as simple as

    Code
    Private Sub Command1_Click()
Call Shell("C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe", 1)
End Sub


    i want to use this in VB and VBA

  • Open Folder

    I know this is simple, but im having problems finding it in search. Im using the Shell method to open files, but how to open folders?

  • Reporting Access/excel

    Hi, I have a program in vba that uses an access table for its data. One of my columns identify's if the program went as planned with no errors, and another column identifies if the output was as intended. I am not very skilled with access, but I know alot of vb/vba code. Should I do my reporting based on those two columns in access or excel? How do I get either one to create an actual report?


    i do realize my question is vague, but so is my experience.