Hello,
I have recently tried to use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query".
I have been successful in using this feature in the past with other websites such as stocks, or baseball statistics, but this seems to not work. It is a list of subcontractors that changes on a daily basis. Having this list automatically update/populate into excel would save our company a substantial amount of time.
The page I was trying to retrieve is this: http://app.isqft.com/#/directory/vendorDirectory.
Any ideas what causes the error and how to fix it? Is there a VBA script that may work for this? I have searched for days, and have found similar problems, but nothing that has helped fix my issue. If anyone would please let me know, I would very much appreciate the help. Thanks again.
Regards,
Riley (excel 2007)
I have recently tried to use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query".
I have been successful in using this feature in the past with other websites such as stocks, or baseball statistics, but this seems to not work. It is a list of subcontractors that changes on a daily basis. Having this list automatically update/populate into excel would save our company a substantial amount of time.
The page I was trying to retrieve is this: http://app.isqft.com/#/directory/vendorDirectory.
Any ideas what causes the error and how to fix it? Is there a VBA script that may work for this? I have searched for days, and have found similar problems, but nothing that has helped fix my issue. If anyone would please let me know, I would very much appreciate the help. Thanks again.
Regards,
Riley (excel 2007)
