MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How many VBA developers are there World wide, estimate is fine?

  Asked By: Bailey    Date: Feb 01    Category: MS Office    Views: 1270

I have a couple of questions about VBA:

1) How many VBA developers are there World wide, estimate is fine?

2) Anyone has a good site that talks about the history of VBA or VB?

3) What are the off the cuff things have been done using VBA?

I am giving a presentation about VBA and I will include this group in the
resource section of the presentation.



2 Answers Found

Answer #1    Answered By: Blasa Fischer     Answered On: Feb 01

I do many off the cuff things, because it saves me time. E.g. my boss
asked for a workbook to be cleaned up, and rows deleted based on a text
string being present.

A simple Do until loop, starting from the bottom, working upwards (since
we are deleting rows), and whole job was finished in ~15 minutes,
instead of ~10 minutes by using Autofilter (now that I think about it),
or 4 hours manually (estimated). SO, bad example, but the cookie
sometimes falls the other side of the tree, and VBA is the fastest way
to accomplish a task.

For your first and second question, you will have to refer to Wikipedia.
Search for "VBA". No history, though, but lots of links.

Answer #2    Answered By: Estelle Pierce     Answered On: Feb 01

Things I do:

1- At work I manage resources in an Engineering test group; Engineers,
Test equipment temperature chambers, etc.

2- I also use it for charging other departments which use my equipment.

3- At home I ma using Exce/VBA for controlling my Ham radio equipment.
Reading / loading the memories in the radio. All via the serial port.