Create executable file to run excel macro
Make the macro an Workbook open macro or call your macro from a workbook open.
Next create a BAT file to open the workbook and run the Bat. Here is a sample of the bat file "C:\Program Files\Microsoft Office\Office10\excel.exe" c:\temp\book1.xls "Pawan" wrote: 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 |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com