SaveAs Cell.value=filename
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
|