I have a macro-enabled Excel file that, once opened, will refresh the connection (and thereby refresh the data), save the file and exit Excel.
I have tried to use Task Scheduler to have this file be opened automatically, and the internal macro finish the process, but it seems that Task Scheduler will not open the file since it's on a network.
Every suggestion I have seen on various message boards provides a solution that assumes the target file is on the same computer as the Task Scheduler.
Does anybody have a solution for this?
I have tried to use Task Scheduler to have this file be opened automatically, and the internal macro finish the process, but it seems that Task Scheduler will not open the file since it's on a network.
Every suggestion I have seen on various message boards provides a solution that assumes the target file is on the same computer as the Task Scheduler.
Does anybody have a solution for this?