| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable all "Refresh Data on File open"
Dear Ardus,
That works great!! Thank you... "Ardus Petus" wrote: Sub ClearAllQueries() Dim ws As Worksheet Dim qt As QueryTable For Each ws In ActiveWorkbook.Worksheets For Each qt In ws.QueryTables qt.Delete Next qt Next ws End Sub HTH -- AP "SupperDuck" a écrit dans le message de news: ... Dear all, I have an excel workbook with 3 sheets, And in sheet there are more than 5 queries. When my start macro, it saves the workbook in a new file name. And in this position, I want to disable all queris. The queries can be deleted, the "refresh data on file open" can be diabled... Whatever the solution is, I don't want to see any info box about enabling or disabling the queries when i open the new file. Can you please help me? Kindest regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop the popup "Enable/Disable Automatic Refresh"? | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| Automatic "data refresh" when XLS file is opened? | Excel Discussion (Misc queries) | |||
| Suppress "Disable/Enable Macros" and Query Refresh dialog on open | Excel Programming | |||
Threaded Mode
