Hi everybody,


I'm sure it something simple but I can't seem get my mind around
it right now.

I am exporting data from a current access form to an excel
spreadsheet then I am copying that data to an existing excel
workbook where the data will be used as the backend for and
excel invoice form. (I am using 2 workbooks because I can't
figure out how to output the data to the specific workbook and
sheet that I will use so I am trying to copy it there but I
can't get that to work either. Would someone please review what
I have and give me some guidance, please.

Private Sub EMail_Click()

Dim xLS As Object
Dim TempWbk As Object
Dim Sheet As String
Dim DestSheet As String

Set xLS = CreateObject("Excel.Application")

With xLS
.Workbooks.Open ("C:\temp\granite\Global Financial Adjustment
.Application.Visible = True
End With

DoCmd.OutputTo acOutputForm, "frmGlobalAdjustment", _
acFormatXLS, "C:\temp\granite\Holding Form.XLS", True
Sheet = ActiveWorkbook
DestSheet = ("C:\temp\granite\Global Financial Adjustment

after = Workbooks("Destsheet").Sheets(1)

End Sub

Thank you,


Try this

Private Sub EMail_Click()

    Dim objXL As Excel.Application
    Dim objWB As Excel.Workbook

    DoCmd.OutputTo acOutputForm, "frmGlobalAdjustment", _
    acFormatXLS, "C:\temp\granite\Global Financial Adjustment Form.XLS", True

    Set objXL = New Excel.Application
    Set objWB = objXL.Workbooks.Open("C:\temp\granite\Global Financial Adjustment Form.XLS")
    objXL.Visible = True

    Set objWB = Nothing
    Set objXL = Nothing

End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.