ExcelBanter - Closing files and saving files

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Closing files and saving files (https://www.excelbanter.com/excel-worksheet-functions/104975-closing-files-saving-files.html)

dan

Closing files and saving files

I have opened a file for reference in a macro and have another opened for
processing the data.

I want to automatically close the reference file and then open a window
asking if the user wants to save the processed file. If they select yes then
a browser window appears for them to save the file to their location of
choice.

Thanks

All times are GMT +1. The time now is 09:28 PM.