3 replies to this topic

[Tstudent]

What i would like to do is:

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?

thank you

[JoHanatCent]

If you use the following you do not have to build a sleep in:
#include <Excel.au3>
and to open use
$oExcel = _ExcelBookOpen($file, 1)

$oExcel.run("mymacro1");<<<< == Your Macro to run

[Tstudent]

Thank you very much.

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?

Thanks

[Tstudent]

Found the solution.

Paste here for other interested users of this beautiful forum:

$oExcel = ObjGet("", "Excel.Application")
For $element In $oExcel.Application.Workbooks
If $element.FullName <> "" Then
MsgBox(0,"",$element.FullName)
$element.Save
$element.Close
Else
$element.Activate
$oExcel.Application.Dialogs(5).Show
EndIf
Next
$oExcel.Application.Quit