Let me know if this is kind of what you were thinking...

Application.Dialogs(xlDialogSaveAs).Show

There are a number of different dialogs to choose from and they each take
arguments...
--
HTH...

Jim Thomlinson


"doco" wrote:

I would like to know if there is a canned control in Excel (2000) that is
equivalent to the VB6.0 CommonDialog. Or if there is a work around
(UserForm). Not everyone I send templates/Add-ins to has this OCX.

TIA
doco