Save as file format excel worksheet 4.0 in Microsoft excel 2007

[Saria]

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

 

[Pete_UK]

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