Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Worksheet to text file!!!!!!!!!!
Help please, I found a macro that exports the values in an excel worksheet to
a delimeted text file, but I am very new at this so, basically I dont really know what to do with this macro, and how to tell it what the range of my values are. Also, im not sure how to input the delimeters that I want The macro I straight copied pasted from this Web-site http://www.erlandsendata.no/english/...atextexportcsv |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Worksheet to text file!!!!!!!!!!
I need the output text file to look something like:
$VALUE CASE=100., VALUE=55. $ $VALUE CASE=110., VALUE=56.$ The delimeters a $ . , . $ "N.F" wrote: Help please, I found a macro that exports the values in an excel worksheet to a delimeted text file, but I am very new at this so, basically I dont really know what to do with this macro, and how to tell it what the range of my values are. Also, im not sure how to input the delimeters that I want The macro I straight copied pasted from this Web-site http://www.erlandsendata.no/english/...atextexportcsv |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Worksheet to text file!!!!!!!!!!
N.F.,
You haven't said what's in the cells from which you want to write a text file. Maybe you can use the Text Write Program at http://www.smokeylake.com/excel/text_write_program.htm. No macro coding required. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "N.F" wrote in message ... I need the output text file to look something like: $VALUE CASE=100., VALUE=55. $ $VALUE CASE=110., VALUE=56.$ The delimeters a $ . , . $ "N.F" wrote: Help please, I found a macro that exports the values in an excel worksheet to a delimeted text file, but I am very new at this so, basically I dont really know what to do with this macro, and how to tell it what the range of my values are. Also, im not sure how to input the delimeters that I want The macro I straight copied pasted from this Web-site http://www.erlandsendata.no/english/...atextexportcsv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a worksheet as . prn text file - record length | Excel Discussion (Misc queries) | |||
how to import more than 1 text file into the same Excel worksheet. | Excel Discussion (Misc queries) | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |