Saving spreadsheets from a macro

**warpspeed** · 07-28-2010, 03:10 PM

Hi all!
I am new to this forum, I like to work things out for myself but this problem has been driving me nuts!

I have a macro which files a copy of the spreadsheet containing the macro to a folder and file specified within the worksheet then the worksheet closes.
What I would like to do is save the file as a copy and close without closing the original.
The code below is what I am working with:

Please Login or Register  to view this content.

I am sure this will be an easy one for someone

**Leith Ross** · 07-28-2010, 04:08 PM

Hello warpspeed,

Use SaveCopyAs instead of SaveAs.

Please Login or Register  to view this content.

**warpspeed** · 07-28-2010, 04:51 PM

Thanks for that Leith,

I have ammended the code to

Please Login or Register  to view this content.

by removing

Please Login or Register  to view this content.

the book remains open, as I intended, the file is generated but has no .xls extension, I know the file is a spreadsheet and the right one to boot if I open with exel and selecting from 'all file types'
Cheers
Warpspeed