J
JK
Hi all,
Trying to find a way to copy a pivottable object to Word
Dim MyPT as Object
Set MyPT = CreateObject("OWC10.Pivottable")
'' populate the pivottable, works ok so I will not include the code here
MyPT.copy
this does not work, Class does not support automation...
I just need to make a simple copy and paste it into Word using automation..
Any suggestions?
Thanks in advance
Joost
Trying to find a way to copy a pivottable object to Word
Dim MyPT as Object
Set MyPT = CreateObject("OWC10.Pivottable")
'' populate the pivottable, works ok so I will not include the code here
MyPT.copy
this does not work, Class does not support automation...
I just need to make a simple copy and paste it into Word using automation..
Any suggestions?
Thanks in advance
Joost