Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i am extracting an excel from share point.
when i use the URL on browser it asks me the user name and password and opens the file.
but if i use the same URL in QV it displays you are nor authorized o view this.
why so?
can anyone suggest me how to extract from sharepoint
Hi Subin
What I have done is,
1. Written a batch file to open qv.exe and reload the required qvw.
2. In the qvw I have triggered a macro to open the excel and fetch the data from site then close it.
3. What I doing is, I am manually running the task to check whether it is working or not.
4. As expected it qv.exe got lauched and opened the qvw and the trigger started as expected. As the trigger started it opened the excel automatically and then closed the excel sheet.
But the problem here is still the qvw application is open. May I know what do be done here.
If not please let me know if you have anyother alternative.
Thanks,
qlikviewforum
Ok.. What is the value given to wait. function in macro????
Rgds,
Subin
00:00:15
Don't think this could be the reason. As I don't think reload is also happening here!
Can you send the batch file code again. So that I can copy paste anc check.
Here is the batch file I am using
"C:\Program Files\QlikView\qv.exe" /r "D:\xyz\xyz\QVD Creators.qvw"
I am doing the samething in my batch file as well. Not sure what is missing though?
try "taskkill /f /im qv.exe" for killing the appliocation then
Thanks Subin
I have already done that but it didn't work out!
Hi Subin
Any help? Forget about closing qvw. First I would like to fetch data from sharepoint which needs authentication. If this is done then I can work on other things.
As discussed may I know what are other process of doing the same? I am also trying but unfortunately couldn't find any solution.
Thanks,
qlikviewforum
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 the same? Any help please?
Thanks,
qlikviewforum