Excel library reference files
 

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

Excel library reference files
 

use late binding for all.

--
Regards,
Tom Ogilvy

"Cindy" wrote in message
...
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

Excel library reference files
 

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
-----Original Message-----
use late binding for all.

--
Regards,
Tom Ogilvy

"Cindy" wrote in message
...
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


.

Excel library reference files
 

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.

--
Regards,
Tom Ogilvy


"Cindy" wrote in message
...
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
-----Original Message-----
use late binding for all.

--
Regards,
Tom Ogilvy

"Cindy" wrote in message
...
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


.

Excel library reference files
 

Thanks, Tom

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

Cindy
-----Original Message-----
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.

--
Regards,
Tom Ogilvy


"Cindy" wrote in message
...
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
-----Original Message-----
use late binding for all.

--
Regards,
Tom Ogilvy

"Cindy" wrote in message
...
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


.



.