Search results

Hi All, I thought I'd contribute something I wrote as a way of saying thanks for all the advice. I had the need to transfer a large 3000 row table from a website into Access. I tried the normal DAO.Recordset route but it was way too slow(talking 10 minutes). I then looked into putting it...

Hi Everyone, I don't have any folder/install permissions at work and we're forced to use internet explorer 6. I've automated a bunch of tasks for the office staff where they have to log into the HR/Training web app. After they login they can run my program to do a variety of mundane tasks...

This works but has the same problem with bringing up the information bar. Is there a way to access the events without putting IE inside a form? I don't want to have to re-write the whole thing to account for it being inside another window. Right now I'm creating a new object Dim ieObj...

No it's not me. I recognize it from my research into my problem and it's similar. How would you go about running the javascript directly. Can you give me an example? I've tried myself without success. Can you give me an example of how to get info on these events? It works without it, but...

Yes Darbid it works like a charm. Thanks to you :) It is much simpler than getting approval to run an .exe file. I'm doing all of this from Excel, but the VBA is almost 100% the same as Access The screenshot shows the information bar that comes up when my program clicks on the anchor...

Hi Everyone, I'm trying to make a program at work that opens up an IE object in it's own window and navigates to a certain page and then downloads a file. What I have so far is a program that: 1. Opens IE to the login page 2. Opens up a hidden Excel file with a timer to handle Java pop...

Hi Darbid, I just got back from vacation, so sorry for the long reply. I originally made the program on Excel because that is closest to the end user. It has the same problem in Excel but I never tried opening IE from a form. I think what is happening is that VBA was never designed to be...

Hi Darbid, I've attached another database file where I'm trying to get it to work with IE in it's own window. You can see that I'm trying different variations in case the hwnd is different when IE is outside of the form. Joe

Darbid, I modified your database and got it to enter the username and password, call the timer and then press submit when you click on the "Command1" button after the form loads. I tried to avoid this by calling another routine in the form load event that then did the above stuff. In this...

I noticed that my confirmation box says "microsoft internet explorer" After changing your code to wnd1 = FindWindow("#32770", "Microsoft Internet Explorer") from wnd1 = FindWindow("#32770", "Windows Internet Explorer") It works! I'm going to see if I can get it to work now...

I tried it like you said, but the confirmation box never goes away. Your form brings up the url and I enter a fake username and then a password. I click on the "Command1" button and then click on "Sign In" on the actual page. I tried several times with waiting different amounts of time from...

Ok. I tried launching it from a form and putting your timing routine in a separate module. I also tried running my routine from a standalong module with yours in a seperate module. The same thing happens, no text prints in the immediate window until I press cancel or ok on the pop-up box from...

I'm not using a form. I'm just running it from the intermediate window. I'll try putting the code in a different module though.

Hi Darbid, I have tryed alot of variations on your program and what I'm finding is that when the IE popup box comes up VBA stops running along with the timer. Once I click cancel or ok, I can see the timer start back up again. Because of this it is not seeing the pop-up box because VBA is...

Never Mind, I figured it out. Even though I didn't have "Option Explicit" it was looking for the strings to be initialized. If you change: strTitle = Space(100) strClass = Space(100) To: Dim strTitle As String strTitle = Space(100) Dim strClass As String strClass = Space(100)...

Can anyone please tell me why even when it shows lengths of > 0 I still get blank spaces? my code: Option Compare Database Private Declare Function GetWindow Lib "user32" (ByVal hWnd As Long, ByVal wCmd As Long) As Long Private Declare Function GetWindowText Lib "user32" Alias...

Thanks darbid, I'm looking forward to trying it out. Do you also know if there is a way to handle the popup errors that come up when it can't find a record. These need to be handled by my automation program so it doesn't freeze up. thanks

It is actually the same box that comes up. You would press OK to enter your username & password

Yes the same pop-up does come up. Ignore the message that says the government is comming to get you for entering a wrong password. They would only pay attention if you repeatedly entered wrong ones (like in an automated cracking program). This url is also publically available from a simple...

Hi Darbid, I could give you the url, but you would need a login & pass to see the popup. Right after you enter the password a popup comes up saying that "this is for official government use, etc." then you have to press ok. Also it will come up with an error pop-up box if it can't find a...