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!
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!