Forum Discussion
Excel web query for password protected sites with pop up reporting
I am trying to perform a web query on a password protected site that requires criteria to be filled in to generate a report that is an additional pop up window. I need the data from the pop up window report. Anyone have any idea how to do this with the advanced web query in excel 2016?
1 Reply
- I just got a hold of the company hosting the site and asked for read only rights to the sql database servers and they granted it. problem solved
