LinkBack URL
About LinkBacks
Hi,
I am new to excel macros.
I need to run a macro from command prompt, basically a batch file(.BAT).
I have written the macro and it runs perfectly from the excel file.
But I don't know how to execute it from a batch file.
Thanks in advance.
Hi,
I am new to excel macros.
I need to run a macro from command prompt, basically a batch file(.BAT).
I have written the macro and it runs perfectly from the excel file.
But I don't know how to execute it from a batch file.
Thanks in advance.
It can probably be converted into a .vbs script file, similar to a .bat file except it will run VBA-like code.
Post the script. Be sure to put CODE tags around it as shown in my signature, as per the forum rules.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi,
I have saved the following Uppercase() macro in the file 'Sample.xlsm'.
I need to run it in a batch file. How to run this?
Moreover, I have heard that .vbs are prone to virus... Is it true?
Please Login or Register to view this content.
I can convert this to vbs. Is this just for 1 file?
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks