ansaurus

Question

How do I concatenate html as a string in VBA?

Answer 1

A:

 htmlText = "<HTML><BODY bgcolor='#0b3767'> <img height='71' width='500' alt='Central Analysis Bureau, Inc. - Know Your Insureds' src='http://cabfinancial.com/images/logoEmail.png'&gt;" _ & "<a href='" & txtLink.Value & "'>Volume " & txtVolume.Value & " Edition " & txtEdition.Value _ & "</a>" _ & txtHtml.Value & "<a href='" & txtLink.Value & "'>Click here to read the complete article</a>" _  & "</BODY></HTML>"

JonH 2009-12-15 15:50:53

Answer 2

+2 A:

The line continuation syntax requires a space before the underscore. Try adding a space at the end of the first line:

src=""http://cabfinancial.com/images/logoEmail.png""&gt;"_

becomes

src=""http://cabfinancial.com/images/logoEmail.png""&gt;" _

JohnFx 2009-12-15 15:58:10

@JohnFx you were exactly correct about the double quotes. I never knew that. Two things: 1) I should have tested the code before posting and 2) How in the world did I get +3 on that when it was flat wrong? Either way, I deleted my post to avoid confusion and misinformation.

Ben McCormack 2009-12-15 16:00:35

No worries. I've had to retract my share of answers too. Personally I hate that syntax for embedding quotes, but it does work. =)

JohnFx 2009-12-15 16:05:52

Thank you so much! I just realized that that was the mistake I made and was about to answer my own question...but you beat me to it =^)

dmr 2009-12-15 16:10:27

Remou 2009-12-15 16:36:03

John... can you also replace the double-double quotes with single quotes? This should make it more readable and should be fine for HTML.

Mark Nold 2009-12-17 01:56:36

Definitely. That is a common approach where double and single quotes are interchangeable in the output.

JohnFx 2009-12-17 03:41:25

Answer 3

A:

I added double quotes around your bgcolor parameter, added a space before your first line continuation character, added double quotes and ampersands around your <a href=txtLink.Value>

BTW: Kudos on using ampersands for concatenation. Some people use + which works, but is confusing.

htmlText = "<HTML><BODY bgcolor=""#0b3767""><img height=""71"" width=""500"" alt=""Central Analysis Bureau, Inc. - Know Your Insureds"" src=""http://cabfinancial.com/images/logoEmail.png""&gt;" _
  & "<a href=" & txtLink.Value & ">Volume " & txtVolume.Value & " Edition " & txtEdition.Value _
  & "</a>" _
  & txtHtml.Value & "<a href=""" & txtLink.Value & """>Click here to read the complete article</a>" _
  & "</BODY></HTML>"

Beaner 2009-12-15 16:09:08

ansaurus

tags:

views:

answers:

How do I concatenate html as a string in VBA?

related questions