All,

A co-worker inherited a process to create a daily file that gets uploaded into email. Currently the macro prompts the user to click on okay to save the file. I'm not sure how to make the macro to just save the file. It gets written to the same file name each day. The filename is "call_data.txt". I'm not sure why they set it up this way. Everything, I've tried hasn't worked. Any help would be greatly appreciated. I'm not sure why they're testing for "Win".

Here's the exiting code that I want to change to just save the file.

If Left(Application.OperatingSystem, 3) = "Win" Then
SaveFileName = Application.GetSaveAsFilename(CurFile, _
"Text Delimited (*.txt), *.txt", , "Text Delimited Exporter")
Else
SaveFileName = Application.GetSaveAsFilename(CurFile, _
"TEXT", , "Text Delimited Exporter")
End If

Thanks in advance.

Brian