open a excel XP in 2000

[Christof DeBa]

Probably a stupid question to which I know the answer
anyway, but I try it anyway:

Is there a way to open an excel XP file (with VBA code) on
a win 98 or win ME machine?

Can an office XP module be installed to have it backwords
compatible to one of the aabove mentionned config's?

Thanks in advance for any suggestions.

Christof

 

[Frank Kabel]

Hi
if you have Excel97 or higher installed on this machine:
no problem. But you need Excel (or a different spreadsheet
application which is able to open .xls files)

 

[Christof De Ba]

Hi Frank,

thanks for the info. I've also further looked into it and
it seems to be a problem with Word: from my VBA code in
Excel I need the Word object. So I included 'Word 10
object library'on the XP machine. Now, on the older
machine, there is no Word10, only previous Word version
(Word 9 object library)

I know that late binding needs to be used, but then which
library do I need to add to the reference list? Is there
a 'generic Word library'?


Christof

 

[Frank Kabel]

Hi
if you use late binding no need for setting a reference
(that's the idea behind this procedure)

 

[christof]

Thanks Frank,

I said these were going to be stupid questions

Christof