I have an Excel file that connects to a cloud server and lives in OneDrive with AutoSave enabled. I have the file set to run a query upon opening the file. I have been automating opening and closing the file (thereby running the query) with .bat files on a scheduler.
I thought this would be something I could do with PAD. This is my first attempt at PAD. But when I test the flow, the query does not run in the background. It only opens the file. Not sure what I'm doing wrong. When I launch this file myself, the query runs.

Report
All responses (
Answers (