Executing a VBA macro from within Excel 97 script

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running Excel 97. I have an application in it that is written in the
macro scripting language. The application works very well. I also have a VBA
macro that works very well when I execute it manually. However, I would like
to execute the VBA macro from within the application written in the scripting
language. I do not know, nor have I been able to find out, how to do it. All
help will be appreciated.
Thank you
RickT
 
Open the Excel file you want to use, and go to View, toolbars, forms.
Draw a button from the toolbar.
It will then automatically open an Asign macro window,
Choose the macro from the list, and the macro will run by clicking the button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

execute .acsup script from VBA macro 3
Excel VBA in Citrix. 0
Refresh Bloomberg data in an excel file from a script 4
How to Pause an Excel VBA script without freezing excel 1
My VBA Help is in Japanese! 1
Macros Execute Very Slow Problem 1
VBA code won't run, even with Macro Security set to Enable All Macors 9
starting Word with an Excel macro 2

Back
Top