Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikviewforum
Contributor II

Passing the credentials through macro to sharepoint site to load data

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?

2 Replies
qlikviewforum
Contributor II

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

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

chrisbrain
Valued Contributor

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

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.

Community Browser