+ Reply to Thread
Results 1 to 2 of 2

how to call a function in excel VBA through VBS?

  1. #1
    Registered User
    Join Date
    02-06-2007
    Posts
    2

    how to call a function in excel VBA through VBS?

    hi all,

    i have a excel VBA application which does an operation based on user interaction. the VBA has a button to get the user name/password for the data to be uploaded to database.

    i am in the process of automating this process, so can you guys help me with a way to invoke the BUTTON'S click event to automatically popped up from window shellscripting.

    thanks in advance.

    -Ravig

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    I don't know exactly what you mean.
    There are 2 buttons, one in the UserForm drom the VBEditor and ont that is created from the Forms toolbar and placed on a worksheet. In the first case you would edit the UserForm code with:
    Private Sub CommandButton1_Click()

    End Sub

    in the other case you would assign a macro (you can right click the button) and Record the macro.
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1