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 |
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 |
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 |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com