Oh yes, I need the previous copy to be there. I'm just trying to take some
drudgery out of a repetitive, daily task :-)

"JLGWhiz" wrote:

P.S. Your old workbook will still be on file, so if you no longer need it,
you will have to delete it.

"Christine" wrote:

Hi group,

I feel that I am close to figuring this out, but am missing the last piece
of the puzzle. I have created a macro that when run, prompts the user to save
the file. The missing pieces are

1) I want the file to be saved in tab delimited format.
2) I want the file to be saved in the same place as the original file.

This is what I have so far:



Option Explicit

Sub SaveAsText()
'
' SaveAsText Macro

Dim FileName As String
FileName = "YourFileName"
Application.Dialogs(xlDialogSaveAs).Show (FileName)
End Sub




Thanks,
Christine