![]() |
Quotation marks in a string
Hi,
I want to run a macro that writes out to a text file the following string: <gamma unit="DEG" 0.0 </gamma I've tried the following method: Write #1, "<gamma unit=""DEG"" 0.0 </gamma" But then I get exactly that: "<gamma unit=""DEG"" 0.0 </gamma" Of course, I don't want the double quotation marks, but only once (i.e., "DEG", not ""DEG""). Any hint will be greatly appreciated. Fabian |
Quotation marks in a string
Well, I've just found the answer myself :)
Use Print instead of Write. Thanks Fabian. Fabian "Fabian Grodek" wrote: Hi, I want to run a macro that writes out to a text file the following string: <gamma unit="DEG" 0.0 </gamma I've tried the following method: Write #1, "<gamma unit=""DEG"" 0.0 </gamma" But then I get exactly that: "<gamma unit=""DEG"" 0.0 </gamma" Of course, I don't want the double quotation marks, but only once (i.e., "DEG", not ""DEG""). Any hint will be greatly appreciated. Fabian |
Quotation marks in a string
"<gamma unit=" & chr(34) & "DEG" & chr(34) & " 0.0 </gamma"
"Fabian Grodek" wrote in message ... Hi, I want to run a macro that writes out to a text file the following string: <gamma unit="DEG" 0.0 </gamma I've tried the following method: Write #1, "<gamma unit=""DEG"" 0.0 </gamma" But then I get exactly that: "<gamma unit=""DEG"" 0.0 </gamma" Of course, I don't want the double quotation marks, but only once (i.e., "DEG", not ""DEG""). Any hint will be greatly appreciated. Fabian |
Quotation marks in a string
Thanks Henry.
That's another option if I need to use the "Write" method anyway. Fabian "Henry Markov" wrote: "<gamma unit=" & chr(34) & "DEG" & chr(34) & " 0.0 </gamma" "Fabian Grodek" wrote in message ... Hi, I want to run a macro that writes out to a text file the following string: <gamma unit="DEG" 0.0 </gamma I've tried the following method: Write #1, "<gamma unit=""DEG"" 0.0 </gamma" But then I get exactly that: "<gamma unit=""DEG"" 0.0 </gamma" Of course, I don't want the double quotation marks, but only once (i.e., "DEG", not ""DEG""). Any hint will be greatly appreciated. Fabian |
All times are GMT +1. The time now is 08:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com