How to run a macro if I don't know the name in advance

H

Himanshu

I am trying to create a macro on the fly using vb code from an existing file,
and then run the Macro that was just created. Is there a way to find out the
name of a Macro programmatically so that I can pass it to the Application.Run
method?
 

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

Run code from another workbook 7
Determine name of macro contained in each excel file in a folder 9
Run Macro on All Sheets Q 8
VBA code to run macro in certain file based on name of file in cel 2
Run macro from active workbook whose name keeps changing 20
Stop Command Question 4
How to Run a Macro From WB1 in WB2 Against WB2 5
Refresh Bloomberg data in an excel file from a script 4

Top