T
Terry
I have a MS Access program that build the data on 19 sheets in Excel. I have
broken the code down to work on only 4 sheets at a time but I still am having
problems with the system becoming corrupt after executing the code to many
times. Any help with pointing me in the right direction would be appreciated.
I have some code that takes data from a MS Access DB and populates an Excel
spreadsheet. Excel is opened with the following:
Set xlApp = CreateObject("excel.application")
Set xlBook = xlApp.Workbooks.Open("C:\temp\Video Churn Report", 0, False)
At this point I open each sheet individually to work on and then close it
and save it when I am done with the sheet
Set xlSheet = xlBook.Worksheets(ExcelTab)
broken the code down to work on only 4 sheets at a time but I still am having
problems with the system becoming corrupt after executing the code to many
times. Any help with pointing me in the right direction would be appreciated.
I have some code that takes data from a MS Access DB and populates an Excel
spreadsheet. Excel is opened with the following:
Set xlApp = CreateObject("excel.application")
Set xlBook = xlApp.Workbooks.Open("C:\temp\Video Churn Report", 0, False)
At this point I open each sheet individually to work on and then close it
and save it when I am done with the sheet
Set xlSheet = xlBook.Worksheets(ExcelTab)