LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I press enter inside a cell? subway Excel Discussion (Misc queries) 4 April 2nd 23 07:12 PM
how do I get to cursor to stay on the cell when I press enter MUAR Excel Worksheet Functions 1 July 14th 09 01:11 AM
How do I change the direction of the cell when I press enter jonathan New Users to Excel 1 January 8th 09 03:25 PM
Enter data and press enter to move to specific cell Programing problem[_2_] Excel Programming 2 January 10th 07 03:35 AM
Cannot view cell content until I press enter AnisKhan Excel Discussion (Misc queries) 4 June 9th 06 06:06 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"