Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable all "Refresh Data on File open"
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable all "Refresh Data on File open"
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, |
#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, |
Reply |
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 |