Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing text string with imbedded quotes to a text stream
I want to write a series of comand line strings having imbedded quotes like
this to a command file (.cmd), erase "C:\Essay\FE8 Teachers\Code Files.SAS" /Q Can this be done? (I'm sure it can but I cannot figure out how to do it.) The quotes are necessary because of the possiblity of spaces in parameters of the command written to the export file. The key VBA statement that writes these command line strings is: OutArray(I) = "erase " & "'" & cel(I, 3) & cel(I, 2) & "'" & " /Q" & vbCrLf The resulting .cmd file will be executed from a command line window. As you can see from the code, I am currently using the string "'" to insert 'quotes' around the command lline parameters. Unfortunately, this does not work. Command line parameters must be brackets with full fledged quotes (command "param1" "param2") and not asn apostrophe. How can I include quotes (") in an output string written to a textfile in VBA? Thank you. John Wirt T |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing text string with imbedded quotes to a text stream
John, two quotes ("") within a string will result in one being output.
try: OutArray(I) = "erase " & """" & cel(I, 3) & cel(I, 2) & """" & " /Q" & vbCrLf Fred "John Wirt" wrote in message ... I want to write a series of comand line strings having imbedded quotes like this to a command file (.cmd), erase "C:\Essay\FE8 Teachers\Code Files.SAS" /Q Can this be done? (I'm sure it can but I cannot figure out how to do it.) The quotes are necessary because of the possiblity of spaces in parameters of the command written to the export file. The key VBA statement that writes these command line strings is: OutArray(I) = "erase " & "'" & cel(I, 3) & cel(I, 2) & "'" & " /Q" & vbCrLf The resulting .cmd file will be executed from a command line window. As you can see from the code, I am currently using the string "'" to insert 'quotes' around the command lline parameters. Unfortunately, this does not work. Command line parameters must be brackets with full fledged quotes (command "param1" "param2") and not asn apostrophe. How can I include quotes (") in an output string written to a textfile in VBA? Thank you. John Wirt T |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing text string with imbedded quotes to a text stream
Thansk. will try. John
I tried three (""") but it didn't work. "Fred" <leavemealone@home wrote in message ... John, two quotes ("") within a string will result in one being output. try: OutArray(I) = "erase " & """" & cel(I, 3) & cel(I, 2) & """" & " /Q" & vbCrLf Fred "John Wirt" wrote in message ... I want to write a series of comand line strings having imbedded quotes like this to a command file (.cmd), erase "C:\Essay\FE8 Teachers\Code Files.SAS" /Q Can this be done? (I'm sure it can but I cannot figure out how to do it.) The quotes are necessary because of the possiblity of spaces in parameters of the command written to the export file. The key VBA statement that writes these command line strings is: OutArray(I) = "erase " & "'" & cel(I, 3) & cel(I, 2) & "'" & " /Q" & vbCrLf The resulting .cmd file will be executed from a command line window. As you can see from the code, I am currently using the string "'" to insert 'quotes' around the command lline parameters. Unfortunately, this does not work. Command line parameters must be brackets with full fledged quotes (command "param1" "param2") and not asn apostrophe. How can I include quotes (") in an output string written to a textfile in VBA? Thank you. John Wirt T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
Saving as Text (tab delimited) surrounds text with "quotes" | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |