Turn off MS Query auto refresh?

[dylanemcgregor]

I have an Excel 2003 workbook that downloads info from our db using MS Query. This workbook is set to refresh when the workbook is opened. Once a month I'd like to save a snapshot of the current data using a batch file and macro. But if I do a Save As of the current workbook, I believe the auto refresh on open will still apply to the new workbook? Can I turn this functionality off using a macro?

[romperstomper]

You can just right-click and change it in the Data Range properties.

[dylanemcgregor]

Thanks. I just did that using the macro recorder and got a bunch of code:

Please Login or Register  to view this content.

I'm guessing the .refreshOnFileOpen = False is the only part I care about right?

[romperstomper]

Correct.

[dylanemcgregor]

Awesome! Worked like a charm. Thanks again.