Chip Pearson has written code that will do this for you:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"Andy" wrote in message
...
This is probably a very simple solution but I need to save a woorksheet as
a
semi-colon delimited file. How do I do this as I can only find comma or
space delimiters as save options.

Thanks
Andy