jfisher88

I need to referance and older version of excell to be able to get my program working on an older machine at work how can this be done. I have Microsoft Excel 10.0 Object Library on the machine I wote the program on. I need to use Microsoft Excel 9.0 Object Library. Is there something that I can copy from the older computer to get Microsoft Excel 9.0 Object Library to showup in my list of referances in VB?

Thanks In advance
Jason

Mike Rosenblum

Not that I know of... Ideally you would compile your VB6 App on a machine that had Excel 9.0 on it.

To be honest though, "binding high" (that is, compiling in Excel 10.0) and "running low" (running on an Excel 9.0 machine) should run fine. Even though this arranegement is not officially recommended ("Binding Low" and "Running High" is better) I've not been able to get this technique to fail, so long as one does not use any of the newer commands that do not exist in Excel 9.0 (which is very few).

The last option would be to use Late Binding, but I would only do that if absolutely neccessary as there are a number of drawbacks. Have a read in Herilane's Early vs. Late Binding Tutorial for more info.

But, in short, I would simply compile in Excel 10.0 and then run it on a 9.0 machine. It actually should run fine. If that does not work, then my next choice would be to load VB6 onto the Excel 9.0 PC and compile there. Then you can distribute this 9.0 version to 9.0 or 10.0 machines without any trouble. Using Late Binding would be my absolute last choice and should not be necessary...

-- Mike