The problem probably stems from the fact that you have a later version of
Word/Outlook than the users.
Solution 1: do you have a copy of the same version, and can you build the
macros in that version?
Solution 2: have you heard of late binding. Late binding binds to the object
library at run time, not at compile time, so it will pick up whatever
library that they have. You have to code differently, for instance, instead
of
Dim olApp As Outlook.Application
Set olApp = New Outlook.Application
you would use
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")
it also means that you cannot use application constants, you have to hard
code them. I have written a small paper on a technique, written for Outlook
but the technique is generic, which you can read at
http://xldynamic.com/source/xld.EarlyLate.html
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Dave Shaw" wrote in message
...
I'm tearing my hair out here. I have an Excel Template containing macros
which do things using word and outlook. I have therefore added the
relevant
references.
When a user creates a new file using the template and a macro is run the
message "can't find project of library" occurs. The references seem to be
there but the problem occurs on every line.
Can anyone tell me how to rectify this? it is not feasible to make
adjustments to individual's machines.
thanks in advance