I'm doing a new project in Excel. I can see that Excel allows you to write macros in Visual Basic. Do you have any advice on getting started with Excel programming?

Requires Free Membership to View

Excel is a wonderful and rich programming environment. Like all Microsoft Office applications, it uses Visual Basic for Applications (VBA) for it's macro programming language. A while ago, I wanted a spreadsheet that tracked my stocks and mutual funds on a daily basis. Once I started poking at what Excel could do, I ended up with a totally automated spreadsheet that downloaded my stock quotes automatically from the web and graphed how much I made, or lost that day. Probably the best place to start your Excel development is with a standard Visual Basic programming class or book. That way, you get the fundamentals out of the way. With that under your belt, there are some very good Excel books on the market. The one I used, which is unfortunately out of print, is "Microsoft Excel 97 Developer's Handbook" by Eric Wells and Steve Harshbarger. A friend of mine, who develops Excel solutions for a living, highly recommends "Microsoft Excel 2000 Power Programming with VBA."

This was first published in June 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: