Jim: the problem is the saveas closes the oringal workbook and only nleaves
the saveas file opened. if yo want to go back to the original file you have
to re-open the workbook.

"Jim" wrote:

ActiveWorkbook.Close
' closes the active workbook and lets the user decide if
' changes are to be saved or not

On Feb 13, 2:26 pm, MrRJ wrote:
Hi,

I have built a macro in which it has done it thing. Now, it is complete,
can I close the file that contains the macro too? Is that possible?

MrRJ