Klartigue
04-17-2012, 08:27 AM
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?
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
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