Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looking for an Excel macro function reference library for Excel 20 | Excel Discussion (Misc queries) | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Library Reference files | Excel Programming | |||
Excel Object Library Reference | Excel Programming | |||
Setting up Reference Library using VBA | Excel Programming |