View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sbitaxi@gmail.com is offline
external usenet poster
 
Posts: 158
Default Get address from iFrame reference in page source

Hi Joel:

Method 2 finds the IFRAME tag, but I still can't figure out how to
grab the address. I've been digging through documentation online, but
I don't know how to phrase my question correctly for this. The site I
am navigating through is a database for our online donations.
Currently I log in, run a report and request the report in Excel
format. The fields and buttons I manipulate in order to export the
data to Excel format are all contained in an iFrame and I can't access
any of the objects.

I am trying to open the iFrame address using code and the only place I
can find it is in the page source. ViewSource

That's the string I provided at the beginning.

Once I've got that string, I want to extract the sessionID and GUID
which I can use in another string to force the export to an Excel
file.

Does that help?


Steven


2) Or do you already have an Internet object and are try to find the tag
item "iframe". *Tags start with <iframeand end with * */iframe *or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all theiframeitems. *You may have to look through each one
to find the correct one.

for each itm in Mytag
* *if itm.ClassName = "xyz" then

* *end if

next itm