Sub 汇入() With ActiveSheet.QueryTables.Add(Connection:=_ '<=修改成可以手动选择txt档案位置 "TEXT;D: \TXT\原始TXT资料\01.txt", Destination:= _ Range("A2")) .Name= "01_2" .FieldNames= True .RowNumbers= False .FillAdjacentFormulas= False .PreserveFormatting= True .RefreshOnFileOpen= False .RefreshStyle= xlInsertDeleteCells .SavePassword= False .SaveData= True .AdjustColumnWidth= True .RefreshPeriod= 0 .TextFilePromptOnRefresh= False .TextFilePlatform= 950 .TextFileStartRow= 1 .TextFileParseType= xlFixedWidth .TextFileTextQualifier= xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter= False .TextFileTabDelimiter= True .TextFileSemicolonDelimiter= False .TextFileCommaDelimiter= False .TextFileSpaceDelimiter= False .TextFileColumnDataTypes= Array(2, 9, 2, 1, 1) .TextFileFixedColumnWidths = Array(6, 3, 10, 8) .TextFileTrailingMinusNumbers= True .RefreshBackgroundQuery:=False End With Range("A2:C22").Select <=请帮我改成不论txt档案数据多寡,框线及字体与背景色,自动依照各txt资料笔数完成 Range("C22").Activate With Selection.Font .Name= "Verdana" .Size= 9 .Strikethrough= False .Superscript= False .Subscript= False .OutlineFont= False .Shadow= False .Underline= xlUnderlineStyleNone .ColorIndex= xlAutomatic End With Selection.Borders(xlDiagonalDown).LineStyle= xlNone Selection.Borders(xlDiagonalUp).LineStyle= xlNone With Selection.Borders(xlEdgeLeft) .LineStyle= xlContinuous .Weight= xlThin .ColorIndex= xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight= xlThin .ColorIndex= xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle= xlContinuous .Weight= xlThin .ColorIndex= xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle= xlContinuous .Weight= xlThin .ColorIndex= xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle= xlContinuous .Weight= xlHairline .ColorIndex= xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle= xlContinuous .Weight= xlHairline .ColorIndex= xlAutomatic End With With Selection.Interior .ColorIndex= 35 .Pattern= xlSolid End With End Sub
在此谢谢各位先进帮忙
|