Excel VBA with Internet Explorer (frames within frames?)

Hello,

I'm having difficulty trying to get the class id, name id, element id etc on Internet Explorer which I believe is in frames.

In the Developer Tool, I'm able to search "Monthly Operational Reports" - the 14th branch (See attached).

However, when I tried to go further down, and that is "sub-branch of the 14th branch", I'm unable to find "Monthly Cost, Revenue and ASR". Not to mention too that I can't find the "leaves" - the 2 reports that I need to run "Outbound" and "Inbound".

Question now is, how do I go and find these "frames", "element", "tag" etc so that I could have the VBA to "find" and "click" on these to have my report automated?

Yes I did.

In fact, I tried to run the code, and I get errors.

One of them could be the IE is still running.

I've attached a print screen of my intranet webpage as well as the "source code". I don't know if this is considered frame.

I also started working with Iframes and while I do not have the answer I believe this might help if you can locate the HTML URL within the source code for the IFrame itself. For instance the source code looked like this below. It was located within a form inside a <div

HTML Code: 

HTML Code: 

HTML Code: 

Then I found the IFrame finally

HTML Code: 

I simply allowed the macro to navigate to the action which was a URL that was within the IFrame and then I was able to use the F12 developer tools to use the ARROW button function to identify which obeject I was looking for. I hope that helps some.

The easiest way to find the IFrame if there is one right click view source on the menu bar or the top of the Iframe itself and then within the source code search for the word IFrame. Typically most programmers will use this in their URL, ID, or ACTION, usually. If not best of luck to you because I have not found an easier way yet. See pic for where I right clicked my screen it might help.

Right click view source.jpg

The "IFrameDailyReport.aspz?view=1" was the directory on the website that I needed to attach to my URL to navigate inside the IFrame if that makes sense.

Thanks jessebranum777...but I tried to find it...still couldn't find it.

Especially the "children" of the branch. I've attached a print screen of the developer (on the 1st post), but i still couldn't find it no matter how I search :'(

Originally Posted by Norie

dluhut

What code are you referring to?

By the way, have you considered that the page is dynamic and some of it's content might be being generated dynamically and therefore might no appear when you look in Developer Tools?

I'm sorry for not putting the code...below is part of the code.

Please Login or Register  to view this content.

When you say dynamic? What do you mean? Do you mean that the order of "Monthly Operating Report" could move every time it's loaded?

As far as I can think of, it's not dynamic, since every time I open up, it's always the same place and the same name (see my attached on the 1st thread...the "frame" to the left is always the same).

What I'm having difficulty is getting to click on my "outbound" and "inbound" link to open up a new "window" (probably another frame). I can't even get "Monthly Cost, Revenue and ASR" I tried to search for it, even using the ARROW, and it doesn't find.

Originally Posted by Norie

I have no way of knowing for sure if it's dynamic without being able to access the page but from what you describe it does sound as though something is going on behind the scenes.

For example it sounds like you have some sort of (dynamic) tree structure on the left hand side of the page.

Have you tried searching for 'George Carrier Balance - Outbound'?

Yes I did. I even try to search for "Monthly Cost, Revenue and ASR" and I can't find it.

I can only find on the "high level of the branch" such as "Administrative Reports", "Monthly Operational Reports" etc.

Originally Posted by Norie

Did you try the Select element button I suggested earlier?

Yes I did. I click on the "Arrow" or Ctrl + B and then clicking it either on "Monthly Cost, Revenue and ASR" or "George Carrier Balance - Outbound" and still did not find any

I was looking at my senior's work that he left before he left the company. He had a partial code done that was able to get for other reports. In the attached file, it seems that he's able to rename the supposedly "(General)" to other names (in this case ieIXReport - top left red circled). Notice too that on the top right red circled, which used to be "(Declarations)" now is rename to "NewWindow2".

Anyone knows how to "rename" this?

Part of the code that he has declare is

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.