Export Access to Excel template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am trying to export the access data into a excel template I already
design, How can I write the code to automated fill into the right cell in
excel when I export the data from access.

Thank you!
 
Hello, I am trying to export the access data into a excel template I
already
design, How can I write the code to automated fill into the right cell in
excel when I export the data from access.
Click to expand...

This function opens Excel and inserts som text:

Function fExcel()
Dim objExcelApp As Object 'late binding
Dim objExcelDoc As Object 'late binding
Set objExcelApp = CreateObject("excel.application") 'late
binding
Set objExcelDoc = objExcelApp.Workbooks.Add
objExcelApp.Visible = True
With objExcelDoc.Sheets(1)
.Range("A1").Value = 1
.Range("A2").Value = 2
.Range("A3").Value = "Hello"
End With
Set objExcelDoc = Nothing
Set objExcelApp = Nothing

End function



/ Jesper Fjølner
 
Back
Top