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