VBA books for beginners? Excel books / resources for upskilling?

[elemenopee]

I'm an accountant wanting to improve my excel skills. I thought I had advanced skills in Excel until I stumbled on this forum then immediately realised exactly how much I don't know.

Anyway, I want to improve my VBA and Excel skills. I have a lot of spreadsheets that we use for management reporting and budgeting purposes that could use a complete overhaul. (some of you may understand this, but I'm having a lot of fun overhauling our old spreadsheets and it has triggered a desire to learn as much as I can).

Can anyone please point me in the direct of a good VBA book or site for beginners and possibly a book on Excel explaining more advanced functions.

In terms of VBA, I've been able to get by with recording what I need to and googling solutions for trickier bits of code, and making modifications where I need to. I've successfully been able to get together a couple of macros to perform functions that were taking hours manually eg using Excel to transform data exported from system A into a format compatible for importing into system B. What I need though is a manual if you like explaining commands and how to write code from scratch.

Thanks.

 

[Fazza]

hello LMNOP

BTW, there will be many old posts asking the same question. so if you read them you'll get some good answers

personally I suggest John Walkenbach's Power Programming with VBA. there used to be a book update/version for each version of Excel. older copies can be found cheaply

if you're working with older Excel files, there are benefits in starting/learning with that version. Such as Excel 2003. most of which is useful for new versions.

it can be painfully slow initially, but with perseverance and google you'll get there. all the best. Fazza

 

[hiker95]

VBA books for beginners? Excel books / resources for upskilling?

elemenopee,

See reply #2 at the next link:

https://www.mrexcel.com/forum/genera...lications.html

 

[elemenopee]

Thanks so much for the replies.

elemenopee,

See reply #2 at the next link:

https://www.mrexcel.com/forum/genera...lications.html

The link doesn't work. I get an error message saying "Page not found"

 

[hiker95]

elemenopee,

See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 02/20/2017

https://www.mrexcel.com/forum/gener...ed-excel-excel-visual-basic-applications.html


I have tested he above link, and, it does work.

If you are not able to see the list, then, I will post all the information in my next reply.

 

[elemenopee]

elemenopee,

See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 02/20/2017

https://www.mrexcel.com/forum/gener...ed-excel-excel-visual-basic-applications.html


I have tested he above link, and, it does work.

If you are not able to see the list, then, I will post all the information in my next reply.

Works now, thank you.

 

[hiker95]

elemenopee,

You are very welcome. Glad I could help.

I hope you find something useful.

And, come back anytime.