Create copy of spreadsheet
 

After I finish updating my spreadsheet, I would like to
have a way to automatically make a copy of it, and place
it on a different path on our lan.

Can I do something like this with a macro? How would I go
about doing it?

Thanks much.

Create copy of spreadsheet
 

Hi

If you by Spreadsheet mean the whole workbook, use the macro command
SaveCopyAs. If you mean one of the sheets in the workbook to a separate
single file, then copy the sheet to a new workbook, save it and close it.
record a macro doing it for code.

HTH. Best wishes Harald

"Les" skrev i melding
...
After I finish updating my spreadsheet, I would like to
have a way to automatically make a copy of it, and place
it on a different path on our lan.

Can I do something like this with a macro? How would I go
about doing it?

Thanks much.

Create copy of spreadsheet
 

Hi Les
WorkSheets("YourSheet").Copy
ActiveworkBook.SaveAs "F:\Folder\Name.xls"

HTH
Cordially
Pascal

"Les" a écrit dans le message de
...
After I finish updating my spreadsheet, I would like to
have a way to automatically make a copy of it, and place
it on a different path on our lan.

Can I do something like this with a macro? How would I go
about doing it?

Thanks much.

Create copy of spreadsheet
 

Harald and Pascal,

Thank you both for your quick responses. I got it done
now.

-----Original Message-----
Hi Les
WorkSheets("YourSheet").Copy
ActiveworkBook.SaveAs "F:\Folder\Name.xls"

HTH
Cordially
Pascal

"Les" a écrit dans
le message de
...
After I finish updating my spreadsheet, I would like to
have a way to automatically make a copy of it, and place
it on a different path on our lan.

Can I do something like this with a macro? How would I
go
about doing it?

Thanks much.


.