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

[­ì³Ð] ¦Û°Ê¶}±ÒªºÀɤ¤Àɧޥ©¶i¶¥À³¥Î

[­ì³Ð] ¦Û°Ê¶}±ÒªºÀɤ¤Àɧޥ©¶i¶¥À³¥Î

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-11-26 21:26 ½s¿è

Àɤ¤Àɧޥ©°£¤F À³¥Î¦b ¯f¬r¸üÅé¥~[«Ø议] 谁¦b·d¡@RESULTS.XLS¡@这个
§Ú­ÌÁÙ¯à±N¥L¹B¥Î¦b¨º¤@Ãä¡A§Q¥Î[­ì³Ð] ¥\¯àªí½s¿è¾¹³sµ²¥¨¶°¥Ü¨Òªº¥\¯à¡A§@¦¨ÀÉ®×¥i¹F¨ì¥H¤U®ÄªG:


     1.Åý¤H§¹¥þ¤£ª¾¹D"¤u¨ã¦C"«ç»ò»s§@ªº¡A³s°ª¤â³£¬O
     2.¥ý±N­n¦¨¬°ª«¥óÀɮתºVBP"±M®×µLªkÀ˵ø"¡A¦A±Nª«¥óÀÉ®×´¡¤J¥]¸Ë¦bÀɮפ¤¡A
        Åý¤HµLªk¨Ï¥ÎVBA¥[¸ÑÂê¾¹¥h¸Ñ°£¸Ì­±ªº³o­Óª«¥óÀɮתºVBP"±M®×µLªkÀ˵ø"


¥i¥Hµo²{¥~ÀÉ"¥u¥]§t¥\¯àªí½s¿è¾¹¤u¨ã¦C"¨S¦³¥ô¦óµ{¦¡¡A¤ºÀÉ¥]§tµ{¦¡
Àɤ¤Àɪº¯S¦â¬O¶}¥~ÀÉ«á¡A¤ºÀÉ·|¦Û°Ê¶}±Ò¥B¨â­ÓÀɳ£¥i¥H±Ò¥Î¥¨¶°
¥~Àɪº¤u¨ã¦C¥u¥Î©w¸q´N¥i¥H©I¥s¤ºÀɪºµ{¦¡¡A§¹¥þ¤£·ÓµP¸Ì¥XµPªº¤è¦¡Åý¤H¶Ì²´

¦¹©«¦b¦¹­ºµo¡A§Oªººô¯¸¬O¨S¦³ªº¡A¥u¬O¦nª±¡A¦ýµ´¹ï¬O°ª¤â³£·Q¤£¨ì»P©ç®×±Ðµ´ªº©_¯S§Þ¥©¡A¦¹ªk¥i¥HÅܦVªº«OÅ@"ÀÉ®×»PVB±M®×"¡A
¤£¹L¯}¸Ñ¤]²³æ­Ë¬O.¨þ¨þ
½d¨Ò: ¥Î»¡ªº¡A¬Ý¤£À´¡A¬Ý½d¨Ò´N·|ª¾¹D¡AÀɮ׳£µ¹¤F¡A¤£¬O¥u¦³¹Ï¤ù©Î¤å¦r¡A¤£¬Oµê®Ì¤@©ÛÄF¤H¡A¤j®a¥i¥H¬Ý¬Ý¡A²©ö½d¨Ò¦p¤U
¬d¸ßExcelª©¥».rar (11.46 KB)

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-12-25 11:03 ½s¿è

¥¼¨Ï¥ÎVB6ª¬ªp¤U.ExcelºÉ©Ò¯à³Ì«á¯à¹F¨ìvba«OÅ@®ÄªG
¤j·§´N³o¼Ë¤F(¥Ø«e¨S¤ñ¥¦§ó¦nªº)


¦bvbe§â½s½XÅÜ¥~¬P¤å¨Ó«OÅ@µ{¦¡?.ÁÙ­nÅܦ^¨Ó¤£¦n¥Î.
³Ì«áÁÙ¬O©w®×.´N®³³o­Ó·í¥¼¨Ï¥ÎVB6ª¬ªp¤Uvba«OÅ@²×©«

¤£­n¥H¬°¥þ³¡Âàvb6«Ê¸Ë´N³Ì¦n.¥¦¨S¸ê®Æ®w.«Ü¦h»Ý­n¸ê®Æ®w/»Ý­n¦s¨t²Î¸ê°Tªº¸ê®Æ
³o®É´N¨S¦³³æ¯Â¨Ï¥ÎexcelÀÉ»s§@¨º»òªº¤è«K.

¨ºvb6«Ê¸Ë¨ì©³¦n¤£¦n?§Úıªº¦³§Q¦³¹ú¡A¹³¼W¯q¡B¨ç¼Æ¡BÃþ ´N«Ü¾A¦X­·«Ê¸Ë¦¨DLL
¦ýÁÙ¬O¦³«Ü¦h¤£¾A¥Î¡A¤×¨ä¬O¤jµ{¦¡¡A³Ì«áÁÙ¬Oı±o¬Û¤¬¹B¥Î¬O¤£¿ùªº¿ï¾Ü¡A
±µ¤U»Ý­n¤¶²Ðvba¦p¦ó«Ê¸Ë¦¨dll or exeÀɤ~¯à¸ÑÄÀ¡A¦p¦ó¥hÀ³¥Î³o¤@³¡¥÷¡C

TOP

¦n·Q¥i¥H¤U¸ü¨Ó¬ã¨s¬Ý¬Ý,,¥i±¤µLÅv­­..

TOP

½Ð°Ýªü¦N¥S
1.¶È¨£¥~ÀÉ(¬d¸ßExcelª©¥»)¡A¦Ó¬Ý¤£¨ìBOOK1¡A¬O¦p¦ó¿ì¨ì
2.BOOK1Âæb¥~ÀÉ(¬d¸ßExcelª©¥»)ªº¦ó³B¡A§Ú¹ê¦b§ä¤£¨ì
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-5-6 17:42 ½s¿è

¦^´_ 4# lin
    Lin¥S±z¦n¡A±z«e¤L¤Ñ¤£¬O¤w¸g¸ÕÁå¹L°ò¦档¤¤档§Þ¥©¤F¶Ü¡A«ç»ò会°Ý³o­Ó¡A­ì²z¬O¤@¼Ëªº¡ABook1¨º­ÓÀÉ©ñ¦b[4.0¼Ò²Õªí]¤¤
³o¸Ì¥u¬O§âµ{§Ç©ñ¦b内档¤¤¡A¨Ã¥B§@±M®×¤£¥i检µø¡A¥i¥H¼W¥[¯}¸Ñ§xÃø«×¡AVBA¥[¸ÑÂê¾¹¤£¯àª½±µ¯}¸Ñ°£«D§âBook内档¥t¦s¥X¨Ó¦A¯}¸Ñ¡A³Ìªñ¦³«Ü¦hVBAµ{¦¡´£¨ú¾¹¥X²{¡A³o­Ó¤èªk¤]¥i¥HÁקK³Q´£¨ú¥N½X

TOP

ªü¦N¥S
¶È¨£¥~ÀÉ(¬d¸ßExcelª©¥»)¡A¦Ó¬Ý¤£¨ìBOOK1¡A©Ò¥HµLªk"VBA¥[¸ÑÂê¾¹¤£¯àª½±µ¯}¸Ñ°£«D§âBook内档¥t¦s¥X¨Ó¦A¯}¸Ñ"¡A©Ò¥HÅצ³"BOOK1Âæb¥~ÀÉ(¬d¸ßExcelª©¥»)ªº¦ó³B"ªººÃ°Ý¡C
Lin

TOP

ªü¦N¥S
«ôŪ"°ò¦档¤¤档§Þ¥©"¡A¬O¬Û·í¦³³Ð·N¡A¦ý±©¤@¯ÊÂI´N¬O¡A¥~ÀÉ»P¤ºÀɤ@¨Ö¶}±Ò¡A®i¥Ü¥\¯à¦³¦ý«OÅ@¤ÎÁôÂÃ¥\¯à´N¤Ö¤F¨Ç¡A¦ý "¦Û°Ê¶}±ÒªºÀɤ¤Àɧޥ©¶i¶¥À³¥Î"¤¤ÁôÂäºÀÉ¡A¦]µLªk¬Ý¨ì¤ºÀÉ©Ò¥HÁקK³Q­×§ï¡A¦Ó¥B¥t¦s·sÀɩΪ½±µ¦sÀÉ¡A«h¿ò¥¢¤ºÀÉ¡A­Ý¨ã³Ð·N¤Î¹ê¥Î¦æ¡C§Ú¤w¸Ñ¶}book1¡A¨Ã¯à¥t¦s·sÀÉ¡A¥u¬OÁÙ¤£¬O«ÜÁA¸Ñ¡A³o´X¤Ñ¦A·Q·Q¡C
Lin

