View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
Dave Miller Dave Miller is offline
external usenet poster
 
Posts: 72
Default Using Script to download from secure site

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