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