Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with shapes.nodes collection in excel 2007
Hi,
Has anyone come across the following problem? The code below works fine with Excel 2003, but in 2007 nodes.count always returns zero. Any hints appreciated! Many thanks, Tim Dim o As Shape For Each o In ActiveSheet.Shapes If o.Type = msoLine Then If o.Nodes.Count = 2 Then ..etc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with shapes.nodes collection in excel 2007
To clarify further, if I run the following from VBA in a clean Excel
2007 worksheet it still returns 0 instead of 2. dim o as Shape set o=ActiveSheet.shapes.addline (0,0,400,400) ? o.Nodes.Count 0 wrote: Hi, Has anyone come across the following problem? The code below works fine with Excel 2003, but in 2007 nodes.count always returns zero. Any hints appreciated! Many thanks, Tim Dim o As Shape For Each o In ActiveSheet.Shapes If o.Type = msoLine Then If o.Nodes.Count = 2 Then ..etc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with shapes.nodes collection in excel 2007
Thanks for the reply - wasn't sure though what you meant by "parsing it
to a cell"? Incidentally, I just tried doing exactly the same in Word 2007 and in this environment everything behaves as it should. This seems to confirm that its an Excel 2007 bug. Any ideas Dim o as shape set o= ActiveDocument.shapes.addline (0,0,400,400) ? o.Nodes.Count 2 Regards, Tim Duncan wrote: Hi Tim, I ran this on 2002 SP3 and got a count of 2, so unsure why in 2007 it would return 0. Is it to do with how you are calling the count? Have you tried parsing it to a cell? Regards Duncan wrote: To clarify further, if I run the following from VBA in a clean Excel 2007 worksheet it still returns 0 instead of 2. dim o as Shape set o=ActiveSheet.shapes.addline (0,0,400,400) ? o.Nodes.Count 0 wrote: Hi, Has anyone come across the following problem? The code below works fine with Excel 2003, but in 2007 nodes.count always returns zero. Any hints appreciated! Many thanks, Tim Dim o As Shape For Each o In ActiveSheet.Shapes If o.Type = msoLine Then If o.Nodes.Count = 2 Then ..etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Select Multiple Shapes | Excel Discussion (Misc queries) | |||
Formatting shapes with excel 2007 | Excel Discussion (Misc queries) | |||
Anchoring shapes when printing in Excel 2007 | Excel Discussion (Misc queries) | |||
Colors Shapes vs Cells (Excel 2007) | Excel Programming | |||
TreeView: add more than one node to nodes collection | Excel Programming |