How to convert web query file(.iqy) to excel speadsheet(.xlsx)

[RaviMalhotra]

Hi All,  

Request if anyone please help. I have one web query file(.iqy)  that is being downloaded and saved from sharepoint site. Now i am converting this file to excel spread sheet using code stage (visual basic).
When it finds a command to open web query file,  it asks for windows security password as that web query is fetching data from sharepoint site. 
Can anyone please suggest how could i set windows security password in code stage or is there any way to achieve this. 
I am able to do if i change my internet security setting for user authentication as automatically login with current user and password but in actual i am not allowed to change the default settings as on server,  settings are asking for prompt username and password

------------------------------
Ravi Malhotra
------------------------------

[HarshitRawat]

You should be able to read that .iqy file in the same way as you read the .xlsx files ( Create Instance , Open workbook etc)

I did it some weeks back and and it works file. Let me know if you face any issue

------------------------------
Harshit Rawat
------------------------------

[RaviMalhotra]

Hello Harshit,

Appreciated your response on this.
Actually i tried that before so when the flow goes on to Open Workbook it haults there onlyas it is asking for User name and password because the Web query is fetching data from Sharepoint Site and we have User Authentication security Settings in Internet Explorer that it will ask for Pop up of User name and Password for Internet and Intranet.

Also i f manually give that credential details, it easily converts that but i am wondering that how can i pass my control to that POP up window asn my flow Stucks on Open Workbook activity only and not progressing further

------------------------------
Ravi Malhotra
------------------------------