Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time dependant Excel Macro
If macro's cannot be run from an excel spreadsheet without it being open, if
i transferrred the data to some sort of Access workbook would i be able to? For example i want my macro to run at midnight, but obviously without the sheet being open i can't do this. Does microsoft Access have this ability? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time dependant Excel Macro
Use Windows Task Scheduler to start up Excel with a Command line to open the
workbook,which will then run the macro then save your work and shut down Excel. See Windows help on Task Scheduler and Excel help on startup switches. Gord Dibben MS Excel MVP On Tue, 12 Jan 2010 09:56:02 -0800, Dan Wood wrote: If macro's cannot be run from an excel spreadsheet without it being open, if i transferrred the data to some sort of Access workbook would i be able to? For example i want my macro to run at midnight, but obviously without the sheet being open i can't do this. Does microsoft Access have this ability? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL | Excel Worksheet Functions | |||
I require code to run a macro dependant on the date | Excel Discussion (Misc queries) | |||
Dependant Lists in Excel | Excel Worksheet Functions | |||
How can I get excel to ignore formula in dependant cells... | Excel Worksheet Functions |