DARKSPARTAN

Hi everyone, sorry if this is a dumb question, but I am completely new to this type of process. I am in need to use excel 2000 vba i believe its called, to upload some information I have in excel, into internet explorer forms.

I have attached a jpg image to show the four forms.

Basically what I am trying to do, is to have:

Excel load webpage, input desired id (from an excel cell) and click login
Click select
Input data from lets say excel column A2
And input data for the date (B2,C2)
Click add
- Repeat the three above steps for as much data is in column A/B/C
Click Search
Click Select All
Click Print Overnight

I'm sure it is a lot of work to write code for something like this, but any help would be greatly appreciated.

Paulo Buchsbaum

Send keys inside Excel (using SendSeys) is not very trustable.
Other low level operations depends on Windows API.
So it's best to use a third application like the freeware AutoIt to do that. AutoIt can interacts with Excel (COM object) and easily load the web page and other stuff (http://www.autoitscript.com)