I Would like to learn complete VBA suggest me one book.

Hi all,

Presently i am learning Advanced excel and as well VBA. But i am still confusing do i need to learn VBA or Visual Studio. I want to become a programmer. I would like to do a job as VBA or VB Developer. So do i need to learn VBA or Visual studio. which has the much demand and jobs now or in the future?

presently i know some concepts in vba i am able to create small macros. I need excellence. I need a complete guide to create macros in vba (end to end). suggest a book here.(only one book please, as i have seen many books, but i am not able to fix which one i need to read.)

Also suggest me a complete guide from basics to advaced for visual studio. suggest me only one book. dont post list of books please......

Other wise you can also suggest books to me one by one to read. first which one i need to read and then, next book name etc for vba and visual studio.

Hi,

Developers have styles of writing just like good (and bad authors). I like this guys style. He taught me the most.
http://spreadsheetpage.com/index.php/books

Pick the book that is closest to your needs.

By far the best book i have found is to be:

Excel 2007 Power programming with VBA by John Walenbach.
Actually any book of his gives clear examples of how to use Excel & VBA and usually comes with a CD full of examples on how to use it for other applications.

My first book was Excel 2007 for dummies, it was ok but the screen shots were so small you could not see any detail to help understand what was happening.
I just like the layout and detail found in John Walkenbach books.
He breaks down the code and logic in putting the code together.
Mind you, i had to read the book twice before i understood most of it, and even now i go back and think "Ah, i know what he means now".


So far i have learnt more from trial and error, internet sites and from help on this site.
Trying to solve questions on this site always leads to new challenges, even if i dont post them as the Experts/Gurus usually beat me to it.
But the good thing there is i usually pick up new methods used by the experts/gurus of which i then go and research on to find out how it works.

AB33 being one of them

From the inside pages of VBA Dummies,

"Notice that the title of this book isn't The Complete Guide to Excel VBA Programming For Dummies. I don't cover all aspects of Excel programming — but then again, you probably don't want to know everything about this topic. If you consume this book and find that you're hungry for a more comprehensive Excel programming book, you might try Microsoft Excel 2013 Power Programming with VBA, by John Walkenbach, also published by Wiley. And, yes, editions for older versions of Excel are also available."

The breadth, depth and style are different. Both are good.

If you want to know exact contents use the Look Inside feature at Amazon to see Contents and Indexes. There should also be a few in book pages to read.

I dont have VBA for dummies, only the small section in the large book called Excel and VBA for dummies
But if i compare this book with Johns Excel 2003 book which covers similar topics, i will say without doubt that Johns book is far superior with more examples and ways to use them. It has a great more detail on graphs/charts, pivot tables, lookups, Arrays, userforms, functions,errors,external datbases,What if,VBA etc.

Originally Posted by punna111

do i need to learn VBA or Visual Studio. I want to become a programmer. I would like to do a job as VBA or VB Developer. So do i need to learn VBA or Visual studio. which has the much demand and jobs now or in the future?

if you want to be a vba developer learn vba, otherwise learn vb or probably c#. I don't believe you'll find many jobs as a pure vba developer

presently i know some concepts in vba i am able to create small macros. I need excellence. I need a complete guide to create macros in vba (end to end). suggest a book here.(only one book please, as i have seen many books, but i am not able to fix which one i need to read.)

no one book will make you excellent at vba or even cover all topics thoroughly but you have some good suggestions already for beginner/intermediate level. with vba knowing the application is most important unlike in vb, where the application is usually up to the programmer ;-)

Also suggest me a complete guide from basics to advaced for visual studio. suggest me only one book. dont post list of books please......

again no way will you find one book. visual studio covers multiple languages and each one will require more than one book

Jay,
Silly question!
One can not use VB in excel. Right? So, if you are a VB developer, you can only work outside excel. I guess, there are many similarities between VB and VBA.

you can call dlls written in vb from vba and you can create vsto workbooks but for regular stuff no you don't use vb in excel

there are a lot of similarities between vb6 and vba (and vbs); fewer between vb (.Net) and vba

shall learn vba or visual studio?

If i learn vba can i work with visual studio?

it depends on what you plan to do-there's really no comparison

no-vba has nothing to do with visual studio

which one has much demand and jobs now.
if i learn visual studio can i work in vba?

depends where you are and which industry
visual studio still has nothing to do with vba

I am presently working in Accounting and finance as a process associate.
I would like to move to Excel and vba developer. i want to change my entire profile.
other wise i can use this knowledge in accounting industry by becaming MIS Executive or Reporting analyst.
What are your suggestions??

learn excel inside out especially pivots, charts, dashboards, the new BI tools and vba. learn as much sql as you can. read books on data analysis visualization and presentation-many people are very bad at the presentation aspect!

Thank you very much for guiding my career.

so, as per your post i have to become a Reporting Analyst (correct me if i am wrong).(anything else you would like to say here, please suggest me...please)


My Goal is from now:

I need to learn Advanced Excel and complete VBA.
I have to learn about pivots, charts, dashboards, BI tools (means Business intellegent tools like powerpivot, right? anything else are there please mention)
Need to learn SQL, in SQL we have so many i think like sql, mysql, oracle,dbms etc (I dont know much about all these. please suggest). What i need to learn?

My Request to every member here especially to you:

Please suggest me a good list of books to achieve above skills, in a order. First what i need to read and then what i need to read. Also suggest me good and complete books for data analysis, visualization and presentation.

I suggest you read up on object oriented programming and relational database. This will help you understand how data is held and how it moves between applications. When you understand this you will be able to slice and dice data into groups and turn that into useful information. This ultimately will change data into information and becomes a report.


You don't want to say i need to learn vba. You want to learn programming, and apply that in VBA. I can tell you, I learned programming through C++, which i then applied programming concepts in vba. I never read a VBA book. I said I need to accomplish this, this requires me to move X to Y or change Y to Z. What is the vba equivalent of doing this process?

Hi all,

Can any one list out the activities i need to do to achieve my goal or become a good vba developer with presentation skills.

Just i need what i have to do from to day onwards...pleaseeeeeeeeeeee.........