SaveAs macro in Excel
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 |
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 |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com