Microsoft Excel 10.0 Object Library

[ca8msm]

Something seems to have gone wrong with the dll for the excel library. When I add a reference to the Excel 10.0 Library I used to be able to use intellisense to get options such as

Dim xlApp As Excel.Application
Dim xlApp As Excel.Adjustments
etc....

Now the only option I get is

Dim xlApp As Excel.Adjustments

As there used to be a lot more options I presumed that the DLL was corrupt so I deleted then re-installed Office but to no avail. Anyone come across anything similar?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.