Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to open a file with http authentication with a macro (conveniently)

I have written a macro to open an xml file which is protected by http authentication in calc -

dim sURL as string 
dim oArgs(0) As New
dim oDocStatus as object
dim oihandler 
oihandler = createUnoService("")
sURL = ""
oArgs(0).Name = "InteractionHandler"
oArgs(0).Value = oihandler
oDocStatus = StarDesktop.loadComponentFromURL(sURL, "_default", 0, oArgs)

This works fine except that each time I run it -

  1. I have to key in my user name / password in an Authentication Required window
  2. I have to click OK on the subsequent "Text Import" window.

How could I improve this macro to avoid repetitively doing these actions? (removing http authentication from the xml page is not possible)