SaveAs Cell.value=filename
That gets the whole filename, you need FileDialog as I showed you in the
previous thread.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Helmut" wrote in message
...
Hi, I am using the following statement:
Application.Dialogs(xlDialogSaveAs).Show FullFilePath, vbNormalFocus
How can I include in this statement a Filename which is in a Cell.value in
order that the user can select the appropriate directory for him/her but
the
filename is fixed.
thanks
Helmut
|