Create executable file to run excel macro

P

Pawan

Hi

I have written a complex macro in excel and now have to distribute it to
co-workers. However, I want to create an executable file which will run the
macro directly (will open the userform in my macro).

Is there any chance of doing so?

Thanks in advance

Regards,
Pawan
 
P

Pawan

Thanks Joel

But I did not get the example given by you. It is exe file and it opens new
workbook. How can I use this to open the workbook that I wish?

Regards,
prm
 
J

Joel

Book1.xls is the workbook that contains that macro you want to run. The Exe
file is Excel.exe (this is the file that starts excel). The command line I
gave your startup excel and opens the workbook book1.xls. You can change the
workbook name to any xls file you like.
 

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

Top