Hi experts!
I seem to have gotten a problem with regards to reference files. I have an access 2000 program that will get data from an excel file. Only problem is some of my users are using Excel 2000 while the others are using Excel 2002.
The reference file is different for both versions (Excel.exe for 2002, Excel9.olb for 2000). I was trying to add/remove the reference files dyanamically (upon load of the access program - this is because some of the users may upgrade to Excel 2002 in the near future) but I always get a compile error (User defined type not defined) upon load since the reference file is not set up yet. Is there a way to get my VBA code of setting up the reference files to be be called up first or should I just make two programs instead? (One with reference for Excel 2002, another with reference for Excel 2000).
Thanks!
Start Free Trial
