Posts by cbanks

    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.

    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"
    onclick="CSWCSC_runSearch(this.form)" onkeypress="return CSWCSC_submitenter(this,event)"><U>R</U>un Search</button>

    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?

    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.

    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


    Re: Open Folder

    Alot of them are not working. Why?

    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

    Re: Open Folder

    thanks, but is there not something as simple as

    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

    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?

    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.