By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Multiple Concurrent 'References' to MS Excel?

P: n/a
I'm debugging an app that has a Reference to Excel 9.0 (i.e. Office 2000's
Excel).

A guy who is trying to test it for me has Office 2003 (Excel 10? Excel 11?)
installed on his PC and the most I've gotten out of him so far is that "There's
some kind of error".

He'll be shipping me the error log, but it seems likely from here that the
Reference to 9.0 is breaking on his PC.

What if I installed Office 2003 alongside of 2000 on my PC and put a second
reference to MS Excel in the app - to the 2003 version?

Reason I'm asking and not just trying is that, even if it appears to work, it
sounds like something fraught with unexpected problems...
--
PeteCresswell
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
AFAIK, you cannot set references to more than one version of any product.

If you need to support multiple versions of Excel, you're better off not
setting a reference, and use Late Binding instead. Tony Toews has some
introductory information about late binding at
http://www.granite.ab.ca/access/latebinding.htm
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"(Pete Cresswell)" <x@y.z> wrote in message
news:5a********************************@4ax.com...
I'm debugging an app that has a Reference to Excel 9.0 (i.e. Office 2000's
Excel).

A guy who is trying to test it for me has Office 2003 (Excel 10? Excel
11?)
installed on his PC and the most I've gotten out of him so far is that
"There's
some kind of error".

He'll be shipping me the error log, but it seems likely from here that the
Reference to 9.0 is breaking on his PC.

What if I installed Office 2003 alongside of 2000 on my PC and put a
second
reference to MS Excel in the app - to the 2003 version?

Reason I'm asking and not just trying is that, even if it appears to work,
it
sounds like something fraught with unexpected problems...
--
PeteCresswell

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.