You could use something like:

Option Explicit
Sub testme()

Dim myFilename As Variant
myFilename = Application.GetSaveAsFilename

If myFilename = False Then
'user cancelled
Else
MsgBox "user selected: " & myFilename
'but you have to do the work--save or whatever
End If
End Sub

dave glynn wrote:

Is it possible to have a macro prompt fro a filename. for example if data has
been copied from "oldfile" is it possible to have the macro ask which file it
now has to be copied to?

Many thanks

Dave

--

Dave Peterson