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...

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...

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...

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...

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...

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...

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...

Hi everyone, I wrote an Access 2003 function that takes in either a table or select query name. If you give the function a file path it will save it to disk. If you leave the file path out it opens it up in a new Excel application without saving it. You can also set booleans for visiblity and...

The end user opens up an Excel sheet from a website and then presses a button on a form to bring the data into my Access 2003 table. Then when they press another button a query is run and output to another Excel sheet. I want to save the user from having to save the workbook before my code will...