ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export range to text file (https://www.excelbanter.com/excel-programming/308397-export-range-text-file.html)

martin

Export range to text file
 
Based on what I have seen thru the Excel menus, there does
not appear to be a way to export a range of cells to a
text file (or any other file type). The File/Export
command exports the entire file.

I am assuming that I will need to do this thru a script of
some sort. Can it be done this way? If so, please
provide details since I am new to this.

Thanks.


Chip Pearson

Export range to text file
 
See example code for exporting to text files at
http://www.cpearson.com/excel/imptext.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"martin" wrote in message
...
Based on what I have seen thru the Excel menus, there does
not appear to be a way to export a range of cells to a
text file (or any other file type). The File/Export
command exports the entire file.

I am assuming that I will need to do this thru a script of
some sort. Can it be done this way? If so, please
provide details since I am new to this.

Thanks.




martin

Export range to text file
 
Thanks. I will give that a try.


-----Original Message-----
See example code for exporting to text files at
http://www.cpearson.com/excel/imptext.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"martin" wrote in

message
...
Based on what I have seen thru the Excel menus, there

does
not appear to be a way to export a range of cells to a
text file (or any other file type). The File/Export
command exports the entire file.

I am assuming that I will need to do this thru a script

of
some sort. Can it be done this way? If so, please
provide details since I am new to this.

Thanks.



.



All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com