Rocky Smolin
rockysmolin at bchacc.com
Wed Apr 16 13:38:51 CDT 2014
Dear List: I am trying to create a runtime A2010 app which was converted to an accdb from an mdb. When I install the runtime (using a clean VM - only W7) it won't start but tells me I'm missing Excel.exe. I do have the references set in the accdb to Microsoft Excel 14.0 Object Library. The only place in the code where Excel appears is: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet and then Set xlBook = GetObject(Me.txtBidsJobsSpreadsheet) Set xlApp = xlBook.Parent Set xlSheet = xlBook.Sheets(1) I also use Transferspreadsheet: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryClientSearchCounts", _ gstrFrontEndPath & "ClientSearchCounts-" & Format(Date, "mmddyyyy"), True MsgBox "Client Search Counts Exported To: " & gstrFrontEndPath & "ClientSearchCounts-" & Format(Date, "mmddyyyy") but all acSpreadsheetTypeExcel9 and that probably wouldn't make any difference until it executes, if then. I'm also getting a similar message about an outlook dll - same sort of thing: Dim myolApp As Outlook.Application Dim myItem As Outlook.MailItem and Set myolApp = CreateObject("Outlook.Application") Set myItem = myolApp.CreateItem(olMailItem) I have the reference set to Outlook 14.0 object library. Is anyone familiar with the workings of the runtime packager and know why I'm getting these missing references? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin