Save as file format excel worksheet 4.0 in Microsoft excel 2007
Hello,
Working with Microsoft Office 2003,I have generated a macro that saves each worksheet of a workbook in a separate workbook . Upon changing the version of Microsoot Office from 2003 to 2007, the vba code did not work. I tried the online Microsoft Office solution of hiding the excel worksheets that i do not need to save, but these worksheets will always be saved and appear when unhiding them. Please help? Is there any add-ins that might help me to use the file format "worksheets excel 4.0" in a Microsoft Office 2007 environment. Thank you |
Save as file format excel worksheet 4.0 in Microsoft excel 2007
Perhaps you could amend your macro so that if a sheet is hidden then
you skip over it and do not save it. Hope this helps. Pete On Jul 14, 11:26*am, Saria <Saria @discussions.microsoft.com wrote: Hello, Working with Microsoft Office 2003,I have generated a macro that saves each worksheet of a workbook in a separate workbook . Upon changing the version of Microsoot Office from 2003 to 2007, the vba code did not work. I tried the online Microsoft Office solution of hiding the excel worksheets that i do not need to save, but these worksheets will always be saved and appear when unhiding them. Please help? Is there any add-ins that might help me to use the file format "worksheets excel 4.0" in a Microsoft Office 2007 environment. Thank you |
All times are GMT +1. The time now is 05:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com