Hi again,

I'm pretty sure I know what I want, and I'm sure I can do this a lot quicker than manually as now.

In column A will be a list of what should be the .iqy file names, while in column B are the urls for the relevant data. I want to use Query Wizard?/Macro? to go through the urls in column B to save the query, name each file according to column A and change the "Selection =" to 1 from EntirePage. Is this possible?

Thanks