TOP

ªü¦N¥S
"¦Û°Ê¶}±ÒªºÀɤ¤Àɧޥ©¶i¶¥À³¥Î"¡A§Ú¤w¸Ñ¶}¤ºÀÉ¡A¨Ã¯à¥t¦s·sÀÉ¡A¸Õ¤F´X¤Ñ¡A¦ýÁÙ¬O¤£¸Ñ¤§ºÃ°Ý¦p¤U¡G
1.¥~ÀÉ­­¨î´¡¤Jª«¥ó¡A¸Õ¹L«Ü¦h¤èªk¤´µLªk§ïÅÜ¡C
2.¤w´¡¤Jª«¥ó¡AÀ³¬O¦s©ó¥~ÀɪºMacro1¤¤¡AÁö¤w¸Ñ¶}Macro1¡A¦ýÁÙ¬O§ä¤£¨ì¡A©Ò¥H¥~ÀÉ»P¤ºÀɪº³sµ²¡A¤]¬Ý¤£¥X¨Ó¡C
3.¥t¦s·sÀɶȯà¥~ÀɩΤºÀɳæ¿WÀx¦s¡AµLªk¥~ÀÉ»P¤ºÀɤ@¨ÖÀx¦s¡C
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-5-28 22:35 ½s¿è

lin ¥S¦n
±z»¡ªº³o¤@¬q¥\¯à¡A¥~ÀÉ»P¤ºÀɪº³sµ²
ÄÝ©ó excel4.0ª©~4.3ªO¶¡ªº¥\¯à¥s°µ [¤u¨ã¦C½s¿è¾¹]
³o­Ó¥\¯à¦bexcel95ªO®É¤w³Q[¦Û­q¤u¨ã¦C]¥\¯à¨ú¥N
©Ò¥H¥H«á¨ä¥Lª©¥»§¡¤wµLªk»s§@¦¹ºØ¤u¨ã¦C
¦Ó±z»¡ªºµLªk¦sÀɵ¥°ÝÃD¤]¬O¥Ñ¦¹¦]¯À¦Ó¨Ó
²{¦b½Ö·|®³excel4.3ª©¨Ó°µ³o­Ó?
§Úı±o³o¬q¥i¥H¤£¥Î¦A¾Ç.¦]¬°³o¬O­Ó·¥¨ä·¥¨ä³¯ÂªºªF¦è
³o­Ó½d¨Ò¬O¸ò¤j®a»¡©ú³o¥\¯àÁÙ¥i¥H¥Î...¥H«á¤j®a¦³¬Ý¨ì³oºØ©Ç¤u¨ã¦C ¤j·§´N¬O³o¼Ë¨Óªº

TOP

ªü¦N¥S
excel4.3 ¤w¦w¸Ë§¹¦¨¡A¦]¬°¬O­^¤åª©¡A©Ò¥HÁ٧䤣¨ì[¤u¨ã¦C½s¿è¾¹]
Lin

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD