Publicising Benefits of VBA

  • Thread starter Thread starter Tim Childs
  • Start date Start date
T

Tim Childs

Hi

I have tried to get my colleagues who use Excel interested in VBA but
without success - some like the VBA when it is "under the bonnet", but
virtually no-one gets past first base. I enclose the advert I put on our
electronic message board.

Any ideas how to inspire interest apart from ongoing distribution of good
tools, applications etc?

Thanks

Tim


"Don't ask what you can do for VBA*, ask what VBA can do for you!-
with
apologies to John F Kennedy...

There are lots of things that can be improved with VBA (speeding up
repetitive processes and making routine tasks error-proof and doing
other
things that cannot be done "manually" at all etc). A very few examples
of
how it has been used in Divisional finance departments:

analysing data to provide coding information for invoices
automation of the distribution of files by e-mail
putting (full) paths in footers of Excel files (so they can be
found
more easily)
formatting of downloaded data files to reflect data type in each
column
amending the search facility to search ALL sheets in a workbook
converting date "labels" into true Excel dates (numbers)
resetting the "last-cell" a.k.a stopping old spreadsheets getting
bigger
and bigger

If this type of area is of interest to you, then please contact me. I
may
well not know the answer, but I might know someone who does!

Tim x2336

* the macro language in Excel, Word etc"
 
Hi Tim:

If you find out, let me know! I've been fighting a losing battle for years.
People are happy to have you do it for them but they don't want to take the
trouble to learn.

Regards,

Vasant.
 
Vasant

good to hear from you

I think I may not be sufficiently inspiring!!

keep in touch and keep encouraging the others around you!!

Tim
 
Trying to convince a group of people is a tough task.

From your post, it's not clear that your colleagues work for the same
organization. If that's the case, I would target the individual that
makes policy for the group with a well-developed presentation that
provides a cost-benefit analysis of some of your ideas. As in how the
usage will save the company time and money, while providing greater
reliability, etc.

Good luck.

Paul

-----------------------------------------------------------------------------------------------
 
Back
Top