MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Good VBA/Excel book(s)

  Asked By: Brooklyn    Date: Nov 05    Category: MS Office    Views: 2330

I got interested in VBA with Excel just to write a quick and dirty program that
would help me evaluate new 52-week lows that I pulled off a website and pasted
to an Excel spreadsheet.

The program works really well and I'm very happy with it. I see, however, from
some recent posts that I seem to have sold myself short on what I could do with
VBA and data from websites, as well as a few other things.

Rather than ask a whole bunch of questions, let me just ask one: can anyone
recommend a book or two that would really help me understand the full range of
capabilities with VBA and Excel.

Although I am not a programmer by trade, I have over the course of some years
learned to program in C, C++, PHP, ASP, assembly language, COBOL, and Fortran
just because I've always been somewhat associated with programming. So a rank
beginners book is probably underkill for me.



2 Answers Found

Answer #1    Answered By: Sheryl Morgan     Answered On: Nov 05

I completed an excel  VBA class just a short time ago at the Science
Museum of Minnesota. As part of the fee, we received a book
called "Excel 2003 VBA - Programmer's Reference", by Paul T Kimmel &
John Green (plus a host of others). Wiley Publishing did the book.
It is 1144 pages, and the price on the back says $39.99. I'm a real
rookie at VBA, but I am learning as I go. The book  is a big help.
I am currently working on code that will take an excel database,
extract variable date ranges and put them in a pivot table. I'm
stumbling badly so far, butthe book is giving me different things  to

Answer #2    Answered By: Brian Ross     Answered On: Nov 05

Yes, it does help. I had completely forgotten about those red
Programmer-to-Programmer books, which I used years ago to teach myself ASP and
a few other things. I liked them a lot then, and now I have this one on my
Amazon Wish List for part of my next purchase.

Didn't find what you were looking for? Find more on Good VBA/Excel book(s) Or get search suggestion and latest updates.