Quick Excel 2000 VBA question
Hmm. Ok I still haven't sorted out my problems, maybe it will help if i
explain things better. I have written a program using Visual Basic for
Applications and Excel, but all the development machines have Excel
2003, and it's meant to work with Excel 2000. I'm not really sure how
to build a version that works with Excel 2000.
This could all be completely wrong, but here's what I was thinking.
I recall from somewhere that Excel9.olb just contains information about
the methods exposed by the excel COM object(s). So I thought copying
Excel9.olb from a different machine and importing it into my visual
stuido project would help.....no such luck. I assume that I import
Excel9.olb my adding it to the references list, but for some reason it
just adds a reference to Excel 2003(loaded on this machine).
Basically I don't know how to build an Excel2000 compatible version of
my program from a machine that has Excel2003(or even if its possible).
Thanks,
Rohan Shah
|