V
Vigil-Machque
I am trying to automate the export of a report to an Excel 97-2000 spread
sheet. The data is exported and the file is created however, the .xls
extention is not added to the file name. How can I get extention to be added
to the file name?
code I am using:
Private Sub Report_Activate()
DoCmd.OutputTo acReport, "HAN_in_Safe_Report", "MicrosoftExcelBiff8
(*.xls)", "HAN in Safe Report", True, "", 0
End Sub
sheet. The data is exported and the file is created however, the .xls
extention is not added to the file name. How can I get extention to be added
to the file name?
code I am using:
Private Sub Report_Activate()
DoCmd.OutputTo acReport, "HAN_in_Safe_Report", "MicrosoftExcelBiff8
(*.xls)", "HAN in Safe Report", True, "", 0
End Sub