| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run Excel macro from Scheduled Task
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Excel macro from Scheduled Task
Perhaps the macro is outputting a message, and with no-one around to
respond, it just waits. -- __________________________________ HTH Bob "coolthinking" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Excel macro from Scheduled Task
Hello,
Thanks for the suggestion. However, the macro does not provide any messages. Moreover, if I manually open the Excel file then the macro runs without trouble. "Bob Phillips" wrote: Perhaps the macro is outputting a message, and with no-one around to respond, it just waits. -- __________________________________ HTH Bob "coolthinking" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Excel macro from Scheduled Task
Try moving the code in Auto_Open to workbook_Open in ThisWorkbook code
module. -- __________________________________ HTH Bob "coolthinking" wrote in message ... Hello, Thanks for the suggestion. However, the macro does not provide any messages. Moreover, if I manually open the Excel file then the macro runs without trouble. "Bob Phillips" wrote: Perhaps the macro is outputting a message, and with no-one around to respond, it just waits. -- __________________________________ HTH Bob "coolthinking" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Excel macro from Scheduled Task
Thanks for your help. I updated the Excel file with the changes you suggested.
Unfortunately, the issue remains identical, and I am still able to manually open the Excel file and then having the macro running without trouble. Coolthinking. "Bob Phillips" wrote: Try moving the code in Auto_Open to workbook_Open in ThisWorkbook code module. -- __________________________________ HTH Bob "coolthinking" wrote in message ... Hello, Thanks for the suggestion. However, the macro does not provide any messages. Moreover, if I manually open the Excel file then the macro runs without trouble. "Bob Phillips" wrote: Perhaps the macro is outputting a message, and with no-one around to respond, it just waits. -- __________________________________ HTH Bob "coolthinking" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
