Something is not working. Where do I set this statement?

Also I want to keep the workbook open after saving the file.


"News" wrote:

Use .GetsaveAsFilename and set the first argument, InitialFilename.

NickHk

"Dan" ...
I want to still prompt them on saving but I wanted to prefill in the name
of
the file into the File Name field of the Save As window.


"News" wrote:

Just do a
WB.SaveAs NameYouWant.xls,xlWorkbookNormal
then when you close, the SaveAs dialog will not show.

NickHK

"Dan" ...

Is there a way to prefill in the "File Name:" in the Save As window
when
using the ActiveWorkbook.Close function?

I want to prefill the filed with the name of the file opened with

DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC
Files,
*.txt; *.asc", Title:="Select the Data File")

Want the workbook name to be the same name as that opened by
DataFileName
(less the .txt or .asc extension) and not "Sheet1".

Thanks