Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2020, 09:22 AM
nadavsn nadavsn is offline VBA updating ChartData allocated memory Windows 10 VBA updating ChartData allocated memory Office 2016
Novice
VBA updating ChartData allocated memory
 
Join Date: Aug 2019
Posts: 3
nadavsn is on a distinguished road
Default 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
Reply With Quote
Reply

Tags
chartdata, vba, workbook

Thread Tools
Display Modes


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
VBA updating ChartData allocated memory Tab 'muscle memory'? markg2 Excel 1 01-09-2015 09:12 AM
VBA updating ChartData allocated memory Resource not getting enough hours allocated to them, therefore extending duration joday48 Project 1 08-01-2014 08:54 AM
VBA updating ChartData allocated memory Multiple resources allocated when only one was selected Kent2102 Project 3 04-11-2013 03:47 AM
VBA updating ChartData allocated memory Over allocated with only 1300 hours in a year?!!! msproject2010 Project 1 08-01-2011 04:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft