VBA Code to Trigger Macro Event

[SRafter]

Hi everyone, I have a macro in a large excel workbook that I use to refresh queries imported from MS Access.

Can anyone help with the VBA code I would need to trigger the macro to refresh the queries at a particular time every day?

Look forward to hearing from you. Cheers, Steve.

 

[Blade Hunter]

I believe there is an applicaiton.ontime event, you can use that to schedule macros note the sheet with the macros in needs to be open at run time. To get around this in the past I have set up a batch file to open the sheet which then uses auto open macros, I then set the batch file up as a scheduled task in Windows. This way Excel can be open or closed and it will still work.

 

[SRafter]

Thanks Blade, I perhaps should have pointed out that I am very, very new to VBA. My skills extend only to assigning a macro to refresh my imported queries, so I only understood about half of your reply.

Im really looking for a hand to write the code if you or anyone else out there can help.

Cheers, Steve.

 

[Blade Hunter]

Which solution do you want? The scheduled task option or the ontime option?

I prefer the scheduled task. Others prefer the ontime. Your call .

Cheers

Dan

 

[SRafter]

I'm happy with whatever is easiest to apply and maintain.