Batch file won't close opened .xls files and finish routine

I have a simple batch file that opens 2 excel files. One updates new data to the other.

I want to then close both files, and then delete one of them.

My bat file will not process the taskkill command as long as the .xls files are open, and nothing I can think of will close or terminate these 2 open xls files.

How can I terminate open .xls files in a batch routine?

Here's my .bat >>

D:\quotes.csv | D:\Data.XLS | Pause |
taskkill /f /im excel.exe
Del E:\Box-Download\quotes.csv
pause

Thanks!

Rod

Does D:\Data.XLS update D:\quotes.csv or vice versa? Meaning, does the XLS file read in values from the CSV file using external reference formulas and save itself, or does the XLS file make changes to the CSV file then save the CSV file? Either way, why not use the XLS file's Workbook_Open event handler?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You could also embellish the batch file with

Please Login or Register  to view this content.

replacing the 1st pause.

Data.XLS updates Quotes.csv but does NOT save automatically.

I gave your event handler a try but it would not close and save the files. Or it would hang the batch processing.

The taskkill command worked by brute force , but it does not save the data after the update.

Closing AND saving open excel docs seems to be much harder than you'd expect in a command line.

START D:\data.csv
START D:\Quotes.XLS
setlocal enableextensions
set EXCELAUTOEXIT=on
D:\quotes.XLS
D:\data.XLS
pause
taskkill /f /im excel.exe
pause
del E:\Box-Download\quotes.csv
CLS

I'll try your suggestions more thoroughly.

Many thanks!
Rod

The same was here. Thank you for help