Hello All

I'm trying to open an existing Excel file from a button on an Access form and then pass control over to the Excel file to make some changes. Is it possible to do this from Access?

Any help is much appreciated.

Sach

If u want to get some data from Excel file into your database of Access then you can simply import the excel file in your data base

Love 4 all

I just want to be able to open a specific Excel file from my Access form.

Thanks for your help though.

Hi Sach,

In a module:

Sub OpenXLWorkBook(Path As String)

    ' SET REFERENCE: Microsoft Excel x.0 Object Library

    Dim xlApp As Excel.Application

    If Dir(Path) = "" Then
        MsgBox Path & " isn't a valid path!"
        Exit Sub
    Else
        Set xlApp = CreateObject("Excel.Application")
        xlApp.Visible = True
        xlApp.Workbooks.Open Path
    End If

End Sub

Behind a Command Button:

Private Sub Command0_Click()
    OpenXLWorkBook "C:\Test.xls"
End Sub

Be sure and set a reference to the version of the Excel object library on your system.

Bob