Can you write Macro to update dynamically...

[Larry]

...at a certain time each day?

If I wanted a report to refresh daily at 7:00am, is there a way to code the macro to do this without having to open the workbook?

Thanks,

Larry

 

[lantiger]

Hey Larry,

I can't remember exactly how, but I think
application.OnTime will does exactly that. Look through the VBA online help for the onTIme function.

If you need more help, let me know.

HTH
lantiger