VB 2005 Express - Excel 2007 - how to?

[Guest]

I *did* have Excel 2003 on my office PC and was fiddling with a little VB
Express app that interacted with Excel - nothing complex, but it worked.

Since then IT has upgraded me to Office 2007 and the only thing I can import
is Microsoft.Office.Core, nothing with the Excel object at all. My earlier
code throws off errors whenever Excel is referenced.

Is this Microsoft's way of telling me that I can't access Excel 2007 from VB
Express, or do I need to download something to make this work?

 

[rowe_newsgroups]

I *did* have Excel 2003 on my office PC and was fiddling with a little VB
Express app that interacted with Excel - nothing complex, but it worked.

Since then IT has upgraded me to Office 2007 and the only thing I can import
is Microsoft.Office.Core, nothing with the Excel object at all. My earlier
code throws off errors whenever Excel is referenced.

Is this Microsoft's way of telling me that I can't access Excel 2007 from VB
Express, or do I need to download something to make this work?

Did you add a reference to the Microsoft Excel Object Library 12.0 com
object? You must add the reference to the dll before you can start
importing namespaces.

Thanks,

Seth Rowe

 

[Guest]

Well, that was simple. Thanks for the assistance.