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
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 . |
#4
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 |
#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
Lionel,
Converting the code to late binding is quite simple. Whenever you have a declaration like Dim X As Excel.something ' e.g., Application, Workbook, Worksheet, Range, etc change it to Dim X As Object Then, use CreateObject to create the Application object. E.g., instead of using Set XL = New Excel.Application use Set XL = CreateObject("Excel.Application") -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "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 . |
#9
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 |