Search results

I'm automating a login page in IE. After I enter the user & pass and press enter a pop-up comes up. This is a disclaimer box where the user has to press 'ok' to make it go away. Does anyone know how to get rid of the popup box? I tried using the sendkey without success. I don't think it's a...

I got it all working. I made my program in Excel. I found out that I had to wait for excel to be ready before reading values from it. Do: Loop Until xlObj.Ready The program was working fine as long as you didn't try and do anything else while it was running. If you did it would repeat old...

Hi I made a program that people might want to use. It recursively gets all the tags in a HTML document. Public Sub SearchDom(myFrame As HTMLDocument, myFile As String, Optional mySpace As String = "") On Error Resume Next Open myFile For Append As #1 For i = 0 To...

Thanks Darbid, The modified version of your program to make the text file out of the outerHTML at first didn't have any tables in it. After waiting for IE to be done the text file was 2mb! I found a way that seems to only print out what I want using: debug.Print...

Well I feel stupid. It turns out I wasn't able to see the information I wanted because I wasn't waiting until the page was done loading. As soon as I added: Do: Loop Until Not IEwindow.Busy I was able to see all the information on the page and find out the name of the items I wanted...

Thanks Darbid and everyone else for your input. I've got to finish a big report that my boss has been waiting for. I'm hoping to have it done and back to my investigation by the middle of next week. I'll be posting more then on my progress. My final thoughts for now are that maybe it is...

Here is the VBA code that is run on the URL. Public Function PrintDom(mainFrame As HTMLDocument) Dim domElement1 As HTMLGenericElement Dim domElement2 As HTMLGenericElement Dim domElement3 As HTMLGenericElement Dim domElement4 As HTMLGenericElement Dim domElement5 As...

That's the problem, there is no table. I can see it when I view the source code in the browser. However I can't see a table element inside of VBA.

from view source in browser <TD> <LABEL FOR='ALL_CRS_SRCH_VW_COURSE' CLASS='PSSRCHEDITBOXLABEL' >Course Code:</LABEL> </TD> A printout of all the tagnames in the url is: --> HTML --> HEAD --> TITLE --> TITLE --> BODY --> MAP --> AREA...

When I take the url from the subframe and put it in the main browser I can view the source code and the text is there inside of a table. But when I list all the dom elements and sub elements of those with my program there are no table tagnames? Any ideas?

I can't find any of the text I'm looking for. I think they must be burried within frames. Has anyone wrote a vba program to search for text and keep going down levels until it finds it. Then it reports the path back? thanks for all the advice

It turns out that the subframe that I was working with is in turn made up of several subframes. I found the right one and navigated it to the page in my browser history. But the javatree on the left is not expanded. I suppose it doesn't really matter, but I would like to know how to control the...

No the program is going to enter stuff in but I was going to wait to get stuck on that until after I figured out the tree navigation. I previously had meant to say that I just didn't want to automate the user login screen.

The first attached screenshot is after the user has logged in and my program has taken control and went to the TAS module of the system. The second screenshot is taken after I have expanded the tree and clicked on a few levels. I went to my IE history and looked at all the pages for this...

It's a menu tree that is displayed with Javascript so there is no button to click on.

Thanks ajetrumpet, I am using SHDocVw. It's a human resources website at work. I didn't want to automate people's login user/password for security reasons and I don't want to write anything in case the program messes up (It's a live site). I would like to automate the getting of information...

Hi Everyone, I'm trying to automate getting information from inside of IE. I'm making an IE object from an already open browser window. All of the pages on this site are setup with 2 frames on each. The first frame(0) has top navigation links that don't change. The second frame(1) is what...

Thanks Darbid. Your suggestion steered me in the right direction. In my case I don't have to wait for elements to be ready because the user has to login to the site first. Also since I'm making a IE object from an already open page I can't use "me." I kept modifying the code below to print...

Hello Everyone, My customer has to log-in to a website and enter a page with 2 frames in it. Inside of one of the frames is a table where they cut & paste the info to get it out. I'm trying to find a way to get that info for them once they see what they want on the screen. The problem is that...

I've tried activating the sheet and also selecting a cell before I bring up the box. I'm not sure how to set the focus on the sheet.