VB 2005 Express - Excel 2007 - how to?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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
 
Back
Top