I have a macro in Excel that opens an OLE program called BI Query which
interegates one of our databses and return the results to an Excel worksheet.
Everything works fine but their is one niggle, when BI Query connects to the
database a password box appears and the whole process stop until the password
is entered. At the moment we enter the password manually. We want to make
this a totally independent process. Is there any why to get the password into
the box either through Excel or another form filling program?
For example if we schedule the macro to run at 6pm and it needs the password
at 6:05pm is there a program that anyone knows of that we could have run at
6:06pm and enter a text string into the password box which has the focus.
I've tried to do this from Excel but have had no luck, and theres nothing in
BI Query's library to allow me to do this.

Any help is greatly appreciated.
--

_______________________
Naz,
London