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.
--
Penni
Hillsborough, NC

' 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.

--
Regards,
Tom Ogilvy

"Penni" wrote in message
...
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.
--
Penni
Hillsborough, NC