By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 3,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Office 9 library

P: n/a
Microsoft Office 9 object library

I cannot understand what fails to my code for creating a reference to
the Microsoft Object library.it seems to me that the code is all right,
the path is the same
but my code does not produce a reference to this library.
Could someone help me ?
Function AddOffice9() As Boolean
Dim ref As Reference, strFile As String
strFile = "C:\Program Files\Microsoft Office\Office\MS09.DLL"
On Error GoTo Error_AddOffice9
Set ref = References.AddFromFile(strFile)
AddOffice9 = True
Exit_AddOffice9:
Exit Function
Error_AddOffice9:
'MsgBox Err & ": " & Err.Description
AddOffice9 = False
Resume Exit_AddOffice9
End Function

May 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Is there an error message generated? IF so, what is that message? Are yo
certain that the file path you provide is correct?

May 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.