LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot tables - memory issues - please help apss40 Excel Discussion (Misc queries) 2 June 20th 09 01:38 AM
Excel Memory Issues TXSteveO Excel Discussion (Misc queries) 4 January 1st 07 01:26 AM
memory issues Spike Excel Programming 3 December 17th 05 09:53 AM
memory issues with Excel raj Excel Programming 1 September 19th 03 01:32 PM
Memory Issues keepitcool Excel Programming 0 August 25th 03 02:47 AM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"