Bob Altman
2009-07-31 20:20:37 UTC
Not sure if this is the correct NG for this question, but it's close...
We have an existing managed app that was written to work with the COM object
model exposed by Office 2003. The app uses .Net magic to get what appears
to be managed references to the following COM libraries (as shown on the
References page):
Microsoft Excel 12.0 Object Library, version 1.3.0.0
Microsoft Office 10.0 Object Library, version 2.2.0.0
Microsoft Visual Basic for Applications Extensibility..., version 5.3.0.0
OLE Automation, version 2.0.0.0
The developer of this application has since upgraded to Office 2007, and now
(to noone's great surprise) the project doesn't build. The first couple of
errors in the Error List are:
There are updated customer wrappers available for Excel, Microsoft,
Office, Core
The actual errors that prevent compilation are that VS can no longer resolve
references to Excel.Workbooks, Excel.Worksheet, etc.
So, here's the question: Some customers still use Office 2003, while some
customers have upgraded to Office 2007. Is there some way that we can
update the project so that it works with either version of Office?
TIA - Bob
We have an existing managed app that was written to work with the COM object
model exposed by Office 2003. The app uses .Net magic to get what appears
to be managed references to the following COM libraries (as shown on the
References page):
Microsoft Excel 12.0 Object Library, version 1.3.0.0
Microsoft Office 10.0 Object Library, version 2.2.0.0
Microsoft Visual Basic for Applications Extensibility..., version 5.3.0.0
OLE Automation, version 2.0.0.0
The developer of this application has since upgraded to Office 2007, and now
(to noone's great surprise) the project doesn't build. The first couple of
errors in the Error List are:
There are updated customer wrappers available for Excel, Microsoft,
Office, Core
The actual errors that prevent compilation are that VS can no longer resolve
references to Excel.Workbooks, Excel.Worksheet, etc.
So, here's the question: Some customers still use Office 2003, while some
customers have upgraded to Office 2007. Is there some way that we can
update the project so that it works with either version of Office?
TIA - Bob