I remove the textboxes and tried running it again..
Run-time error
slide.shapes:Object does not exist
Set objGraph = objPrs.Shape(2).OLEFormat.Object.Application
Sir,
Thanks for your response..
Run-time error
OleFormat.object:Invalid request.This property only applies to ole objects.
When I add watches
objPrs.Shapes(1).OLEFormat.Object.Application <Oleformat.object:invalid request.This property only apples to OLE objects>
I tried the code you pasted
its giving me an eror message
OLEFormat.Object:Invalid Request.This property only applies to OLE Objects
Set objGraph = objPrs.Shape(2).OLEFormat.Object.Application
When I performed a Add watch
Watch : : powerpoint : <Expression not defined in context> : Empty...
SkipVought,
Thanks for your reply..
I am new to excel VBA..
I am still getting error message
Run time error '91'
Object variable or with block variable not set..
How can the datasheet in the chart get updated automatically with excel range as the months grows..
Please advice..
I am currently working on a requirement where the excel shoud automate powerpoint..
For eg
Jan Feb Mar
East 10 30 40
West 13 14 45
South 34 35 33
Each row in the excel should generate a seperate slide.
So as per the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.