Hey, thanks. This got me to thinking and found the following:

Application.GetOpenFilename

Which allows me then to initialize a variable szPath.

doco

"Jim Thomlinson" wrote in message
...
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