Jim Rech wrote:

The plot thickens.. and I'm getting lost<g. An add-in should not
have any particular security risks but it sounds that you're doing
okay with the "macros in the workbook" approach.

It's not that it's a potential security risk, but that the IT bods have
stuff locked down so tight, they might not allow add-ins unless they
specifically sanction the change. The laptop user hates the glide pad, but
plugging in a USB mouse results in a pointer that moves too fast - and he's
blocked from changing his mouse settings. Since he's argued, and failed, for
access to the mouse settings, I doubt that IT would sanction an add-in. (Did
it as an Excel macro rather than plain VB to get around them in the first
place.) What's really bad is that he's the design office manager and has
plenty of IT savvy - the automation routine that I'm working on was his
idea. (sheesh!<tm)

Anyway...

To prompt a user
for a file name you can do something like this:

FName = Application.GetSaveAsFilename

Yup, got that - nearly done. :-)


--
Wally
www.forthsailing.com
www.wally.myby.co.uk