Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot tables - memory issues - please help | Excel Discussion (Misc queries) | |||
Excel Memory Issues | Excel Discussion (Misc queries) | |||
memory issues | Excel Programming | |||
memory issues with Excel | Excel Programming | |||
Memory Issues | Excel Programming |