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"