G
Greg Snidow
Greetings everyone. I have, among other things, the following lines in a
macro to save a worksheet
ActiveWorkbook.SaveAs Filename:= _
"\\MyURL\DAILY_PRODUCTION\NEW\test.txt" _
, FileFormat:=xlText, CreateBackup:=False
This works great, except that I don't want the file to be called "test" in
production. I need to have a dialog box pop up to ask me what to enter as
the name
I tried
....NEW\" & MsgBox & ".txt"
but it does not work. Any ideas?
macro to save a worksheet
ActiveWorkbook.SaveAs Filename:= _
"\\MyURL\DAILY_PRODUCTION\NEW\test.txt" _
, FileFormat:=xlText, CreateBackup:=False
This works great, except that I don't want the file to be called "test" in
production. I need to have a dialog box pop up to ask me what to enter as
the name
I tried
....NEW\" & MsgBox & ".txt"
but it does not work. Any ideas?