VBA Macro to auto-open an Excel file

[mrexcelrc]

Good morning,

Can you please help me write this macro. I have an Excel file that I have to open at 5 p.m. everyday. I tried to use Workbook.Open but it doesn't open the file automatically. Please help!

 

[Trevor G]

Have you got access to your control panel, as you can use the scheduler to open the workbook at 5pm.

Try use "Scheduled Tasks" in Start - > Accessories - > System Tools - >Scheduled Tasksyou can schedule your wb to be opened every day at 5:00 pm.</PRE>

 

[mrexcelrc]

Thank you for sharing. Just one question, do I have to have my pc turned on for this to execute?

 

[Trevor G]

Yes if you use this method, but you did say you have to open a workbook at 5pm.