LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
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

 
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
Import from a secure site botha Excel Discussion (Misc queries) 1 June 20th 06 07:16 PM
Can't Download Data in Thai Script Victor Viguilla Excel Discussion (Misc queries) 0 June 1st 06 03:51 AM
Download a CSV file from an internet site Microchip Excel Programming 0 March 28th 06 12:41 PM
Looking for Userform examples - site on web, download examples thom hoyle Excel Programming 1 May 10th 05 05:23 PM
Correct a Stock Option Download Script JB[_2_] Excel Programming 1 September 16th 03 03:23 PM


All times are GMT +1. The time now is 08:51 PM.

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"