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

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

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

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




.

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




.

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




.

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




.

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




.



.

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




.



.

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