¥Î°j°é§ì¸ê®Æ¶V¶]¶VºC¡A¸Ó¦p¦óÄÀ©ñ°O¾ÐÅé?
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 4# sasho
§Ú·|¥ý§â©I¥s§ï¬°- t = timer
- Àx¦sCSV DownloadDate,id
- debug.print timer-t
½Æ»s¥N½X ¥ýÆ[¹î½T»{ ®É¶¡Åܪøªº¦a¤è ¬O¦b ¦sÀɳo³¡¤À¡C |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 7# GBKEE
Hi ª©¤j¡A
§Ú¤£¾å±o¬O¤£¬OEXCELª©¥»®t²§¡A
§Ú¦bExcel2010¤¤¡A§R°£QueryTableª«¥ó´N·|ª½±µ§R°£Names¤¤ªº¶µ¥Ø¤F¡C |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-6-17 14:09 ½s¿è
¦^´_ 9# GBKEE
QueryTables.Delete ¥u·|§R°£³s½u©M©w¸qªº¦WºÙ¡A¤£·|§R°£¨ú±oªº¸ê®Æ
¦Ó¼Ó¥D¥Î°j°é°õ¦æ¦hµ§®É¸ê®Æ·|¤@ª½©¹¥k²Ö¿n¼W¥[
³o¤]³\¥i¥H§ïRefreshStyle¬°xlOverwriteCells¨Ó¨¾¤î(¹w³]¬OxlInsertDeleteCells)
¹³³o¼Ë- Sub Ex()
- Dim i As Integer, Rng As Range
- With ActiveSheet
- For i = 3 To 7 Step 2
- With .QueryTables.Add("URL;http://forum.twbts.com/thread-635-1-1.html", .Cells(1, 1))
- .WebSelectionType = xlSpecifiedTables
- .WebFormatting = xlWebFormattingNone
- .WebTables = i & ""
- .WebPreFormattedTextToColumns = True
- .WebConsecutiveDelimitersAsOne = True
- .WebSingleBlockTextImport = False
- .WebDisableDateRecognition = False
- .WebDisableRedirections = False
-
- .RefreshStyle = xlOverwriteCells
- .Refresh BackgroundQuery:=False
- Wb_Save .ResultRange, i
-
- .Delete
- End With
- Next
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|