Hi!

I have heaps of files and I need to save them as a tab delimited text (.txt) after I did some changings in each of them. I tried to write a macro for that but I cant make it that the file keeps its original name. If I do it like this it always gets the name "Track 13-3-08":

Sub speichernalstxt()
'
' speichernalstxt Macro
'
' Keyboard Shortcut: Option+Cmd+b
'
    Range("O221").Select
    ActiveWorkbook.SaveAs Filename:= _
        "Macintosh HD:Users:stefandittmann:Desktop:Test:Track 13-3-08.txt", FileFormat _
        :=xlText, CreateBackup:=False
    Range("O221").Select
    ActiveWindow.Close
End Sub

How can I make it to keep the original name or to take the name out of cell B2?


Thanks for helping!!!
Klara