| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export an excel file as text without change of document type
ActiveSheet.copy
ActiveWorkbook.SaveAs "C:\MyFolder\MyFile.txt", xlCSV Activeworkbook.Close SaveChanges:=False Change xlCSV to the type of text file you want. -- Regards, Tom Ogilvy "Michael" wrote in message om... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you change pdf file to excel document? | New Users to Excel | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| how to export a file to my documents as XML data type | Excel Discussion (Misc queries) | |||
| How can I export text from excel autoshapes to a text file? | Excel Discussion (Misc queries) | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
![Michael[_36_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
