Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
My target is to run everyday at 06:00 a macro within my Excel document without being connected to the server where the file is located. Based on previopus thread, I identified I have to to: 1. Use the Sub Auto_Open() = done. 2. Use a Scheduled Task with the Excel target file as parameter= done. 3. Lower the Excel security to LOW = done. Nonetheless, I am facing an issue as the Excel process starts correctly and it look likes the target file is not loaded and therefore the macro does not run or the target file is loaded and the macro does not run automatically. Anyone can help me pelase :-) Best regards. Coolthinking |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Support a task in excel | Excel Discussion (Misc queries) | |||
Trying to run a MSQuery from Excel as a Scheduled Task | Excel Discussion (Misc queries) | |||
Create macro to copy data on a scheduled basis | Excel Discussion (Misc queries) | |||
Excel macro's to run at a scheduled time | Excel Discussion (Misc queries) | |||
Pivot Table through Scheduled Task | Excel Discussion (Misc queries) |