Sub 儲存ID()
'
' 儲存ID 巨集
'
' 快速鍵: Ctrl+q
'
ActiveSheet.Range("$A$1I$613").AutoFilter Field:=9, Criteria1:="0"
Rows("50:50").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
ActiveSheet.Range("$A$1I$612").AutoFilter Field:=9
Range("D38").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("儲存ID").Select
Dim Rng As Object
Dim strData
For Each Rng In Range("這邊該如何設定")
If Rng.Column = 1 Then
strData = strData & Rng & vbTab
ElseIf Rng.Column = 2 Then
strData = strData & Rng & vbCr
End If
Next
Debug.Print strData
Dim fsT As Object
Set fsT = CreateObject("ADODB.Stream")
fsT.Type = 2
fsT.Charset = "UTF-8"
fsT.Open
fsT.WriteText strData
fsT.SaveToFile "D:\ID.txt", 2
End Su