View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default 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