Save copy as, open copy, alter copy, save copy and close copy

Hi all,

I'm trying to save a renamed copy of the workbook, open the new workbook, delete the contents of some columns in the new workbook and other operations, then save and close the new workbook.

I have this code so far. It successfully saves a renamed workbook and opens it, but then I get a "not responding" and I have to shut down excel.

Please Login or Register  to view this content.

as always any help appreciated.

Reading your code I can't see that you are closing the renamed workbook and then you try to open it again? could that be the problem?

Alf

I thought I was just saving a renamed copy, so you're saying I need to close it and then re-open?

They wouldn't be the same name.