Excel 2010 late binding on Access 2010 Project -
This is a common problem for me to distribute an access application for a client. The application has been written in Access 2010 and recently I have added some code to export excel sheet. So I added excel object library version 14.0.
My clients who run Excel 2007 now get the infamous error: mssing or broken references to the file "excel ext variant 1.7". The question is:
If I use late binding, will there be additional functionality available to it?
I want to apologize if the question sounds gullible but I am new to VBA. / P>
Yes, functionality should be available, unless you use those features that were not available in 2007. (Some table subject formats, for example using formatting 2010 is plus), then you should not have any problem to use late bond.
I think that is just the simplest effort. Ideally, running a virtual PC will be Office 2007 and develop to use it, when you target the customer using a lower version by yourself are doing.
Hope that helps.
Comments
Post a Comment