Sign in to follow this  
Followers 0
Miguel

Need Help making a Excel macro to Run

5 posts in this topic

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.

Share this post


Link to post
Share on other sites



@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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0