Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to run a MSQuery from Excel as a Scheduled Task
I have a scheduled task set up to run a MSQuery in Excel. When the task runs
Excel starts the Query starts and then it stops and waits for me to say I trust the source of the file. Is there some way to tell the system I trust the source so it will just run? Also, is there a way to automatically run a macro on the query results that are returned? So I will have a scheduled task that will run a MSQuery in Excel and once the query results are returned to a worksheet a macro will run to edit the contents, all without user intervention. Thank you in advance for any help you might give. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to run a MSQuery from Excel as a Scheduled Task
"Doug" wrote: I have a scheduled task set up to run a MSQuery in Excel. When the task runs Excel starts the Query starts and then it stops and waits for me to say I trust the source of the file. Is there some way to tell the system I trust the source so it will just run? Also, is there a way to automatically run a macro on the query results that are returned? So I will have a scheduled task that will run a MSQuery in Excel and once the query results are returned to a worksheet a macro will run to edit the contents, all without user intervention. Thank you in advance for any help you might give. I have tried putting the MSQuery into a Macro and that works great while I am in Excel. I have stored the macro in my Personal Macro Workbook. When I try to specify I want Excel to run PERSONAL.XLS!ESB_Load (the macro I created) I get an error that the file cannot be found. How do you specify the macro name?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scheduled data capture in Excel | Excel Worksheet Functions | |||
Refresh an excel spreadsheet on a scheduled basis | Excel Discussion (Misc queries) | |||
Excel macro's to run at a scheduled time | Excel Discussion (Misc queries) | |||
How to change scheduled payment amount in Excel | Excel Worksheet Functions | |||
Pivot Table through Scheduled Task | Excel Discussion (Misc queries) |