Hi Mac

have the macro popup and ask what filename I want to give it

Is there no way to get this information automatic (maybe a cell value or ?)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mac" wrote in message ...
Hello,

I have created a macro that is populating data from another sheet. Once the
data has been populated I created a macro that will paste all to values.
Now my problem, Below is where I am having a problem. Each time I run the
macro I want to save the file as a different filename. Is there a way to
have the macro popup and ask what filename I want to give it. I have to run
this macro on about 200 files. Any help will be greatly appreciated.

ChDir "C:\2007 Client data"
ActiveWorkbook.SaveAs Filename:= _
"C:\2007 Client data\2007 ?????? client data .xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub



--
thank you mac