Hi

I have used the devloper edition a few times to provide a simple database with the run time files where the client did not have a copy of MSOffice.

I have not ever had to provide an Access database and the ability to use Excel. Recently I had such a request.

I am having difficulty in achieving this....To indicate my level of skill I know how to use the packaging wizard...end of story.

Heres what I have done to date

Created the Dabatase. Created a Blank .xls workbook.

When using the wizard I included the XL DLL (Having found its locations by going into references in the VBA editor
I also included the Blank .xls WorkBook

Lastly I placed a command button on one of the forms in the dbase with the following code attached to the click event. The syntax is I think what is called late binding and is appropriate to that which I am trying to achieve (allegedly)

Private Sub CmdOpenXLApp_Click()
On Error GoTo Err_CmdOpenXLApp_Click

    Dim oApp As Object

    Set oApp = CreateObject("Excel.Application")
    oApp.Visible = True
    'Only XL 97 supports UserControl Property
    On Error Resume Next
    oApp.UserControl = True

Exit_CmdOpenXLApp_Click:
    Exit Sub

Err_CmdOpenXLApp_Click:
    MsgBox Err.Description
    Resume Exit_CmdOpenXLApp_Click

End Sub


When I take the output from the packaging wizard and load it on to a PC (Without MSoffice) it does run the Access dbase but clicking the command button does not open excel to manipulate the xlsWorkbook

Advice appreciated

MF

I think this line is causing the trouble:

Set oApp = CreateObject("Excel.Application")

Why don't you use a .csv file instead, and set it up like Excel. Then if someone wants to use Excel, it will open the file with no problem.

I don't think you can develop the entire application using Office file formats and not have Office installed.

mmcdonal

Look it up at: http://wrox.books24x7.com