Is there a way to reference data on an external website? I would like my spreadsheet to update frequently with the most current data provided by the external web host.
Thanks.
Is there a way to reference data on an external website? I would like my spreadsheet to update frequently with the most current data provided by the external web host.
Thanks.
Does this link help
http://office.microsoft.com/en-us/ex...450851033.aspx
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
The link helped and we are up and running! Thank you.
I have it set to update every time the workbook is opened, I know for a fact that the online data has not changed yet, so when I open the workbook up, I receive this message:
"The web query returned no data. To change the query, click ok, click the 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"
Am I receiving this message because the external data has remained the same as the previously imported data? I'm assuming when the online data is modified, I will no longer get this message. Are my assumptions correct?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks