View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Copy excel cell to webform (search box) and press enter

On Sunday, June 8, 2014 11:48:11 PM UTC+2, wrote:
On Sunday, June 8, 2014 11:41:48 PM UTC+2, GS wrote:

FYI




My website reads this info from the url and processes it


'behind-the-scenes' to hidden elements on the target webpage. The
code


you found will work so long as you know the element IDs!






--




Garry








Free usenet access at http://www.eternal-september.org


Classic VB Users Regroup!




comp.lang.basic.visual.misc




microsoft.public.vb.general.discussion




Ye sorry for that, i found this in the mean time and it works like a
charm
http://stackoverflow.com/questions/2...cking-a-button
...



except for one thing... The tracking# is located inside the macro,
what i would want is for me to highlight a cell in excel and then
run the macro, so that the tracking# from that cell is pasted into
the websites form.


I solved it with: ie.Document.getElementById("trackNums").Value =
Selection.Cells(1).Text

Thanks for the help :)


Well I wasn't much help, IMO. Glad you found what you needed!

Though if you said you were tracking UPS shipments from the start...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion