SaveAs macro in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a method of creating a macro that will initiate the worksheet to
SaveAs, specifically to a different network folder? I have a spreadsheet that
needs printing and saving to particular location, and the contents always
change. I have created the macro to print 2 pages of the worksheet but can't
figure out how to include that SaveAs piece. Many thanks.
 
' create a new workbook with just this sheet
Activesheet.copy
ActiveWorkbook.SaveAs "C:\MyFolder\File1.xls"

You haven't said how you will determine the name of the workbook.
 
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

SaveAs 2
Excel SaveAs to force overwrite of extant file 1
SaveAs? 4
In XL VBA, Word Document SaveAs throws error 8
Savecopy and saveas locking up excel 3
save and exit macro 8
Extracting Excel2007 data from structured Storage 0
SaveAs 2

Back
Top