VBA updating ChartData allocated memory
Hi
I am using VBA code to update ChartData from a DB with the command:
shp.Chart.ChartData.Workbook.Worksheets("Sheet1"). Range(columnName & 1).Value =...
the only problem is that the PowerPoint keeps an open Excel session on the RAM even after I finished to update the chart.
with many slides, it became a huge load on the PC.
is there a way I can free the workbook from the RAM after I finished update it?
thanks!
Nadav
|