- ©«¤l
- 32
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 67
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2020-12-30
|
¦^´_ 5# chen_cook
ÁÂÁ¤j¤jªº¦^À³, TRY ¤j¤j¤½§iªºcode ¦³¤£©ú¥Õ³B ½Ð±Ð
1. y$ = 101: m$ = 5 <---¥i×¥¿§ì¨ú¦~¤ë <==> ק令 Syear = Year(Date) - 1911: Smon = Month(Date) - 1
"URL;http://mops.twse.com.tw/t21/" & myWeb(i) & "/t21sc03_" & Syear & "_" & Smon & ".html", Destination:=Cells(1, 1))
°õ¦æ µ{¦¡«á·|¦b¤U¦æ¤§³Bµo¥Í¿ù»~¡A(°õ¦æ¶¥¬q¿ù»~,°}¦C¶W¥X½d³ò)
Range("A1:J" & Ed).Copy Worksheets("¤ëÀ禬").Cells(x + 2, 1)
2, n¦p¦ó¤@¦¸¨ú±o¦h¤ë¥÷ªº¤ëÀ禬¸ê®Æ |
|