Actually I've done some quite acceptable applications in Excel, Word
and Access VBA. One of the more recent ones was in Word VBA where I
collected a bunch of filenames and massaged them to comply with
certain standards. Nothing to do with word unless you count the
"report"... but it worked and the "client" was pleased.

Rather than saying VBA shouldn't be used for that sort of thing...
which I disagree with... why not turn it around and say that there is
no need to go to a "special" environment to do a particular job.

If the user is happy then what the hell. So it may take a bit of
time... go and get a cup of tea!!! ... can you tell I'm English..
:-)

... And I would be suprised if you haven't used VBA for something that
it "shouldn't be used for"... no such beast I think.