Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default How to include a double quotation character in a string?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,089
Default How to include a double quotation character in a string?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default How to include a double quotation character in a string?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CELL return value without double quotation marks Rui Gomes Excel Worksheet Functions 1 November 14th 07 10:40 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
Excel CSV file: How to preserve double quotation mark on Unix ftp? Shannona Excel Discussion (Misc queries) 2 October 3rd 06 07:54 PM
double quotation marked tikchye_oldLearner57 Excel Discussion (Misc queries) 2 August 20th 06 07:44 AM
Single or Double Quotation Mark and it comes up twice J.R.HOLMES Setting up and Configuration of Excel 1 December 31st 05 08:51 PM


All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"