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