Send enter key to open IE page via Excel VBA

Bigsweets

New Member
Joined
May 28, 2010
Messages
5
Send enter key to open Internet Explorer page via Excel VBA

I am trying to click a webpage input box and use a Send key enter. I can select the Input box, but can not make it Send(Enter). Thanks!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
How was the page opened in the first place?
 
Upvote 0
I opened the page by creating an IE application object, and using the Navigate method to open the URL.
 
Upvote 0
Well why not just use the IE object to automate clicking the button or submitting the form?

Whatever you do try and avoid using SendKeys.:)
 
Upvote 0
Try AppActivate before the SendKeys, however SendKeys is generally unreliable and probably won't work for this. Sounds like you need to automate IE with a bit of HTML document manipulation to populate the input box.
 
Upvote 0
The input box is already populated. I need to "Click" that element and hit ENTER. There is no button for Submit/Enter.

Thanks!!
 
Upvote 0
There is bound to be some method on the page for submitting the form/whatever.

If you are automating IE then you should have access to the HTML document.

Can you post the code you have so far?
 
Upvote 0
This is the html... I just need to know how to emulate whatever happens when I click in the input box and hit "Enter". thanks!


I attempted to paste it in... but the forum wont allow me to. I am so annoyed, this spreadsheet can launch a nuclear weapon but I can't fu$%#%$ send an enter key to a web page I already launched. AAAAAAAAAAAAAAAAAAAAA!!!!!!
 
Upvote 0
<html>
<head>
<title>TD AMERITRADE ™ - khansulo</title>
******** language="javascript">
var tkt = "rapid";
var cmonth = 5;
var cday = 28;
var cyear = 2010;
var emonth = 9;
var eday = 28;
var eyear = 2010;
var save = true;
var margin = false;
*********>
<link rel="stylesheet" type="text/css" href="/amer/css/universal.css">
<link rel="stylesheet" type="text/css" href="/amer/css/snapticket.css">
******** language="javascript" src="/amer/scripts/universal.js">*********>
******** language="javascript" src="/amer/scripts/jquery.js">*********>
******** language="javascript" src="/amer/scripts/snapticket.js">*********>
******** language="javascript" src="/amer/scripts/Order.js">*********>
******** language="javascript" src="/amer/scripts/SetRapidOrder.js">*********>
******** language="javascript" src="/amer/scripts/rapidSnap.js">*********>
******** language="javascript" src="/amer/scripts/hotkeys.js">*********>

******** language="javascript" src="/amer/scripts/snapticket_AC_OETags.js">*********>

******** language="javascript" src="/amer/scripts/jquery.block.snap.js">*********>
********>
function blockSnapticket() {
$.blockUI($("#snapBlock")[0], { pageMessage: '', border: '0px' });
}
function unblockSnapticket() {
$.unblockUI();
}
*********>
 
Upvote 0
Can you post the URL you are working with?

What you've posted isn't really HTML, it's Javascript that is used on the page.

If you can't post the actual URL but have access to the HTML source then you should be looking for elements like form, input etc and things like submit, ******* etc
 
Upvote 0

Forum statistics

Threads
1,215,764
Messages
6,126,751
Members
449,335
Latest member
Tanne

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top