Referencing Excel Object Library
Posted on 2013-11-21
There are over 75 computers on a LAN that run an Access 2003 application. The application was recently modified to reference the "Microsoft Excel 15.0 object library" and now includes VBA code to open an existing spreadsheet, modify the spreadsheet and save it. Other computers on the LAN that need to run this Access .mdb program either have an older version of excel or don't have excel installed.
The program didn't open on a computer that has an older version of excel (with a runtime version of Access 2003), so I found the path that the referenced file is in on the source/development computer (c:\Program Files\Microsoft Office 15\Root\Office15"), created that exact path on the other computer and copied the referenced file (excel.exe) to it. The program then opened on the other compter, but the code to open a spreadsheet and modify it did not work.
How can I get the program to work on all the computers? Everyone needs to be able to not only open the access program but also run the code to modify the spreadsheet. I was hoping that I could copy version 15 of excel.exe to a network share and reference it from there, but I doubt this would work given that the code to modify the spreadsheet didn't work after creating the same exact path on the other computer and copying excel.exe to it.