Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
I am writing code in Excel 2000 and am using a library
Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Micosoft Office 9.0 Object Library.
This library will automatically will 8.0 when you run your workbook in Excel 97. Other references like Outlook for example will not do this. You must open the file in Excel 97 and uncheck the missing reference and check the good one and save the file before you distribute the file. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Lionel,
You can usually overcome this sort of problem with late binding. Post the code and we can address specific issues. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Ron
I did try this, but I cannot uncheck the "MISSING" reference. as the dialog box says it in use, even though I did check the 8.0 library. Can you help? Lionel -----Original Message----- Micosoft Office 9.0 Object Library. This library will automatically will 8.0 when you run your workbook in Excel 97. Other references like Outlook for example will not do this. You must open the file in Excel 97 and uncheck the missing reference and check the good one and save the file before you distribute the file. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Bob
There is quite a lot of code. Should I post the whole spreadsheet with the code, or e-mail it to you with the spreadsheet attached? Lionel -----Original Message----- Lionel, You can usually overcome this sort of problem with late binding. Post the code and we can address specific issues. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Lionel,
Sure, as long as you can wait till the weekend. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... Bob There is quite a lot of code. Should I post the whole spreadsheet with the code, or e-mail it to you with the spreadsheet attached? Lionel -----Original Message----- Lionel, You can usually overcome this sort of problem with late binding. Post the code and we can address specific issues. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Ron
When I open the file in XL 97 the 9.0 Object Lib is stated as "MISSING" and won't allow me to uncheck. Even if I check the 8.0 lib, the program baulks at teh "MISSING" statement. Is there another way to get the missing 9.0 off the Reference list, or to have 8.0 installed before I distribute? Lionel -----Original Message----- Hi Lionel For the Micosoft 9.0 Object Library you don't have to do anything when you open it in Excel 97 it will be 8.0. ? -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Lionel Fridjhon" wrote in message ... Ron I did try this, but I cannot uncheck the "MISSING" reference. as the dialog box says it in use, even though I did check the 8.0 library. Can you help? Lionel -----Original Message----- Micosoft Office 9.0 Object Library. This library will automatically will 8.0 when you run your workbook in Excel 97. Other references like Outlook for example will not do this. You must open the file in Excel 97 and uncheck the missing reference and check the good one and save the file before you distribute the file. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel . . |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
Bob
I e-mailed you the code, using the function in this newsgroup program, but I am not sure if it went off. I see that you do have an e-mail address and am e-mailing another attachment through my own e-mail. Lionel -----Original Message----- Lionel, Sure, as long as you can wait till the weekend. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... Bob There is quite a lot of code. Should I post the whole spreadsheet with the code, or e-mail it to you with the spreadsheet attached? Lionel -----Original Message----- Lionel, You can usually overcome this sort of problem with late binding. Post the code and we can address specific issues. -- HTH Bob Phillips "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel . . |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object libraries
http://support.microsoft.com/?id=244167
see links at the bottom as well. -- regards, Tom Ogilvy "Lionel Fridjhon" wrote in message ... I am writing code in Excel 2000 and am using a library Micosoft Office 9.0 Object Library. The program will not work in Excel 97 because the relevant library used in Excel 97 is Micosoft Office 8.0 Object Library. How can I either install 8.0 in my XL 2000 or alternatively, install 9.0 in XL 97? Lionel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help locating Object Libraries | Excel Discussion (Misc queries) | |||
Reference Libraries and Add-Ins | Excel Discussion (Misc queries) | |||
Importing libraries | Excel Discussion (Misc queries) | |||
Cannot open Excel, message given is about VBA libraries? | Excel Discussion (Misc queries) | |||
Libraries In Excel VB Editor | Excel Programming |