Auto run a Macro 1

[Croaks]

Hi ive got a macro that is importing data from sage into Excel then saving it

I cant however get the AutoExec function to work, it wont even work for a simple pop up box

Ive made it work hundreds of times in Word so whats the catch in Excel to make it work?

Cheers for the help

 

[Rodie]

Hi,

With Excel, you can't produce an executable file.
But you can launch your Macro as soon as the user open the Excel file.

Just put your code in a module and start your code like that:

Sub Auto_Open()
... your code ...
End Sub

Regards.
Rodie

 

[stibbetts]

thanks rodie, that solved one of my questions too ;-) it got rid of the change cell event in the spreadsheet that fired a sub in a module (i dont like convoluted)

 

[Croaks]

Yup sorted mine too

Thanks for the help