Need Help making a Excel macro to Run

[Miguel]

Im new at this, so sorry by this dummy question.

I Have a File called "Auto_email.xls"

In this file I have a Macro named "Send_mail"

I want to open the workbook and then send an "order" from autoit to make the macro Run.

Does someone may help me

Thanks in advance.

[randallc]

Hi,

perhaps see the example in the zip file linked below for ExcelCOM?

include it and use it, or see how it is written and write a short one.

Best, randall

[ptrex]

@Miguel

There are more alternative going :

One is

If you record a macro and save it using the name "Auto_Open", the macro will run whenever you open the workbook

Second is

The following example uses the Open event to run a macro when you open the workbook.

Save and close all open workbooks.

Open the workbook you want add the macro to, or create a new workbook.

On the Tools menu, point to Macro and then click Visual Basic Editor.

In the Project Explorer window, right-click the ThisWorkbook object and then click View Code on the shortcut menu.

In the Object list above the Code window, select Workbook. This will automatically create an empty procedure for the Open event like this:

Private Sub Workbook_Open()

End Sub

Add the following lines of code to the procedure:

Private Sub Workbook_Open()

MsgBox Date

Worksheets("Sheet1").Range("A1").Value = Date

End Sub

Third is the commandline switch

But I can't remember which one it is, look in help or Google :

This way you can use the AutoIT Run("c:\program files\Ms ...\Excel.exe /swit") to trigger the macro.

Regards

ptrex

[Will66]

from memory, you can assign a macro a hot key...

[ptrex]

@Will66

Correct that's an other extra method to use.

Good thinking

regards

ptrex