Where to start learning VBA to parse excel sheets

Question

Hi,

I am new to VB/VBA. I have had a few years of experience with C++ and Java in the first three years of my undergraduation. The task that I have been assigned is to parse a number of worksheets in an excel workbook, and reorganize the parsed data into another excel file.

I was advised by a friend that I should use VB macros in excel to accomplish this task. So, I now am beginning to learn VB/VBA. I have looked into the basics of the language, and am comfortable with the OO environment. But, could someone please advise me as to where I should start learning VBA macros to accomplish this task that I have been assigned.

Any advise would be most appreciated.

-Sijistani

Answer 1

I have found this link, posted by one of the moderators, is this a good place to start?

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Answer 2

Here are some more useful links


excel.programming

http://www.mvps.org/   (all)

http://www.vbaexpress.com/forum/index.php (all)

http://dsmyth.blogspot.com/  (Excel +)

http://peltiertech.com/index.html  (Excel – Microsoft MVP)

http://www.puremis.net/excel/ (Excel)

http://www.dailydoseofexcel.com/archives/category/vba-advanced/  (Excel)

http://www.spyjournal.biz/exceltips/exceltips.html  (Excel)

http://www.nandeshwar.info/projects/xlblog/  (Excel)

http://www.excelblog.net/  (Excel)

http://www.mindspring.com/~tflynn/excelvba.html  (Excel)

http://www.automateexcel.com/index.php?cat=17   (Excel)

http://www.andypope.info/vba.htm  (Excel)

You can also pick up a book on Excel VBA (Complete Reference)

Happy Coding

Cheers
Shasur

---

http://www.vbadud.blogspot.com