Hello All,
This is my first time using this forum. It was highly recommended by a long time member.
I am reusing some export code to export data from Access (2000) to Excel using a criteria form. I would like to append data to an Excel sheet without clearing the current data. How can I perform this function?
The export function works well. The only problem is when new data is exported, the current Excel data is replaced with the new exported data.
Here is part of the code:
<BEGIN CODE>
Set EXL = CreateObject("Excel.Application")
Set WB = EXL.Workbooks.Open("C:\WO_Activity_Report.xls")
WB.Sheets ("WO_Activity_Report")
WB.Save
EXL.Quit
Set EXL = Nothing
<END CODE>
Your assistance is greatly appreciated.
This is my first time using this forum. It was highly recommended by a long time member.
I am reusing some export code to export data from Access (2000) to Excel using a criteria form. I would like to append data to an Excel sheet without clearing the current data. How can I perform this function?
The export function works well. The only problem is when new data is exported, the current Excel data is replaced with the new exported data.
Here is part of the code:
<BEGIN CODE>
Set EXL = CreateObject("Excel.Application")
Set WB = EXL.Workbooks.Open("C:\WO_Activity_Report.xls")
WB.Sheets ("WO_Activity_Report")
WB.Save
EXL.Quit
Set EXL = Nothing
<END CODE>
Your assistance is greatly appreciated.
