I want to create a batch file that will run a .dqy file in excel and save.
My problem is when I run the script I have, it opens the file in excel but the query takes a few seconds to run so the new saved file gets created with no data before the query runs.
"C:\Program Files\Microsoft Office\Office\Excel.exe" "C:\CurrentDietOrders.dqy" > C:\SNH_CurrentDietOrders.xls
I tried a pause command but that doesn't seem to work. All I want to do is run the dqy file and save it in a directory for a department to retrieve.