Graph.exe

DanR1245

New Member
Joined
May 12, 2004
Messages
27
Hi,
I am using Excel VBA to automate the creation of graphs in Powerpoint. To do that, I am using calls such as:

Code:
Set shpGraph = oPPT.ActivePresentation.Slides(pd).Shapes.AddOLEObject(Left:=Lleft, Top:=lTop, Width:=lwidth, Height:=lheight,  ClassName:="MSGraph.Chart", Link:=0).OLEFormat.Object

There are several of these (actually dozens) in my code. Each time I do a Set statement similar to this, it creates an instance of Graph.exe. After about 100 of these, my PC runs out of memory and cannot insert any more shapes.

I am doing a

Code:
Set shpGraph = Nothing

at the end, but the GRAPH.EXE remains in the taskmanager.

So, the question is how does the instance of GRAPH.EXE get killed?

Thanks much for any assistance.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,181,606
Messages
5,930,858
Members
436,764
Latest member
avalladarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top