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
|