View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default VBA macro (pipe delimited) code help

Note that using .Text will include the "$" in the text file, which
may be OK but wasn't in the original specification.

In article ,
"James S" wrote:

Hi Barb,

Another way you could do it would be to

CHANGE
CurrTextStr = CurrTextStr & CurrCell.Value & ListSep

TO
CurrTextStr = CurrTextStr & CurrCell.Text & ListSep

Hope that helps as well.