Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro using relative references | Excel Worksheet Functions | |||
Macro to Formula References | Excel Discussion (Misc queries) | |||
Macro without cell references...... | Excel Discussion (Misc queries) | |||
Confusing Macro and references.... | Excel Programming | |||
macro vba relative references | Excel Worksheet Functions |