Create copy of spreadsheet

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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
 
Hi Les
WorkSheets("YourSheet").Copy
ActiveworkBook.SaveAs "F:\Folder\Name.xls"

HTH
Cordially
Pascal
 
Harald and Pascal,

Thank you both for your quick responses. I got it done
now.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to incoporate new macros into existing spreadsheet? 1
Copy Current Month into YTD Spreadsheet 1
Copy from one source to multiple spreadsheets 1
Excel shortcut options 0
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Copying data from several spreadsheets into a new spreadsheet 2
Auto Sort 0
Help with creating a Macro to copy data from Excel to Word. 0

Back
Top