Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
My string has to include double quotation characters in a string. For instance following sentence I need to code into string: Elements "abc", "acb", "cba" are the solution. How to code it so VB does not interpret double quotation characters as an end or begining of the string? George |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
George
try: Sub test() Dim sString As String sString = "Elements ""abc"", ""acb"", ""cba"" are the solution." MsgBox sString End Sub Regards Trevor "Georgee" wrote in message ... Hi! My string has to include double quotation characters in a string. For instance following sentence I need to code into string: Elements "abc", "acb", "cba" are the solution. How to code it so VB does not interpret double quotation characters as an end or begining of the string? George |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the solution but it is not working for me, this string is
being generated by looping and multiple concatenation of variable & Activesheet Name and do not take extra "" cahracters For parTabStep = 1 To 12 Sheets(arrTabs(parTabStep)).Select If Cells(1, 1) = 3 Then parThreePage = parThreePage & ", " ActiveSheet.Name EndIf Next I hope I have clearly explained my problem. George Trevor Shuttleworth wrote: George try: Sub test() Dim sString As String sString = "Elements ""abc"", ""acb"", ""cba"" are the solution." MsgBox sString End SubRegards Trevor "Georgee" wrote in message ! My string has to include double quotation characters in a string. For instance following sentence I need to code into string: Elements "abc", "acb", "cba" are the solution. How to code it so VB does not interpret double quotation characters as an end or begining of the string? George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELL return value without double quotation marks | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
double quotation marked | Excel Discussion (Misc queries) | |||
Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel |