View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saria Saria is offline
external usenet poster
 
Posts: 1
Default 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