View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
terry terry is offline
external usenet poster
 
Posts: 193
Default Memory Issues with Excel

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)