Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Edgar,
In the VBE you need to use the Locals window to view properties of the ie object. Step through your code until you have the ie object initiated. Go to the locals window start drilling down from the ie object -- Document -- Forms -- Item 1 If this form item has a value in the id property, it can be referenced directly in code, e.g. Set oForm = ie.document.all.item("FormID") If not you will need to loop through all the forms to identify it by name; with ie.document.forms for i = 0 to .length if .item(i).name like "Your Form Name" set oForm = .item(i) end if next end with The locals window will give you a treeview of any objects properties, learn to use it and you will be amazed by how much easier programming is. Regards, David Miller |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import from a secure site | Excel Discussion (Misc queries) | |||
Can't Download Data in Thai Script | Excel Discussion (Misc queries) | |||
Download a CSV file from an internet site | Excel Programming | |||
Looking for Userform examples - site on web, download examples | Excel Programming | |||
Correct a Stock Option Download Script | Excel Programming |