- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 4# kaui700 - Sub ³Õ«È¨Ó()
- X = InputBox("½Ð¿é¤J³Õ«È¨Óºô§}¡G¡]³t«×¸û§Ö¡^", "´£¥Ü")
- ' Application.ScreenUpdating = False
- ' Cells.ClearContents
- Sheets("temp").Activate
- Cells.Delete
-
- surl = "URL;" & X
- With ActiveSheet.QueryTables.Add(Connection:=surl, Destination:=Range("$A$1"))
- .RefreshPeriod = 0
- .WebSelectionType = xlEntirePage
- .WebFormatting = xlWebFormattingNone
- .Refresh BackgroundQuery:=False
- .Delete
- End With
-
- finalrow = Cells(Rows.Count, 1).End(xlUp).Row
- fr = Sheets("¾ã²z").Cells(Rows.Count, 1).End(xlUp).Row + 1
- ' Stop
- ' s = 1
- For i = 1 To finalrow
- If Cells(i, 1) = "°Ó«~¤¶²Ð" Then
- Sheets("¾ã²z").Cells(fr, 1) = Cells(i + 1, 1)
- End If
-
- If Left(Cells(i, 1), 3) = "§@ªÌ¡G" Then
- Sheets("¾ã²z").Cells(fr, 2) = Trim(Replace(Replace(Cells(i, 1), "§@ªÌ¡G", ""), "·s¥\¯à¤¶²Ð", ""))
- End If
-
- If Left(Cells(i, 1), 3) = "øªÌ¡G" Then
- Sheets("¾ã²z").Cells(fr, 3) = Trim(Replace(Replace(Cells(i, 1), "øªÌ¡G", ""), "·s¥\¯à¤¶²Ð", ""))
- End If
-
- If Left(Cells(i, 1), 4) = "¥Xª©ªÀ¡G" Then
- Sheets("¾ã²z").Cells(fr, 4) = Trim(Replace(Replace(Cells(i, 1), "¥Xª©ªÀ¡G", ""), "·s¥\¯à¤¶²Ð", ""))
- End If
-
- If Left(Cells(i, 1), 5) = "¥Xª©¤é´Á¡G" Then
- Sheets("¾ã²z").Cells(fr, 5) = Trim(Replace(Replace(Cells(i, 1), "¥Xª©¤é´Á¡G", ""), "·s¥\¯à¤¶²Ð", ""))
- End If
- Next
-
-
- Sheets("temp").Cells.Delete
- Sheets("¾ã²z").Activate
- End Sub
½Æ»s¥N½X ¸ê®Æªí¦WºÙ¡Gtemp »P ¾ã²z ¤~¯à°õ¦æ |
|