Hi Katie,

Simplest way is to copy the worksheets one at a time to a new workbook
(right-click on the sheet tab to get a menu), and then save these as text
files. No macro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Katie" wrote in message
...
Hey there, I am trying to write a macro that will export
excel worksheets to tab delimited text files. If I go to
File and Saveas I can save the worksheet fine but not the
whole work book. Does anyone know of a way I can write a
macro to select all the worksheets and export them all to
a text file? Or perhaps multiple text files, you know
one for each sheet? Any help would be greatly
appreciated. I'm new to this whole thing and it is
harder than I thought it would be. Thanks a bunch!
Mad love, Kate.