[AccessD] A2010 packager

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
 

 
 


More information about the AccessD mailing list