topic Passing the credentials through macro to sharepoint site to load data in QlikView

Passing the credentials through macro to sharepoint site to load data

qlikviewforum — Fri, 31 Aug 2012 07:54:26 GMT

Hi All

Is there is any way to open the secured sharepoint site and load the data into qlikview with the help of macro.

I have written somemacro code which opens the excel sheet and fetch the data from the sharepoint site. This works fine in my local machine where there is no need of authentication. But the samething when I try to do it in my development server I couldn't as it needs authentication to be passed to open the sharepoint site. So is there is anyway I can pass the credentials through macro as soon as the excel sheet is opened so that I fetch the data from sharepoint into excel.

For your information, I have managed to get the refreshed data from sharepoint to excel as something similar to what shown in the below post. But samething couldn't make it work in the development server as it needs authentication to open the sharepoint site.

community.qlik.com/message/253323#253323

Any help please?

Re: Passing the credentials through macro to sharepoint site to load data

qlikviewforum — Fri, 31 Aug 2012 12:09:34 GMT

Hi All,

I tried my level best but unfortunately couldn't able to succeed yet.

I read some where about QVSource. Is it possible to load the data from secured sharepoint site using that? Any help please?

Thanks,

qlikviewforum

Re: Passing the credentials through macro to sharepoint site to load data

chrisbrain — Wed, 30 Jan 2013 22:13:29 GMT

Apologies, I completely missed this post.

For anybody still looking the QVSource OData connector can help you access Sharepoint data - we have a page on our doc regarding this here.