Help with saveas
Using Excel 2k
I have workbook that contains several worksheets. I need to save some of those sheets as individual workbooks. I know I can copy them out as a csv file but I need to save them as xls and retain the formating. Is that possible? Glen |
Help with saveas
Glen
right click on the sheet you want to make into a new workbook. Select "Move or Copy ..." from the option list. In the top box, select "(new book)" and click on "Create a copy". Save the new workbook and/or email it out, whatever. Regards Trevor "Glen Mettler" wrote in message ... Using Excel 2k I have workbook that contains several worksheets. I need to save some of those sheets as individual workbooks. I know I can copy them out as a csv file but I need to save them as xls and retain the formating. Is that possible? Glen |
Help with saveas
I need to do this programmatically. You put me on the right track. It
works just fine. Thansk! Glen "Trevor Shuttleworth" wrote in message ... Glen right click on the sheet you want to make into a new workbook. Select "Move or Copy ..." from the option list. In the top box, select "(new book)" and click on "Create a copy". Save the new workbook and/or email it out, whatever. Regards Trevor "Glen Mettler" wrote in message ... Using Excel 2k I have workbook that contains several worksheets. I need to save some of those sheets as individual workbooks. I know I can copy them out as a csv file but I need to save them as xls and retain the formating. Is that possible? Glen |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com