Reply from Excellin on May 27 at 10:33 AM I think the best approach is to use the GUID to check on the version. Maybe, have a macro to remove the associated libraries on close, and another to install it (using the library available) on open. It's somewhat confusing, but if you do a search for Excel VBA GUID you'll probably stumble across something.
| | | ---------------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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
No comments:
Post a Comment