View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eric@msofficegear.com is offline
external usenet poster
 
Posts: 6
Default Export data to Text file without leaving worksheet.

you can use "data validation" allow option select "list"
Source select worksheet Range

"rmcompute" wrote:

I would like to set up a worksheet where the user can set up a column or
columns of data and then push a button to have the data stored as a tab
delimited text file. I would like to do it without having the user leave the
current spread sheet. Is this possible?