ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó±Nºô­¶¤¤ªºªí®æª½±µ¦s¦¨Excel©Î¬OCSVÀÉ

[µo°Ý] ¦p¦ó±Nºô­¶¤¤ªºªí®æª½±µ¦s¦¨Excel©Î¬OCSVÀÉ

http://mopsov.tse.com.tw/nas/t06sa18/201101/A01_2330_201101.htm

·Q­n±N¤W­±³o­Óºô­¶¾ã­Ó¦s¦¨.xls(.csv)ÀÉ®×

·Q½Ð±Ð¦U¦ì °£¤F¦b¬¡­¶Ã¯¤¤¶×¤J¤§¥~,¦³¨S¦³¨ä¥L¤è¦¡¥i¥H¹F¦¨´Á±æªº¥Ø¼Ð©O?

ÁÂÁÂ

±Nºô­¶¥t¦s¦¨³æ¤@«Ê¸Ëºô­¶
¦A§â°ÆÀɦWhtm§ï¬°xls

TOP

³Ì°½Ãiªº¤èªk..
1. ctrl + A ¥þ¿ï«á ¶K¦b EXCEL ..
2.ºô­¶¤W¥kÁä ¶×¥X¦Üexcel
3.´N¹³ chin15¤j¤j©Ò´£¨ì ¾ã¥÷§ì¤U¨Ó¦A§ï°ÆÀɦW..

TOP

½Ð°Ý­Y¬O­n¦bVBA¤¤°õ¦æ

¦³Ãþ¦üªºµ{¦¡½X¥i¥H°Ñ¦Ò¶Ü

ÁÂÁÂ

TOP

¦^´_ 4# sasho
  1. Sub Ex()
  2.     With Workbooks.Open("http://mopsov.tse.com.tw/nas/t06sa18/201101/A01_2330_201101.htm")
  3.         .SaveAs "D:\TEST\A01_2330_201101.XLS"
  4.     End With
  5. End Sub
½Æ»s¥N½X

TOP

·PÁ¼ӤW¦U¦ì°ª¤âªº«ü±Ð,¤p§Ì¨ü±Ð¤F,ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD