Automating the running of several web queries (in separate .iqy files) that change each day and saving the corresponding Excel file
Posted on 2009-04-13
Hello Experts, Ive found many related questions, but none seems to fit exactly my need and as I am completely new to coding and VB its hard for me to think of how to adapt the answers. So please bear with me&
Each day a large number of stocks are selected (different stocks get selected each day), and (using a software called Stata) I have managed to automate the creation of a corresponding number of .iqy files, named stockticker.iqy. For each stock, I need to run the relevant web query in Excel 2003 and save the resulting Excel file. How can I automate this?
Thanks a lot in advance for any help and direction!