April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NET
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Program Diagrams
Excel diagrams might seem very useful from a programming perspective; however, they have a serious limitation: you can’t get or set the text of diagram nodes from code. See http://support.microsoft.com/default.aspx?scid=kb;en-us;317293 for complete details.
This appears to be a bug in the 2002 and 2003 versions of Excel, so you can assume it will continue into the future. Interestingly, you can use macro recording to record your actions building a diagram in the Excel user interface; however, if you run the macro, you will see the error in Figure 18-11.
Figure 18-11. Programming diagrams is not well supported in Excel
Warning
Many of the code samples for the Diagram and DiagramNode objects in Help fail if you run them in Excel.
Microsoft suggests using the Diagram object in the Word or PowerPoint application as a workaround to this problem, and those applications do seem to work. However, I think it’s more reliable to use Excel’s autoshapes and connectors if you want to diagram data from a worksheet.
The following code draws a hierarchical diagram from items on the active worksheet. Items in the first column are top-level parents and items in subsequent columns are all related as shown in Figure 18-12:
' Module-level variable used to set Top property ' of subsequent shapes. Dim m_lastShape As Shape Sub DrawDiagram( ) Dim ws1 As Worksheet, ws2 As Worksheet, cel ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.