VBA Books: General or Excel-Specific?

[JenniferMurphy]

I'd like to get a VBA reference book. I'll never be a serious VBA developer. It will be just for personal use for writing little macros. Most of them will be for Excel, some for Word. Would you all recommend one general VBA book or one for each application?

Mastering VBA for Microsoft Office 2013 by Richard Mansfield looks like a good general book.

 

[wigi]

Hello

User Hiker95 has a list of Excel and VBA books, like this one: http://www.mrexcel.com/forum/excel-questions/605558-best-visual-basic-applications-book.html
But there are most probably more recent versions of the list. If he doesn't see this topic, send him a short private message to invite him to this topic.

General or Excel-specific: it depends what you will want/need to do, of course.

 

[TMShucks]

I'd recommend anything by John Walkenbach

The Spreadsheet Page - Excel Books by John Walkenbach


Regards, TMS

 

[My Aswer Is This]

I recommend: Excel 2013 Power Programming with VBA by John Walkenbach (Apr 1, 2013). I always like Kindle edition. $28.24 at Amazon.

 

[farmerscott]

Jennifer,

Based on the topics that come up on this site, VBA is mostly used for Excel, then Access or Outlook and then Word.

I suggest if you can use VBA on Excel then using it in the other applicatioons will be relatively easy. Yet again I have not tried using VBA in these other applications.

My favourite book is- Excel VBA Programming for Dummies, by John Walkenbach.

FarmerScott

 

[TMShucks]

@farmerscott: while VBA coding is the same, the Object Model for Word, etc., is somewhat different. I think understanding the Word Object Model is a learning curve in itself.

Personally, I think Excel lends itself to programmatic manipulation more easily than the others. I'd focus on Excel/VBA first.

Regards, TMS

 

[hiker95]

JenniferMurphy,

The below link contains my most up to date list for Excel.

Training / Books / Sites as of 6/26/2014

http://www.mrexcel.com/forum/excel-questions/788128-compare-values-worksheets.html#post3857750

 

[farmerscott]

Hi Hiker,

just wondering if you and others have thought about putting your list as a stand alone 'sticky' thread.

The need for background information on learning Excel, VBA and courses comes up regularly.

cheers

FarmerScott


@TMS, noted. Will have a look at using VBA for Word.

 

[hiker95]

wigi,

Thank you very much.

just wondering if you and others have thought about putting your list as a stand alone 'sticky' thread.

farmerscott,

Thanks for that.

Something like that was discussed way back when???, but, the problem is that the list, and, the links would have to be updated on a regular basis. I do check the links every once in a while.......

And, the list is on several other sites like MrExcel.

 

[farmerscott]

Hi Hiker95,

It is just too good a resource to be burried in all the threads. It should stand alone where people can easily see and access it- IMHO.

cheers

FarnerScott