Newbie VBE questions

[tjak]

I'm self-learning XL(97) and this board has been tremendous. But ... I've now been given the on-going job of reviewing data from the past 4 years to find changes. Currently, I'm doing the process "manually" : re-format the current report; running each of 8 reports against it; filtering out the changes in each.

Can VBE "automate" the steps? (Reformat the current report, compare it to the 8 previous reports, etc) If so, any recommendations as to a good beginners book?

Does VBE for XL97 have to be re-learned if we upgrade to XL2M or XP?

Thank you all for your continuing participation in this board. Although I don't always understand the answers, I appreciate the caring and sharing.

 

[TommyGun]

Just for your info...VBE (Visual Basic Editor) is the enviroment in which you write/edit VBA (Visual Basic for Applications). VBA is the actual code that handles the automation of processes. To answer your 2 questions...

1. Yes, this process can probably be automated. You may try recording your code first using the Macro Recorder (which can be found under Tools|Macros|Record New Macro...).

2. No, you do not necessarily have to re-learn VBA when your XL is upgraded. There will be new methods and properties for you to learn, but once you have a good VB programming basis, you won't have to re-learn it.

 

[Mudface]

As regards a book, John Walkenbach's 'Excel 2002 Power Programming with VBA' is good and provides a nice introduction.

 

[al_b_cnu]

As regards a book, John Walkenbach's 'Excel 2002 Power Programming with VBA' is good and provides a nice introduction.

Hi,

There are lots of free VBA tutorials on the web - I started with one of them & THEN bought John WalkenBachs book.

HTH

Alan

 

[Smitty]

There are lots of free VBA tutorials on the web

Here are a few:

http://www.intelinfo.com/newly_researched_free_training/Visual_Basic_for_Applications_VBA.html

http://www.excel-vba.com/free-excel-vba-tutorial.htm

http://www.lacher.com/toc/tutvba1.htm

But most of all, keep coming back here!

Hope that helps,

Smitty

 

[Iridium]

Also check out the board's Recommended links and addins

Loads of stuff there besides VBA too...

HTH