ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Memory Issues with Excel (https://www.excelbanter.com/excel-programming/392935-memory-issues-excel.html)

terry

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