I have areport that I need to export to an excell template that contains some formulas that would work with the data from the report,.
Here is the code.
export_test
'
'------------------------------------------------------------
Function export_test()
On Error GoTo export_test_Err
DoCmd.OutputTo acReport, "Progress Report All Tasks test222", "MicrosoftExcelBiff8(*.xls)", "C:\Documents and Settings\randy\Desktop\test222.xlt", False, "", 0
export_test_Exit:
Exit Function
export_test_Err:
MsgBox Error$
Resume export_test_Exit
End Function
this works fine and exports the report the way I need to.
My problem is that it over writes the data in the template how can I write a code so it wont re-write the worksheet or create another worksheet with the report.
Here is the code.
export_test
'
'------------------------------------------------------------
Function export_test()
On Error GoTo export_test_Err
DoCmd.OutputTo acReport, "Progress Report All Tasks test222", "MicrosoftExcelBiff8(*.xls)", "C:\Documents and Settings\randy\Desktop\test222.xlt", False, "", 0
export_test_Exit:
Exit Function
export_test_Err:
MsgBox Error$
Resume export_test_Exit
End Function
this works fine and exports the report the way I need to.
My problem is that it over writes the data in the template how can I write a code so it wont re-write the worksheet or create another worksheet with the report.
