PDA

View Full Version : [SOLVED] Including Special Characters (i.e. parenthesis) Within Text



llldebaserll
10-08-2013, 10:05 AM
Hi Folks,

I feel dumb posting about this but I can't find an answer anywhere on the internet. I'm probably not searching with the right key words.

I'm controlling IE from Excel and need to put a javascript command in the address bar. I'm using the SendKeys but (obviously) parenthesis don't show up as text. I just can't find the proper coding/format to achieve this.



' View In Excel
Application.Wait Now + TimeValue("00:00:05")
Application.SendKeys TabKey, True
Application.SendKeys "{BS}", True
Application.SendKeys "javascript:submitform(document.resultform,""xlpaging.asp?data=query"")", True ' I need these parenthesis to show up
Application.SendKeys "~", True

NOTE: For anyone surfing this thread in the future with a similar problem, double quotation marks forces quotes within your text. I.E. "" with force a single quotation mark within your text (I had a hard time finding this information too)

Thanks!

Paul_Hossler
10-08-2013, 12:01 PM
try { } around the ( and )



"javascript:submitform{(}document.resultform,""xlpaging.asp?data=query""{)}"


Paul

llldebaserll
10-08-2013, 02:19 PM
AH! I can't believe I didn't try that! I was pulling my hair out and overlooking an obvious thing to at least try!

Thanks! Works perfectly.