Compatibility of workbook issue 1

[BH]

Hi
From a command button in an Excel spreadsheet I am filtering data and copying into a new workbook a number of times. I am working with Excel 2010 and saving the new workbooks in 2003-2007. Everything works really well other that I constantly get the the Compatibilty checker message box come up. Is there a way I can code to disable the checker for the newly created workbooks?

THE MESSAGE APPEARS AT THIS POINT:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\bhbha\Desktop\Urgent_Care\C84125 Urgent_Care_Reular_Users_June-August 2011.xls" _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Your help is much appreciated

thank you

BH

 

[SkipVought]

Hi,

First, you are saving your workbook as an Excel 97-2003 .xls workbook. This does NOT include 2007. It is "compatability mode".

Second, VBA questions are best handled in forum707.

In your case, try using Application.DsiplayAlerts = FALSE

Application.DsiplayAlerts = FALSE
ActiveWorkbook.SaveAs Filename:= _
        "C:\Documents and Settings\bhbha\Desktop\Urgent_Care\C84125 Urgent_Care_Reular_Users_June-August 2011.xls" _
        , FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
        ReadOnlyRecommended:=False, CreateBackup:=False
Application.DsiplayAlerts = TRUE

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BH]

Thanks SkipVought

Brill, works a treat.....after I realised Dsiplay was slightly misspelt lol!

Other points took on board!

 

[SkipVought]

Sorry. I am dyslexic. I try to be careful, but often fail!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BH]

No problem....just very thankful for you assistance.

Thanks again