ferverx
11-24-2005, 08:29 AM
Hello!
How :think: to make the Import external data (from web) to download and save files by adress: http://market.rfb.lv/index.php?pg=details&instrument=LV0000100626&list=4&popup=trades&downloadcsv=1&date=2005-11-22, so that excel tries to use as "date=2005-11-22" all dates from 01.11.2005 till today and saves those txt files on disk giving those files names in date format (example "yyyymmdd")?
I have added the example of iqy file - basically I want a macro that will
1)change the "date=2005-11-22" in this file (till today).
2)if there is data - downloads data into Excel (putting in first column the date); if there is no data - tries other dates;
3)saves file by name "yyyymmdd.txt";
4)tries other dates (go to step "1)" ).
How :think: to make the Import external data (from web) to download and save files by adress: http://market.rfb.lv/index.php?pg=details&instrument=LV0000100626&list=4&popup=trades&downloadcsv=1&date=2005-11-22, so that excel tries to use as "date=2005-11-22" all dates from 01.11.2005 till today and saves those txt files on disk giving those files names in date format (example "yyyymmdd")?
I have added the example of iqy file - basically I want a macro that will
1)change the "date=2005-11-22" in this file (till today).
2)if there is data - downloads data into Excel (putting in first column the date); if there is no data - tries other dates;
3)saves file by name "yyyymmdd.txt";
4)tries other dates (go to step "1)" ).