Posted to microsoft.public.excel.programming
|
|
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.)
|