|
|
#1
10-04-2020, 09:22 AM
|
|||
|
|||
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 |
Windows 10 
Office 2016
Threaded Mode