| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Skipping Import Text File dialog in a Macro
I tried the following but the dialog always appears and forces me to click
the Import button. Sheets("Sheet1").Select Application.DisplayAlerts = False With Selection.QueryTable .Connection = _ "TEXT;C:\Edrive\standalone\Lineup\18ScorecardRoste r.txt" .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlFixedWidth .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(2, 2) .TextFileFixedColumnWidths = Array(4) .Refresh BackgroundQuery:=False End With Sheets("Scorecard-v").Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to import text file into one column | Excel Discussion (Misc queries) | |||
| import from text file | Excel Discussion (Misc queries) | |||
| Macro to Import Text | Excel Discussion (Misc queries) | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| Import text file to a SINGLE ROW? | Excel Discussion (Misc queries) | |||
Threaded Mode
