Excel/VBA/Internet Explorer
 

To whomever can help me!


I have been trying to get data from a webpage for which I have to
select items in a dropbox and click a button. I have tried to do so
with the sendkeys command, but IE is not allowing me to control it that

way.


I have been researching thoroughly and I got some ideas that might
work, but that I can't get to specifically load what I need.


This is the basics of what I have:


Set IExp = CreateObject("InternetExplorer.Application")


With IExp
.Visible = True
.navigate (url1)
Set ipf = IExp.document.all.Item("miforma")
ipf.submit
End With


End Function


The item "miforma" loads for one of the buttons, and I want it to
select the one on top!


If anyone can help, a sample url is
http://www.supervalores.gov.co/web_v...s_inf_fin&Tipo....

Here you can see, in the source code, thet miforma is an item that
submits a form, but I cannot find the other one!


Many thanks!
Alex

Excel/VBA/Internet Explorer
 

Hello Alex

I hope this link helps you


http://www.excelforum.com//showthread.php?t=370887


Regards,
miche

--
michelxl
-----------------------------------------------------------------------
michelxld's Profile: http://www.excelforum.com/member.php...fo&userid=1736
View this thread: http://www.excelforum.com/showthread.php?threadid=48722