#1
|
|||
|
|||
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 |
Tags |
chartdata, vba, workbook |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hilight Parent Folder when Child folder is allocated a new email | brucemc777 | Outlook | 2 | 11-09-2016 09:14 AM |
Tab 'muscle memory'? | markg2 | Excel | 1 | 01-09-2015 09:12 AM |
Resource not getting enough hours allocated to them, therefore extending duration | joday48 | Project | 1 | 08-01-2014 08:54 AM |
Multiple resources allocated when only one was selected | Kent2102 | Project | 3 | 04-11-2013 03:47 AM |
Over allocated with only 1300 hours in a year?!!! | msproject2010 | Project | 1 | 08-01-2011 04:29 AM |