invoking a macro

  • Thread starter Thread starter Al_C
  • Start date Start date
A

Al_C

Hi,
Is it possible to invoke a macro when starting excell fom the command line?
My ultimate purpose is to permit a user to push a button in my app and
invoke excel which then imports a CSV text file which my app has generated.
Any alternative approaches?
Al
 
Al

Macros cannot be invoked from the command line.

You can, however, add Workbook_Open code in the ThisWorkbook module which will
run a macro when the workbook is opened via the command line.

Or Auto_Open code in a general module.

Assuming that users enable macros.


Gord Dibben MS Excel MVP
 

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

Back
Top