SaveAs macro in Excel
' 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
|