![]() |
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) |
All times are GMT +1. The time now is 10:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com