![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Excel Method call fails Topic Summary: SetSourceData for a chart in Excel fails Created On: 29-Jun-2006 14:06 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: I love it. I've wrestled with Excel OLE before, and one thing that I've learned is that you have to be very careful to look in the object browser to find out what you're doing. I always try to do whatever it is I'm doing with a VBA macro before even trying it in DXL. The problem with arguments that your code complained about was that it tried to use the SetSource method on a ChartObject type object. Buuuuuuuuut, that method belongs to the Chart type object, which is (I think) itself a member of the ChartObject type. So, you were using a ChartObject object when you wanted a Chart object. ![]() Chris ![]() | |
![]() |
|
Can anyone help me with why this method call (SetSourceData) fails in Excel?
See Code. ------------------------- Bruce Tuskey Sr. Principle Engineer Tuskey@gmail.com "All that is gold does not glitter, not all those who wander are lost:..." - Gandalf the Grey (JRR Tolkien) |
|
![]() |
|
![]() |
|
I love it.
I've wrestled with Excel OLE before, and one thing that I've learned is that you have to be very careful to look in the object browser to find out what you're doing. I always try to do whatever it is I'm doing with a VBA macro before even trying it in DXL. The problem with arguments that your code complained about was that it tried to use the SetSource method on a ChartObject type object. Buuuuuuuuut, that method belongs to the Chart type object, which is (I think) itself a member of the ChartObject type. So, you were using a ChartObject object when you wanted a Chart object. ![]() Chris ![]() |
|
![]() |
|
![]() |
|
Thanks Chris!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
------------------------- Bruce Tuskey Sr. Principle Engineer Tuskey@gmail.com "All that is gold does not glitter, not all those who wander are lost:..." - Gandalf the Grey (JRR Tolkien) |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Excel Method call fails
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.