Newbie VBE questions

tjak

Board Regular
Joined
Jan 2, 2003
Messages
117
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.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

TommyGun

MrExcel MVP
Joined
Dec 9, 2002
Messages
4,202
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

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
As regards a book, John Walkenbach's 'Excel 2002 Power Programming with VBA' is good and provides a nice introduction.
 

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,494
Mudface said:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,467
Members
414,452
Latest member
Dannysamworth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top