IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Windows vX.X Forum / VBA question.
Post #112,128
by inthane-chan
Picture of inthane-chan
7/30/03 7:31:33 PM
Reply
New VBA question.
Couldn't bring myself to defile the programming forums with this question.

VBA for Excel, I'm trying to put the following string into a cell.

"=IF(OR(NOT(OR(WEEKDAY(R[0]C[" + StStart + "])=3,WEEKDAY(R[0]C[" + StStart + "])=6)),OR(F2-R[0]C" + StStart + ">10,R[0]C[" + StFinish + "]-R[0]C[" + StStart + "]<0)),"Possible data integrity issue","")"

As you'll notice, there's a couple extra quotes near the end of the string. I don't remember what the VB Const is for the quotation mark - if somebody could set me straight, I'd appreciate it.

Thanks,
Thane
And though you hold the keys to ruin of everything I see/With every prison blown to dust, my enemies walk free/Though all the kingdoms turn to sand and fall into the sea/ I'm mad about you I'm mad about you
Post #112,130
by ChrisR
7/30/03 7:40:08 PM
Reply
New Not sure what the question is?
If it's a question about how to use double quotes as constants, you can either double the double quotes or use concatenate to bring in Chr(34). Something along the lines of:

Chr(34) + "A quote ""inside"" a string" + Chr(34)
Post #112,166
by inthane-chan
Picture of inthane-chan
7/30/03 10:35:11 PM
Reply
New Yup, that's what I'm looking for.
Couldn't find any reference for that stuff.
And though you hold the keys to ruin of everything I see/With every prison blown to dust, my enemies walk free/Though all the kingdoms turn to sand and fall into the sea/ I'm mad about you I'm mad about you
Post #112,134
by JayMehaffey
7/30/03 7:57:26 PM
Reply
New Don't think there is one.
Post #112,219
by mmoffitt
7/31/03 9:28:43 AM
Reply
New There is the Character Map applet.
bcnu,
Mikem

The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism.

- Mark Twain, "Monarchical and Republican Patriotism"
Post #112,138
by altmann
7/30/03 8:33:54 PM
Reply
New Double up your embedded quotes
ie: "" instead of "

This is for a string in code.

For manually pasting into a cell, just pasting your example in worked fine.


--
Chris Altmann
     VBA question. - (inthane-chan) - (5) - July 30, 2003, 07:31:33 PM EDT
         Not sure what the question is? - (ChrisR) - (1) - July 30, 2003, 07:40:08 PM EDT
             Yup, that's what I'm looking for. - (inthane-chan) - July 30, 2003, 10:35:11 PM EDT
         Don't think there is one. -NT - (JayMehaffey) - (1) - July 30, 2003, 07:57:26 PM EDT
             There is the Character Map applet. -NT - (mmoffitt) - July 31, 2003, 09:28:43 AM EDT
         Double up your embedded quotes - (altmann) - July 30, 2003, 08:33:54 PM EDT

He poops from his butt.
37 ms