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.
Navigate Samples and Help
I’ve organized my samples by chapter, so the samples for this chapter are in ch01.xls, the next chapter is ch02.xls, and so on. Within each sample, I include a Start Here sheet that provides general instructions on using the samples, a Resources sheet that includes links to other sources of information, and in between I include sheets related to the specific topics covered in the chapter (Figure 1-34).
Figure 1-34. Chapter samples are stored in a workbook; topics are covered on individual sheets
In some cases, a chapter’s samples may include other files or folders, but in all cases, links to those locations are found in the main chapter sample.
In other words, I’ve tried to organize stuff as simply as possible.
Excel’s Visual Basic Help is also organized fairly simply, however there are a couple gotchas:
Make sure that you have installed Visual Basic Help for Excel . Earlier versions of Excel did not install Help for Visual Basic by default. If you press F1 in Visual Basic and Help is not displayed, you probably need to run the Excel Setup program to update your installation so it includes Visual Basic Help.
If you are using Excel 2003 you may want to start Help by opening the Help file directly rather than through pressing F1. Excel 2003 provides navigation tools in a Help task pane rather than in the Help window (Figure 1-35 versus Figure 1-36), and it’s ...
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.