Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



.



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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


.



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for an Excel macro function reference library for Excel 20 Max Excel Discussion (Misc queries) 3 December 28th 07 10:11 PM
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library [email protected] Excel Discussion (Misc queries) 3 May 1st 07 06:57 PM
Library Reference files Cindy Excel Programming 4 April 2nd 04 04:42 PM
Excel Object Library Reference francis cheuk Excel Programming 1 February 11th 04 06:15 PM
Setting up Reference Library using VBA Alan Excel Programming 1 November 5th 03 03:18 AM


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"