VBA Save As as 2003 document

[I heart Excel]

Hello,

I have set up a form in Excel 2007 and once finished realised the person who will use the form has Excel 2003!!

I have amended the form but I have a problem... On the form there is a 'save as' button which saves the form as a specific name in another location. However it is saving it as an Excel 2007 macro form and then when I try and open this in 2003 it can't and won't!

Any ideas on how I can get this to save as 2003?! This is the code I have at the moment, and I have tried adding the Fileformat = 56, but it doesn't do anything -

Sub SaveAs()
ThisFile = Range("B11").Value & ".xls"
ActiveWorkbook.SaveAs Filename:="S:\pauldidy\Sickness Forms\Pending\" & ThisFile

End Sub

Thanks for you help,

 

[VoG]

This should work

Sub SaveAs()
ThisFile = Range("B11").Value & ".xls"
ActiveWorkbook.SaveAs Filename:="S:\pauldidy\Sickness Forms\Pending\" & ThisFile, FileFormat:=56

End Sub

 

[I heart Excel]

I just put this into the form and it is still saving as a 2007 Macro document.

I thought this may just be my PC as I have 2007 as well as 2003, but I tried it on my colleagues PC and it still is saving it incorrectly. I have gone through the rest of the Macro and have made sure that everything is "xls", I even tried taking this out and putting in the "FileFormat:=56", but this still didn't work.

I am getting the following error message when I try and open the document in 2003 =

'Excel cannot open the file 'Bob Brown.xlsm' because the file format or file extension is not valid. Verify the the file has not been corrupted and that the file extension matches the format of the file.'

Not too sure how to get around this. Thanks for your help.

 

[VoG]

I cannot see how it is saving as .xlsm if you specify the file extension as .xls

Maybe install this for Excel 2003 http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3