• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Storing a String to be interpreted by VBA

dan_l

Active Member
Hello Chandoo.org! Long time, no talk.

I bring a random question that I can't - for the life of me - figure out.

The set up. I have table like so:

Name, Message
FriendlyNameA, "This is a string of text"
FriendlyNameB, "this is another string of text"

I make an email call to insert the content of "message" into the body of the email. Simple enough.

But, I want to have:

FriendlyNameC, "This is another string of text with a " & sVar & "included in it"

It doesn't really matter what sVar is. I think the object is just to have a "template" of a string message that includes some variables stored somewhere that will be interpreted correctly by VBA.

I've tried searching the internets but the words "string" and "VBA" are rather popular together and I'm not sure what word describes what I"m actually trying to do.

I think the only thought I have that i might try for this might be like adding some cutesy characters to the string or something.
 
Back
Top