There are tons of books on VBA and most are specific to the program (Access, Excel, Word, etc.) that you want to use it with. The thing you have to remember is that VBA consists of 2 parts. Part 1 is the control structures, If-Then-Else, For x to y, For Each, While-Loop, etc. That is the same in all products. Part 2 is the Object Model, i.e. the objects you will be working with which is of course specific to each product, e.g. Paragraphs, Sentences, etc. in Word; Workbooks, Worksheets, Rows, Columns, Cells, etc in Excel; Tables, Queries, Forms, Reports, etc. in Access.

So if you have a product in mind I and others here can give you more useful advice on which books to get. For general knowledge I'd recommend, no slight intended in view of your background, VBA for Dummies. It's on my book shelf and I've been programming apparently as long as you and I also had a problem initially getting my head around object orientation and still do from time to time.

You'll probably want the latest versions of these but you can get used copies at substantial discount and things haven't changed all that much, at least from a learning standpoint. Of course, there is always new stuff but It's the basics you want in the beginning.

FWIW, once you get past the beginner stage, this is the best book on pure VBA that I have ever come across.

Interesting that you bring up that book. I have the two volumes for Access 2000, Ken Getz co-authored them and they are also the best books on Access that I ever had access to. It also covers some VBA, of course, even automation.

It's a shame that they never updated either set of books for Office versions later than 2000, even if most of the contents are still usable with the current Office version.