What does "not working" mean?
Please don't post questions with that phrase in it....
However, the dialog displays for me, with and without the ( ) around mname.
I did declare mname as a variant.
The issue probably is cell B6 on your template sheet does not have
a complete file path in it. That would look something like this...
"C:\Documents and Settings\user\My Documents\Old Excel Files"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Mike"
wrote in message
I've created an excel template and now want to propose the filename as
a combination of different cell values.
I used the Sub SaveAs() in word and it worked perfectly. Now in excel
it's not working.
This is what I used in my latest attempt (found on one of the groups):
Sub filesaveas()
mname = Range("b6").Value
Application.Dialogs(xlDialogSaveAs).Show (mname)
End Sub
It works if I run it from the VBA editor, but as soon as I'm back to
my template, it's not working.
I'm using Excel 2003.
Any help appreciated