Automatic OLE login prompt
 

Hello

I have an add-in in Excel that pulls in data from an accounts program
called Exchequer. When you call the function, you are prompted for an
OLE login (asking for a username/password).

Does anyone know whether it's possible to automate this OLE
authentication process as I would like to run these macros from a
scheduled task overnight.

regards

Simon