Running a macro on opening a file

Hello

I have automated my pc (windows xp) to open using the schedule tasks function. Once open i am using the workbook open function in my personal.xls in VBA to open a file (code below):

Please Login or Register  to view this content.

How can i then run a specific macro that exists in that workbook

Thanks in adavance for any help

Nik

Good afternoon nieironisio

...and welcome to the forum!!

Originally Posted by nieironisio

How can i then run a specific macro that exists in that workbook

Use code inside a Workbook_Open event like this :

Please Login or Register  to view this content.

in the ThisWorkbook module.

You could either "Call" the macros by name, or just put the code you want to run inside the macro.

HTH

DominicB