Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export range to text file Matthew Scheperle Excel Discussion (Misc queries) 1 March 21st 10 03:30 AM
How can I export text from excel autoshapes to a text file? Donncha Excel Discussion (Misc queries) 0 July 20th 06 04:58 PM
Cell export to Text File? Steve Excel Discussion (Misc queries) 3 December 7th 05 03:13 PM
Export excel file to semicolon delimited text file capitan Excel Discussion (Misc queries) 5 April 7th 05 03:06 AM
Export values in a text file Matrix[_2_] Excel Programming 7 November 2nd 03 04:29 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"