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.

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.

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.

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.


.