Run Excel Macro
Posted 17 March 2012 - 10:52 AM
1) Open an excel file // no problem, this is very simple
2) wait for excel file completely load // i can use sleep function and use a very long time to be sure
3) run an excel macro called "mymacro1" // i don't know how to do this
Can you give me the correct sintax for point three?
Posted 17 March 2012 - 11:12 AM
and to open use
$oExcel = _ExcelBookOpen($file, 1)
$oExcel.run("mymacro1");<<<< == Your Macro to run
Posted 17 March 2012 - 04:51 PM
I have another question, don't know if it is possible.
Before run excel file i want (with _ExcelBookOpen($file, 1)) i want to check if, accidentally, there are other excel files already open. In that case i want close all of them (saving before exit).
Is possible to do this check and close all other excel files eventually opened?
Posted 17 March 2012 - 05:53 PM
Paste here for other interested users of this beautiful forum:
$oExcel = ObjGet("", "Excel.Application")
For $element In $oExcel.Application.Workbooks
If $element.FullName <> "" Then
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users