Automatic login in Sharepoint 365

[#1]

Hi everyone!

I am trying to retrieve data from a Sharepoint 365 list into QlikView, and Sharepoint ask me for a login before let me get the data. So in this case, I have to select "Open URL" from the file menu, put the Sharepoint URL, log me in the site (using the embedded browser in the QlikView Environment), and then yes, I can get the data.

The fact is that I have to schedule this reload to be executed automatically, so Qlikview should make the login process by itself and then load the data.

I was trying with a vbScript that perform the process automatically, this process run and logged in to Sharepoint successfully, but this login is not recognized by Qlikvew reload process, only works if I make the login process manually through "Open URL" option.

I tried using:

     Set objIE = CreateObject("InternetExplorer.Application.1")

     Call objIE.Navigate URL

Does anyone have any idea to do this? Does anyone know if there is a way to execute the exact "Open URL" option with a macro?

Thanks and let me know if you need any additional information.

Regards.

[Anil_Babu_Samineni]

Hello Guzman,

When you use Reload the script automatically by using macro. This will fetch data automatically

Sub ReloadDoc

   ActiveDocument.Reload

   ActiveDocument.Save

End sub

[#3]

Hello Anil, thanks for your answer.

Yes, I tried with that, but then of to make the login process and wait some seconds to be sure that the user is really logged in, the reload fails because it continues not recognizing the login.

Do you have any other idea to try?

Thanks again.

Regards.

[aarkay29]

Any luck??