Timer

kattsteadman · Feb 22nd, 2002, 01:25 PM

I have a macro in Excel that I have to run everyday at the same time. Wondering if there is some kind of timer in VB that would open the spreadsheet and run the macro for me? Would appreciate any suggestions.
Katt

Juan Pablo González · Feb 22nd, 2002, 08:20 PM

If you need to open Excel, then put the macro in the Workbook_Open event, and use the Task Manager to open Excel (Not much experience there, but shouldn't be hard...)

Feb 22nd, 2002, 08:20 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If you need to open Excel, then put the macro in the Workbook_Open event, and use the Task Manager to open Excel (Not much experience there, but shouldn't be hard...) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 01:25 PM	#1
kattsteadman New Member Join Date: Feb 2002 Location: Irving, TX Posts: 4	I have a macro in Excel that I have to run everyday at the same time. Wondering if there is some kind of timer in VB that would open the spreadsheet and run the macro for me? Would appreciate any suggestions. Katt