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

It would be possible to write an executable to launch your userform, even
easier to do so from a script file of some sort but I'm guessing that isn't
really what you want to do. Wouldn't it be simpler to just have the
userform come up when the workbook is first opened or to give your coworkers
a command button in the Workbook to launch the userform? Plus, using a
separate executable file means you not only have to distribute your workbook
but the exe file as well plus deal with any security concerns over exe files
that your employer might have.


Steve Yandl



"Pawan" wrote in message
...
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

I would use a VBScript rather than an exe file. Open Notepad, and
enter the following in the text file:

Set XL=CreateObject("Excel.Application")
XL.Visible=True
XL.Workbooks.Open "C:\A.xls"
XL.Run "A.xls!TheMacro"


Change "C:\A.xls" to the appropriate file name. Change
"A.xls!!TheMacro" to the workbook name and macro name.

Save the file as a vbs file, e.g., RunIt.vbs rather than a txt file.

Then, all the user needs to do is double click the vbs file and Excel
will start, open C:\A.xls and execute TheMacro.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Sun, 30 Aug 2009 04:54:01 -0700, 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

On Monday, August 31, 2009 at 3:26:16 AM UTC+5:30, Chip Pearson wrote:
I would use a VBScript rather than an exe file. Open Notepad, and
enter the following in the text file:

Set XL=CreateObject("Excel.Application")
XL.Visible=True
XL.Workbooks.Open "C:\A.xls"
XL.Run "A.xls!TheMacro"


Change "C:\A.xls" to the appropriate file name. Change
"A.xls!!TheMacro" to the workbook name and macro name.

Save the file as a vbs file, e.g., RunIt.vbs rather than a txt file.

Then, all the user needs to do is double click the vbs file and Excel
will start, open C:\A.xls and execute TheMacro.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Sun, 30 Aug 2009 04:54:01 -0700, 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

Thanks a lot Chip for this solution, however if i want to run a macro using using this and also want to pass parameters, how can i do that?