LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
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
Launching Excel From internet Explorer pjnesbitt Excel Discussion (Misc queries) 0 June 27th 06 04:21 PM
Running Internet Explorer from Excel Wojciech G. Charts and Charting in Excel 3 August 19th 05 02:50 PM
Internet Explorer & Excel David Excel Programming 0 February 4th 05 08:51 PM
Can I control Internet Explorer using Excel VBA? JohnI Excel Programming 2 September 1st 03 12:21 AM


All times are GMT +1. The time now is 02:05 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"