Macro, Paste text into webpage, Click Track button to generate result

BDD · May 28th 2016

I am looking for a macro that will do the following:

Copy a number from an active cell in excel
Using Internet Explorer or Firefox, Via a hyperlink in the workbook,
go to https://www.canadapost.ca/cpot…rackNumber?execution=e1s1
paste the copied text
click the Track button

I can get to the web page but I can't get the text pasted or click the Track button

Any help would be appreciated,

Brenda

**S O** · May 28th 2016

Re: Macro, Paste text into webpage, Click Track button to generate result

Hi BDD, welcome to OzGrid.

Assuming you are using IE automation, once the web page has loaded you can just use:

Code

'// Assuming 'IE' represents an InternetExplorer object and the page has fully loaded at this point.
IE.Document.getElementBbyId("tapByTrackSearch:trackSearch:trackNumbers").Value = ActiveCell.Value
IE.Document.Forms(0).Submit

BDD · May 30th 2016

Re: Macro, Paste text into webpage, Click Track button to generate result

Thank you so much, S O.
And sorry for the late reply
You got me going in the right direction and I got it done.
Thanks again.

Brenda

Macro, Paste text into webpage, Click Track button to generate result

Participate now!

Share