| 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