Trying to run a MSQuery from Excel as a Scheduled Task

[Doug]

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.

 

[Doug]

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??