Saving file as tab delimited text - macro

[Klara86]

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":

Please Login or Register  to view this content.

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


Thanks for helping!!!
Klara

[DGagnon]

Hi there, welcome to the Forum

you can give something like this a shot (using cell B2 for file name)

Please Login or Register  to view this content.

[Klara86]

Thats great! Thanks!!

[DGagnon]

No problem, glad i could assist.