Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Import Error
I written an Excel application that works fine on Excel2002 but error
breaks on .TextFilePlatform=437 when a user runs it on Excel2000. For all the marbles, what is 437? and can I safely comment out the statement? Is this a known compatiblitiy problem ? Thanks in advance. With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;" & ScratchFile _ , Destination:=Range("A1")) .Name = T6Infile .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 437 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1) .TextFileTrailingMinusNumbers = True .TextFileSemicolonDelimiter = True .TextFileCommaDelimiter = False .Refresh BackgroundQuery:=False End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem with Access Query import into Excel 2000 | New Users to Excel | |||
Can I import xml data into MS Office 2000 Excel? | Excel Discussion (Misc queries) | |||
text import into excel 2000 | Excel Discussion (Misc queries) | |||
Can u Import Macintosh 2.1 Excel file into Windows Office 2000? | Excel Discussion (Misc queries) | |||
Excel 2000 Date Import Problem | Excel Programming |