On Tue, 17 Feb 2009 20:04:01 -0800, OssieMac
wrote:

Hi John,

Is this what you are looking for?

Application.Dialogs(xlDialogSaveAs).Show

Not quite. That opens the dialogue box which is what I need in order
to let a user select the location but I want to set the filename to
something different than what the current workbook name is.



John Keith