1.

Solve : to run Macro in Excel from batch file command?

Answer»

Is there any COMMAND for batch file USING which I can run a recored macro in Excel . I need to to run from batch file, not by clicking the macro in Excel interface.Not directly. The macro is bound to the workbook. Just as you created the macro within the context of the Excel Application, it executes within Excel.

You can open a workbook by calling it from the command line or batch file. If by chance you named your macro auto_open or binded it to the workbook open event, the macro would run when Excel processes this workbook.

You can write external scripts that can access your workbook using any COM AWARE scripting language (EX. vbscript, jscript, REXX etc)

Good luck.



Discussion

No Comment Found