Share via

Accessing Excel QueryTables web url connection with singe signon

Gaurav Gupta 1 Reputation point
2022-04-28T18:03:20.747+00:00

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.
4,063 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.