I have office 2007 Pro installed on a Win 10 PC. The program runs fine on my PC from within Access and as a package install where Excel 2007 opens with the file.
When I install the program on a Win7 PC with Office 10 Small Business (so no Access 2010) the program runs normally until the last macro where it dies in the function OpenExcel() at the last step that I have shown in the code.
If I comment out this line (and all the other lines that use Excel) the program ends normally (but doesn't open the .xlsm spreadsheet, copy over data into cells). I have not enclosed the rest of the code as I began commenting out 1 line at a time to see where the code fails, and the last line I am showing generates the Action Failed 2950 error and causes the program to close when you click on Stop All Macros. The Macro has 4 Run Commands in it, all work except this macro that points to this function.
I am using the Microsoft Excel 12.0 Object Library
I am installing the package off the root drive, C:\PRISM\ which I have also added in Access as a trusted location.
I am guessing but wonder if it has to do with the Excel 12.0 Object Library, I assume that it would be brought over in the runtime modules but maybe not. I can't test it on my machine because it works on mine.
Dim DB As DAO.Database
Dim Fil As DAO.Recordset
Dim AppExcel As Excel.Application
Dim PrsMod As Excel.Workbook
Dim PrsFrm As Form
Set DB = CurrentDb()
Set Fil = DB.OpenRecordset("SetupLoc")
Set AppExcel = CreateObject("Excel.Application")