Hello,
I need to retrieve some data using web query function. I got some tips from this great forum. I have created a lot of .iqy files that I can convert to xlsx by running them one by one. Now, it would be great if I can have a macro to automate the processes.
I have recorded a macro (using Excel 2013) for the first file.
I would be grateful if some one can make a macro to convert a folder of .iqy files to .xlsx with the worksheet and file names same as the .iqy files.
Thanks a lot in advance.
Nick
Bookmarks