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

[µo°Ý] ½Ð°Ý±N¥N¸¹±a¤J«á¡A¬°¦óµLªk¨Ï¥Îweb ¤U¸ü¸ê®Æ¡C

[µo°Ý] ½Ð°Ý±N¥N¸¹±a¤J«á¡A¬°¦óµLªk¨Ï¥Îweb ¤U¸ü¸ê®Æ¡C

½Ð°Ý¥H¤UªºªÑ¥«¥N¸¹ªí¡A±N¥N¸¹±a¤J«á¡A¬°¦óµLªk¨Ï¥Îweb ¤U¸ü¸ê®Æ¡C

http://www.emega.com.tw/js/StockTable.htm

¨Ò¦p¡A±N¦¹¥N¸¹ªí©ñ¤Jsheet2ªºa1¡A¨Ï¥Î®É±NSheet2_a1©ñ¶isheet1 ªºa1¡A±N¨ä±a¤Jwebaddress¤¤¡A
¦¹®É¡A¥i¬Ý¨ìsheet1_a1¦³¾A¤~sheet2_a1ªº¥N¸¹¡A¦ý«o¤°»òºô­¶¸ê®Æ¤]¨S¦³¶i¨ìexcel¤¤¡A
­Y±N­è¤~sheet2_a1ªº¥N¸¹§ï¥H¤âºVªº¤è¦¡­«¥´¤@¦¸¡A¦¹®É´N¥i¥H±N¸ê®Æ§ì¶i¨Ó¡C

WebAddress = "http://tw.stock.yahoo.com/q/q?s=" & [A1] & ""

½Ð°Ý¡A±N¥N¸¹±a¤J¡A¦³¤°»ò®æ¦¡­­©w¹À¡H

¦^´_ 1# cji3cj6xu6

§Ú§â­ì©lÀɶK¨ì°O¨Æ¥»¤W¡A¦A¶}¤@­ÓªÅ¥Õªºsheet¶K¦^¥h¡A¸Õ¸Õ¬Ý¦æ¤£¦æ

StockTable(­×.rar (15.39 KB)

TOP

Dear Jak¤j¡A

ÁÂÁ¡ã

¤£¥i¥H­C¡A¦p¥H¤Uºô§}ªþ¹Ï¡A
http://www.mojoimage.com/free-image-hosting-view-12.php?id=3979test1.gif
§Ú±N1101§ï¥H¤âºV¤è¦¡ºV¶i¸ê®Æ¡A«hºô¸ô¸ê®Æ¥i³Q±a¤J¡C
¦Ó¥Bµo²{¤âºVªº¸ê®ÆÀx¦s®æ¦¡»P­ì©l¤£¦P¡A¤£¾å±o¬O§_¬O¦¹¤@¦]¯À¡C

TOP

¦^´_ 3# cji3cj6xu6

À³¸Ó¬OÀx¦s®æ®æ¦¡°ÝÃD¡A¥i§_¤W¶Ç§Aªº¬d¸ßÀɮסA§Ú¸Õ¸Õ¬Ý

TOP

Dear Jak¤j¡A

ÁÂÁ¡ã
§Ú¤]ı±oÀ³¸Ó¬OÀx¦s®æ®æ¦¡°ÝÃD¡A«á¨Ó¦³§ä¨ì¥t¤@­Ófile¡A©Ò¥H´N³o¼Ë¤F¡C
¥u¬O·d¤£À´¬°¦ó·|»PÀx¦s®æ®æ¦¡¦³Ãö¡C

TOP

¦^´_ 5# cji3cj6xu6
§A»¡ ±N¦¹¥N¸¹ªí©ñ¤Jsheet2ªºa1¡A¨Ï¥Î®É±NSheet2_a1©ñ¶isheet1 ªºa1
°ÝÃD¥i¯à¬O¦bsheet2ªºa1 =1101  ???

¬Ý¬Ý¤U¦Cµ{¦¡½X¬O true ©Î false
  1. msgbox  len(sheet2.[a1])=4
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁÂg¤j´£¿ô¡A
len(sheet2.[a1])=4 ==> false
len(sheet2.[a1])=5 ==> True

¦ý½Ð°Ý¤@¤U¡A­n¦p¦ó§ï¦^¨Ó (¡×4)

TOP

§ä¨ì¤èªk¸Ñ¨M¤F¡A¥ý±Nsheet2.a1 *100 ¡AµM«á¦A°£¥H100´N¥i¸Ñ¨M¦¹¤@°ÝÃD¤F¡C

­ì©lÀɮ׸̦r¤¸¬°"1101" ¡Acopy ¹L¥h«áÅܬ° "1101?" ¡A¥H¸Ó¼gªk¡A¥i­×¥¿¦^¨Ó¬°1101

¥u¬O¬°¤°»ò¡H³o´N·d¤£À´¤F¡C

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD