Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings that have quotes in them
I have a string of text that i need to put in vba, however the strin
itself has quotes in it, so how do i properly write thi line...everything that's blue is a break in the string where i need t put vba code : =HYPERLINK("[I:\General Documents\ & Format(Date, "mmmm") \Returns.xls".xls] & Sheets(ActiveSheet.Index + 1) & !A1", txtName.value & ) Thanks! : -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings that have quotes in them
both of these give the same result
sstring = """" sstring = "ggggggg" & """" & "gghbnfg" sstring = Chr(34) sstring = "ggggggg" & Chr(34) & "gghbnfg -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Double quotes bracketing text strings that include commas | Excel Discussion (Misc queries) | |||
change straight quotes to curly quotes | Excel Discussion (Misc queries) | |||
How do i get historical stock quotes using MSN Money Stock Quotes | Excel Discussion (Misc queries) | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions |