Excel library reference files

[Cindy]

Please help! I have an Excel template that uses many
library reference files - Outlook Object library - Active
X datarecord set, etc.

When users have a new version of these .dll files on their
computer, the references automatically update, but when
that is sent back to a user with an older .dll,
the "Missing library" reference appears and they get a
compile error.

I was instructedt o use "late binding" for the Outlook
reference but I need to know how to handle the other
references. Thank you.

Cindy

 

[Tom Ogilvy]

use late binding for all.

 

[Cindy]

Tom,

Where can I get help on this? I did go to
http://www.dicks-clicks.com/excel/olBinding.htm which is a
good reference but I don't know how to determine what the
number value would be in late binding - i.e.

olNs.GetDefaultFolder(9) - in the code example I found
the "9" refers to the calendar. How do I know the number
for the inbox?

Also, I don't know where to begin in references the other
library files.

Please help. Thanks

Cindy

 

[Tom Ogilvy]

During development, on your machine, use early binding - create the
references. Then you can use the object brower or the immediate window to
find the values of constants. Once you have everything working, then you
can change the code to the late binding construct.

 

[Cindy]

Thanks, Tom

I already have everything done in early binding, so I'll
give this a shot.

Cindy