Hi
I like to export data from the link below (choosing 5 years) to excel
TASE Site - Historical Prices
The page allow to export data to excel by clicking " Export Table Data " , " excel 2003" , "save as " …..
Doing that also open a window with This URL
http://www.tase.co.il/_layouts/Tase...ory&enumTblType=GridHistorydaily&ExportType=1
I tried to import to excel in three ways
1. From excel " data" " Existing Connections " and IQY that contain the first URL .
2. From excel " data" " Existing Connections " and IQY that contain the second URL .
3. From excel " data " " from web " and the URL (Again using the two URL (
And all I get is "No data to show"
It seem that export data from this page dependent on the two URL .
Is there a way to export data from this site using VBA or IQY ?
tnx
choni
I like to export data from the link below (choosing 5 years) to excel
TASE Site - Historical Prices
The page allow to export data to excel by clicking " Export Table Data " , " excel 2003" , "save as " …..
Doing that also open a window with This URL
http://www.tase.co.il/_layouts/Tase...ory&enumTblType=GridHistorydaily&ExportType=1
I tried to import to excel in three ways
1. From excel " data" " Existing Connections " and IQY that contain the first URL .
2. From excel " data" " Existing Connections " and IQY that contain the second URL .
3. From excel " data " " from web " and the URL (Again using the two URL (
And all I get is "No data to show"
It seem that export data from this page dependent on the two URL .
Is there a way to export data from this site using VBA or IQY ?
tnx
choni