Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Refresh
Hello All,
I have had to modify a spreadsheet written by a ex-coworker and here is my problem. When I open up the workbook, it asks if I want to enable or disable automatic refresh. For the style of spreadsheets my company uses, I would like this option to NEVER come up and for the automatic refresh to be disabled. I have tried clearing on the query tables, saving, closing and reopening and it still asked me to refresh or not. I have tried different settings in the options menu in excel and still nothing. Here is a copy of my general import code. The same code is used to import numerous files. Is there something here I could change? Or is there something I'm completely missing? 'import *.tab file SourceFile = "TEXT;" & LoadsResultsPath & ResultsRootName & ".tab" Dest = 1 + 14 * counter Sheets(TabInputPage).Select With ActiveSheet.QueryTables.Add(Connection:=SourceFile , Destination:=Cells(2, Dest)) .Name = ".tab" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = True .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = False .AdjustColumnWidth = False .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = True .TextFileTabDelimiter = False .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = True .TextFileColumnDataTypes = Array(1, 1, 1, 1) .Refresh BackgroundQuery:=False End With Thanks for any help you may be able to give me. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Refresh
On 8 Mar 2007 12:29:27 -0800, "JohnJack"
wrote: Hello All, I have had to modify a spreadsheet written by a ex-coworker and here is my problem. See my response to your future post. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Web Query fail to Refresh All but individual refresh is ok | Excel Programming |