F
Fox via OfficeKB.com
MS Office on my machine was recently upgraded from 2000 to 2003. In one of
my macros I had references to Office, Excel, Word, Outlook, and Powerpoint
object libraries, which, upon opening now in Excel 2003, changed from 9.0 ro
11.0. I converted to late binding to eliminate the Word, Outlook, and
Powerpoint object library references. I was also going to do the same to
eliminate Office and Excel references, but found when the macro is opened in
Excel 2000, they are converted back to 9.0. Any idea why it would change
these two library references, but not any others?
I have a small subroutine that can loop through and list the libraries that
are in the workbook, but is there any way to determine programatically what
libraries a user has available, but not checked? For instance, could I
determine programatically that the macro is opened on a machine that has the
Outlook 9.0 library available but not checked off and then tell the macro to
include it even if I don't know where the file is located?
my macros I had references to Office, Excel, Word, Outlook, and Powerpoint
object libraries, which, upon opening now in Excel 2003, changed from 9.0 ro
11.0. I converted to late binding to eliminate the Word, Outlook, and
Powerpoint object library references. I was also going to do the same to
eliminate Office and Excel references, but found when the macro is opened in
Excel 2000, they are converted back to 9.0. Any idea why it would change
these two library references, but not any others?
I have a small subroutine that can loop through and list the libraries that
are in the workbook, but is there any way to determine programatically what
libraries a user has available, but not checked? For instance, could I
determine programatically that the macro is opened on a machine that has the
Outlook 9.0 library available but not checked off and then tell the macro to
include it even if I don't know where the file is located?