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 |
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 |
All times are GMT +1. The time now is 09:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com