dynamic MSGraph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI all
I want to change the values of an MSGraph Datasheet dynamically through the value of an optionbutton f.ex
My problem is: How can I access this Datasheet with VBA, so that I can change it
F.ex. I have this now:
ActivePresentation.Slides(1).Shapes(2).OLEFormat.Application.Datasheet.Range("A1").Value = 2
But it doesnt work. Is there any way to do it
So that in the end I can assign this Cell Value to the output value of a Radiobutton
Thank you for your help, I tried several forums and wesites, but didnt find help
Timon
 
HI all,
I want to change the values of an MSGraph Datasheet dynamically through the value of an optionbutton f.ex.
My problem is: How can I access this Datasheet with VBA, so that I can change it?
F.ex. I have this now:
ActivePresentation.Slides(1).Shapes(2).OLEFormat.Application.Datasheet.Range("A1").Value = 20
But it doesnt work. Is there any way to do it?
So that in the end I can assign this Cell Value to the output value of a Radiobutton.
Click to expand...

With ActivePresentation.Slides(1).Shapes(2).OLEFormat.Object.Application
.DataSheet.Range("A1").Value = 99
.Update
.Quit
End With
 
Back
Top