View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bitstreams Bitstreams is offline
external usenet poster
 
Posts: 1
Default 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