Strings that have quotes in them

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

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! :
 
both of these give the same result

sstring = """"
sstring = "ggggggg" & """" & "gghbnfg"


sstring = Chr(34)
sstring = "ggggggg" & Chr(34) & "gghbnfg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using TEXT function in VBA 8
Macro that will insert a simple text string in top cell of text file 1
Losing Quotes 2
Returning Part of a String 12
Using a string variable to change a file name 2
Excel VBA to search all macro code in Excel module for specific string criteria 0
Grey Fill for all cells that contain a certain string in hyperlinkaddress 4
Creating a formula in VBA with quoted strings 1

Back
Top