View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default VB PasteSpecial when range changes

If by "parentheses" you mean the double-quotes, see:

http://www.mcgimpsey.com/excel/textf...ml#csvnoquotes



In article ,
mjwillyone wrote:

Mr. McGimpsey,

Thank you so much for your help. The macro worked great! I have one
question in relation to the output file format. Is there a way that
the text file can display the separate lines of text without the
parenthesis?

"Stephen Jones,227,44525,123567892"
"Ronald Jameson,668.33,48592,885246598"
etc . . .

(Note that while the above text "fields' are separated by commas, that
is exactly how I have "programmed" it to do.)