Referencing object library?

[roo20487]

Hello everyone,

Please help me, I'm creating a program in VB that will access data in an access database.

I have to create an automated letter in Word as well as create a few graphs using Excel.

I've gone to 'Add Reference' and have referenced the Word and Excel object libraries and I can see them and add them. But when I go to project properties --> references the reference path for Word and Excel are, <The system cannot find the reference path specified>. And so I cant use Word and Excel with my application until I fix this and it doesnt recognise the code.

I can connect to the access database no problem at all. I just dont know how to fix this and it is driving me nuts, please help me!

[jmcilhinney]

What were the exact names of the references you added?

[roo20487]

Their names were,

Microsoft Word 11.0 Object Library
Microsoft Excel 11.0 Object Library

[stanav]

Try removing them then re-adding them to see if it fixes your problem.

[roo20487]

Nope I've tried that.

I've also tried re-installing both VB and the Office Package.

Please I desperately need this fixing?!

[danasegarane]

you can try like this, without adding reference

dim x as object
x=server.createobject("Excel.Application") 
'If excel is not installed it will throw an "ActiveX Cannot Create object Error"

Hope this Help