·sª©ªÑ¥«¤½¶}¸ê°TÆ[´ú¯¸ªº¸ê®Æ§ì¨ìEXECL?
- ©«¤l
- 549
- ¥DÃD
- 152
- ºëµØ
- 0
- ¿n¤À
- 691
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-10
- ³Ì«áµn¿ý
- 2022-9-7
|
¦^´_ 19# bobomi
©p»¡ªºURL®Ø«üªº¬O¼gºô§}ªº¦a¤è¶Ü?
§Ú¤@¶}©l¬d¨ìªººô§}¥u¦³³o¼Ë=> http://www.lbma.org.uk/pricing-and-statistics
¬Ojoey0415¤j¤j´£¨Ñ«á±ªººô§},§Ú¤~ª¾¹D°Ñ¼Æ
«á¨Ó¶Wª©¤j¤j´£¨Ñ§Ú¾Ç²ß±o¨ì°Ñ¼Æªº¤èªk
¦]¦¹ÁÙ¦b¾Ç²ß¤¤= = |
|
PKKO
|
|
|
|
|
- ©«¤l
- 181
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-9
- ³Ì«áµn¿ý
- 2024-4-29
|
¥»©«³Ì«á¥Ñ bobomi ©ó 2015-7-17 14:21 ½s¿è
§A¥i¸Õ¸Õ¬Ý¡A¦³¨ÇªF¦è¨S¦³§A·Q±o¨º»ò²³æ³á
URL¤@¯ë³£¥u¦³ªì©l¶±
ftc693 µoªí©ó 2015-7-17 12:00
§Úª¾¹D¦³¨Ç¤£¦æ°Ú
¦ý§Ú¦^ªº¬O http://lbma.oblive.co.uk/table?metal=silver&year=2008&type=monthly ³oÓºô¶
¥Dn¬O post ºô¶ ( ºÝ¬Ý¹ï¤èn¤£nµ¹§A¤è«K )
¤£·Qµ¹§Aª½±µ¤U¸üªº, ºô§}«á±´N¤£·|ª½±µ©ñ°Ñ¼Æ, ¦ý¥i¥H§ä¥X¨Ó
ÁÙ¦³§ó¬½¤@ÂIªº
¬°¤F¤£Åý§A§ì
¸g±`§ïÅܺô§}°Ñ¼Æ |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 19
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-21
- ³Ì«áµn¿ý
- 2015-9-21
|
¦^´_ PKKO
IE ªº URL ®Ø¤£´N¦³¤F
bobomi µoªí©ó 2015-7-17 10:35
§A¥i¸Õ¸Õ¬Ý¡A¦³¨ÇªF¦è¨S¦³§A·Q±o¨º»ò²³æ³á
URL¤@¯ë³£¥u¦³ªì©l¶± |
|
|
|
|
|
|
- ©«¤l
- 181
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-9
- ³Ì«áµn¿ý
- 2024-4-29
|
¦^´_ 14# PKKO
IE ªº URL ®Ø¤£´N¦³¤F |
|
|
|
|
|
|
- ©«¤l
- 549
- ¥DÃD
- 152
- ºëµØ
- 0
- ¿n¤À
- 691
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-10
- ³Ì«áµn¿ý
- 2022-9-7
|
¦^´_ 15# GBKEE
«z~¤Ó·PÁ¶Wª©¤j¤j¤F¡A§Ú·|ºCºCÅé·|ªº!ÁÂÁÂ~ |
|
PKKO
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 14# PKKO
ºCºCªºÅé·|- Option Explicit
- Sub Ex_ºô¶¤¸¯À()
- Dim i As Integer, E As Object
- With CreateObject("InternetExplorer.Application")
- .Visible = True
- .Navigate "http://mops.twse.com.tw/mops/web/t164sb04"
-
- Do While .Busy Or .readyState <> 4: DoEvents: Loop
- Stop
- '¦b³oºô§}¿é¤J¬ÛÃö¸ê®Æ,¦AÄ~Äò°õ¦æ¤U±ªºµ{¦¡
-
- With .Document 'ºô¶ªº¤å¥ó
- '*** ³o¬qµ{¦¡½X¥i¬d¬Ý³oºô¶ªº¤¸¯À¤º®e
- On Error Resume Next
- For Each E In .all
- i = i + 1
- Cells(i, "a") = E.tagname '±±¨î¶µ¼Ð°Oªº¦WºÙ
- Cells(i, "b") = E.ID '±±¨î¶µ¼Ð°OªºID (±©¤@ªº)
- Cells(i, "c") = E.Name '±±¨î¶µ¼Ð°Oªº©R¦W
- Cells(i, "d") = E.Value '±±¨î¶µ¼Ð°OªºÈ
- Cells(i, "e") = E.innertext '±±¨î¶µ¼Ð°Oªº¤å¦r
- Cells(i, "f") = E.Type '±±¨î¶µ¼Ð°OªºÃþ«¬
- Cells(i, "g") = E.href '±±¨î¶µ¼Ð°Oªººô§}
- Next
- '****************************************
- End With
- ' .Quit 'Ãö³¬ºô¶
- End With
- '°õ¦æ«á¨ì¤u§@ªí¤W,¬d¬Ý¦b³oºô§}¿é¤J¬ÛÃö¸ê®Æªº±±¨î¶µªºÄÝ©Ê
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 549
- ¥DÃD
- 152
- ºëµØ
- 0
- ¿n¤À
- 691
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-10
- ³Ì«áµn¿ý
- 2022-9-7
|
¦^´_ 13# joey0415
joey0415¤j¤j±z¦n,±zµ¹§Ú²Ó³¡ºô§}¤§«á,§Ú´N·|§ï¤F
¥i¬O±zªº²Ó³¡ºô§}¬O¦p¦ó±oª¾ªº?
¨Ò¦p:http://lbma.oblive.co.uk/table => ±q³o¸Ì¶}©l(?metal=silver&year=2008&type=monthly)
¬õ¦â¦r¦êªº¦a¤è±z«ç»òª¾¹D¦³³o¬qºô§}?
§Ú²q¤]²q¤£¨ìªü~
ÁÙ¬On¬Ýºô¶ªºÀ˵øµ{¦¡¶Ü? |
|
PKKO
|
|
|
|
|
- ©«¤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
|
¦^´_ GBKEE
¶Wª©¤j¤j°Ý¤@¤U®@,±z¬O¦p¦ó±oª¾ºô§}«á±ªº¿ï¶µªº?¹ê¦b¤Ó±j¤j¤F...
http://mops.twse. ...
PKKO µoªí©ó 2015-7-16 21:18
http://lbma.oblive.co.uk/table?metal=silver&year=2008&type=monthly
http://lbma.oblive.co.uk/table?metal=gold&year=2013&type=daily
¦Û¤v½m²ß§ï§ï¬Ý |
|
|
|
|
|
|
- ©«¤l
- 549
- ¥DÃD
- 152
- ºëµØ
- 0
- ¿n¤À
- 691
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-10
- ³Ì«áµn¿ý
- 2022-9-7
|
¦^´_ 11# GBKEE
¶Wª©¤j¤j°Ý¤@¤U®@,±z¬O¦p¦ó±oª¾ºô§}«á±ªº¿ï¶µªº?¹ê¦b¤Ó±j¤j¤F...
http://mops.twse.com.tw/mops/web/t164sb04 =>«á±¦³season ¡B year ¦p¦ó±oª¾ªº?
¨Ò¦p:http://lbma.oblive.co.uk/table
³o¬OÛ´°¶Àª÷ªº¤½§i»ù®æºô¯¸
§Ú¥u·|§ì104¦~ªº,¦]¬°§Ú¤£¾å±o«á±n¦p¦ó¿é¤Jyear ªºÅܼƨú±o¤£¦P¦~«×ªº¸ê®Æ
½Ð°ÝÃþ¦ü³oºØºô¶¸Ó¦p¦ó§ä¥X«á±ªºÅܼƿé¤J¤è¦¡
¥H¤Î³oÓºô§}ªºÅܼÆn¦p¦ó¿é¤J? |
|
PKKO
|
|
|
|
|