ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export data to Text file without leaving worksheet. (https://www.excelbanter.com/excel-programming/424650-export-data-text-file-without-leaving-worksheet.html)

rmcompute

Export data to Text file without leaving worksheet.
 
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?

[email protected]

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?



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

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