Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSet shFirstQtr = Workbooks(1).Worksheets(1) Set qtQtrResults = shFirstQtr.QueryTables. Add ( _ Connection : = "TEXT;C:\My Documents\19980331.txt", Destination := shFirstQtr.Cells(1,1)) With qtQtrResults .TextFileParsingType = xlFixedWidth .TextFileFixedColumnWidths := Array(5,4) .TextFileColumnDataTypes := _ Array(xlTextFormat, xlSkipColumn, xlGeneralFormat) .Refresh End With
Set shFirstQtr = Workbooks(1).Worksheets(1) Set qtQtrResults = shFirstQtr.QueryTables. Add ( _ Connection : = "TEXT;C:\My Documents\19980331.txt", Destination := shFirstQtr.Cells(1,1)) With qtQtrResults .TextFileParsingType = xlFixedWidth .TextFileFixedColumnWidths := Array(5,4) .TextFileColumnDataTypes := _ Array(xlTextFormat, xlSkipColumn, xlGeneralFormat) .Refresh End With