Macro to save spreadsheet as different excel version

[Dave]

Hi,

basically I have a copy of approach '97 which when you export a file
to excel does it as excel version 3.0 (no I can't u/g approach
unfortunately)

Consequently when my macro in Excel imports the data, formats and
eventually saves the spreadsheet it saves it as excel version 3.0 The
problem is that I use conditional formatting which isn't supported in
3.0 so it doesn't save the spreadsheet properly.

Question - how do I amend the following part of my macro to save as
the latest version as this only saves as version 3.0?

Dim str As String
str = Trim(VBA.Format(Now(), "DDMMYYYY"))
Debug.Print str
ActiveWorkbook.SaveAs Filename:="C:\lotus\Ocean " & str & "XLS"

Thank experts!

 

[MattShoreson]

Try something like...

.SaveAs Filename:="BalanceSheet.xls", FileFormat:=xlWorkbookNormal

There are many dif file formats you can use.

Just type FileFormat in help file.

Hope this is OK