Disable Compatability check in Macro

I'm presuming that this message comes up during a macro? If so can you pls post your code
Cheers
Dave

Yes it does... It comes up twice... I save the file three time in this macro..
first as a xls, second it saves the current sheet as csv, and finally is saves again as a xls. The user has to clear three compatability warnings even if unchecked in Excel Options

Sub CreateTierPricing()
 
 
    ActiveWorkbook.SaveAs Filename:="Z:\EXCEL\PriceList\ASMPL" & Format(Date, "mm-dd-yy") & Format(Time, "hhmm") & " .xls", FileFormat:= _
        xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False
 
    ActiveWorkbook.SaveAs Filename:="\\Swsvr\shiloh\IMPORTS\TierP\" & "Tier_Pricing.csv" _
    , FileFormat:=xlCSV, CreateBackup:=False
    
    
MsgBox ThisWorkbook.Path & "\" & ThisWorkbook.Name
    ActiveWorkbook.SaveAs Filename:="Z:\EXCEL\PriceList\ASMPL" & Format(Date, "mm-dd-yy") & Format(Time, "hhmmss") & " .xls", FileFormat:= _
        xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=True
        
End Sub

Select allOpen in new window

Perfect!! Thanks...

No probs :)