-
Solved: Saving as xls
When I save my documents as .xls, a compatibility checker window pops up and I have to click continue in order for the document to save. In the below code, can I automatically have it continue so I do not have to click it manually each time?
[VBA]ChDir "G:\Katherine Lartigue\Allocations\"
ActiveWorkbook.Saveas Filename:= _
"G:\Katherine Lartigue\Allocations\JPM Private Trades.xls", FileFormat:=xlExcel8, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWindow.Close
[/VBA]
-
[VBA]
application.displayalerts = false
'code
application.displayalerts = true
[/VBA]
-
-
no problem! mark it as solved :)