Hello,
Using VBA to write an excel macro, is it possible to command another application, in my case Internet Explorer?
If so, Could you please help me design a code to complete these tasks:
Select a number in a column (from Excel 2007)
Switch to internet explorer
paste the number (The box on the website should already be selected. In case it matters, the link is http://www.upcdatabase.com/itemform.asp)
hit enter
copy the url
hit back on the browser (This should also reselect the box for entering the next number, or at least it does when I use the backspace key after clicking on the page.)
paste the url in the column next to the number
and repeat the process again with the next number in the column
Is this even possible?
Thank you immensely for your help,
Bub
Using VBA to write an excel macro, is it possible to command another application, in my case Internet Explorer?
If so, Could you please help me design a code to complete these tasks:
Select a number in a column (from Excel 2007)
Switch to internet explorer
paste the number (The box on the website should already be selected. In case it matters, the link is http://www.upcdatabase.com/itemform.asp)
hit enter
copy the url
hit back on the browser (This should also reselect the box for entering the next number, or at least it does when I use the backspace key after clicking on the page.)
paste the url in the column next to the number
and repeat the process again with the next number in the column
Is this even possible?
Thank you immensely for your help,
Bub