Adding a new query to an Excel workbook using ShufflePoint's IQY Web Query capability is pretty fast and easy. But faster and easier is always better. I decided to create a short macro which makes all of the settings that we recommend in our how-to on Excel. It eliminates a dozen mouse clicks and the chance to make mistakes.

Click here to download a zip with the macro.

Click here for instructions on using the macro and on saving a template file.