Macros in Excel
 

Check the help for Application.GetOpenFileName.

NickHK

"Alicat28" wrote in message
...
I need to create a macro and have it stop and prompt me to give a name to
the
file I want to save (I want to run the macro on different files that will
be
formatted the same but have different content) then continue with the
formatting.