Reply from VeenaMG on May 27 at 3:06 PM Hi, Write it before Saveas...: TargetWB.CheckCompatibility = False TargetWB.Application.DisplayAlerts = False TargetWB.SaveAs _ Filename:=SavePath & varState & "_" & varBranch & "_" _ & varBranchActivity & "_" & varYear & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Regards Veena
| | | ---------------Original Message--------------- From: PeterF Sent: Friday, May 25, 2012 12:00 AM Subject: Compatibility Check Getting Compatibility Checker dialog when using VBA to produce multiple copies of workbook - I am using excel 2007, wanting to save as 97 through 2003. Dialog appears when it gets to the statement: TargetWB.SaveAs _ Filename:=SavePath & varState & "_" & varBranch & "_" & varBranchActivity & "_" & varYear & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False where within the above would I add the following: TargetWB.CheckCompatibility = False Thank you PF | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment