PDA

View Full Version : Solved: Saving as xls



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

CatDaddy
04-17-2012, 09:11 AM
application.displayalerts = false
'code
application.displayalerts = true

Klartigue
04-17-2012, 11:49 AM
Works great, thank you!

CatDaddy
04-17-2012, 11:54 AM
no problem! mark it as solved :)