Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save excel worksheet in .txt format fast?
Hi all,
probably a very simple problem but I still do not know how to do it: I need to save (via VBA) several worksheets from a rather big Excel workbook, each one of them in as separate *.txt file. Currently this is done by programmatically executing "Save As" command and selecting "Save as type *.txt". Now, this does the job OK but is rather slow and I need to repeat it many times. Is there a way to export a single worksheet to *.txt without saving a huge *.xls file ? Or any other way to make the procedure run faster? Thank you! Max |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save excel worksheet in .txt format fast?
Using the Macro Recorder I produced:
ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\XlsFileSavedAsText.txt", _ FileFormat:=xlText, CreateBackup:=False "MaxS" wrote in message oups.com: Hi all, probably a very simple problem but I still do not know how to do it: I need to save (via VBA) several worksheets from a rather big Excel workbook, each one of them in as separate *.txt file. Currently this is done by programmatically executing "Save As" command and selecting "Save as type *.txt". Now, this does the job OK but is rather slow and I need to repeat it many times. Is there a way to export a single worksheet to *.txt without saving a huge *.xls file ? Or any other way to make the procedure run faster? Thank you! Max |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save excel worksheet in .txt format fast?
Thanks Jim.
I am currently doing exactly what you mentioned in your suggestion but it is slow. Was wondering if there are other ways.. Jim May wrote: Using the Macro Recorder I produced: ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\XlsFileSavedAsText.txt", _ FileFormat:=xlText, CreateBackup:=False "MaxS" wrote in message oups.com: Hi all, probably a very simple problem but I still do not know how to do it: I need to save (via VBA) several worksheets from a rather big Excel workbook, each one of them in as separate *.txt file. Currently this is done by programmatically executing "Save As" command and selecting "Save as type *.txt". Now, this does the job OK but is rather slow and I need to repeat it many times. Is there a way to export a single worksheet to *.txt without saving a huge *.xls file ? Or any other way to make the procedure run faster? Thank you! Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Fast Save | Excel Discussion (Misc queries) | |||
Save as file format excel worksheet 4.0 in Microsoft excel 2007 | Excel Discussion (Misc queries) | |||
fast way creating multiple worksheets with same format in excel? | Excel Discussion (Misc queries) | |||
how to fast format cells? | Excel Discussion (Misc queries) | |||
How to save worksheet in .cvs format? | Excel Discussion (Misc queries) |