Thread: Export an excel file as text without change of document type
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_36_] Michael[_36_] is offline
external usenet poster
  
Posts: 1
Default Export an excel file as text without change of document type
Hello,

I'm using excel to generate quite large text files. I want to save
automatically from a VB script the result of an excel sheet in a text
file. But using the "save as" function changes the document type of my
excel sheet.

Is there any option to just export the text file and leaving the Excel
sheet as it is?

Yours

Michael
Reply With QuoteReply With Quote