Accessing Excel QueryTables web url connection with singe signon

Gaurav Gupta 1 Reputation point

I am trying to fill my excel sheet with Excelsheet.QueryTables.Add Method and passing a weburl in connection.

That web url is under Single Sign on. When trying to fill the querytable with refresh method it does not return any data. Can anybody suggest how to access or pass singlesignon credentials to querytables.add method so that weburl got authenticated and data comes out

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,435 questions
{count} votes