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

[­ì³Ð] ¬°¦ó¨ä¥L¨ä¥L³nÅéµLªk¨ú¥NExcel?

[­ì³Ð] ¬°¦ó¨ä¥L¨ä¥L³nÅéµLªk¨ú¥NExcel?

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2017-8-13 01:58 ½s¿è

Ävª§³nÅé¡A­n¦b (XLM¥¨¶°ªí¡AVBA¼Ò²Õªí»P)VBA¥¨¶°¡A¼Ï¯Ã¤ÀªR¡AĹ¹LMS Excel¤~¥i¯à¨ú¥N¥¦¡A¦ý³o´X¥G¤£¥i¯à¦]¬°VB»PVBAªº©ö¥Î©Ê´N¬O¥¦³Ì¤jªºÀu¶Õ¡A¦Ó¼Ï¯Ã¤ÀªR¬É­±¥Ø«eÁÙ¨S¦³¬Ý¨ì¤ñ¥L§ó¦n¥Îªº¡A¦n¯ºªº¬O«e°}¤l¡A¤@ª½¦³ÁͶշL³n­n¥Î¿W¥ßVisual Studioµ{¦¡¡A®ø°£¨ú¥NMS Office ¤º«ØVBE½s¿è¾¹¤§·P¨ü¡A­Y¯u¦p¦¹°µ¤F¡AµL²§±þÂû¨ú§Z¡Aµ¥¦P­I±ó³o40¦~¨Ó¸Õºâªí³nÅé ¥¨¶°¨Ï¥ÎªÌ¡A¦Ó¥sVisual Studioµ{¦¡¤H­û¨Ó¼gVBA?¡A¤£¶È´î¤Ö¸ÕºâªíVBA¥¨¶°©ö¥Î©Ê¡AVisual Studioµ{¦¡¤H­û¤j³¡¥÷¤£À´±oOfficeª«¥ó»P¥\¯à¡A¯à¼gªº¥X¦nµ{¦¡ªº¦³­­¡A¦p¦¹¸ò±À¼sExcel³nÅ駹¥þ­I¹D¦Ó¹£¡C

¨ì¥Ø«e¤´¥i¬Ý¨ì ·íªìÁͶÕVisual Studioªº¾l¬r¡A¦ÛExcel4.0°_§Y¦³"¥\¯àªí½s¿è¾¹"¥i«ü©w¥¨¶°¨Ã»s¦¨"¥\¯àªí"¡A¦ÜExcel95¥H«á¥i¨Ï¥Îªþ¥[¦Û­q¤u¨ã¦C¨Ó«ü©w¥¨¶°¡A¦Ó¨ìExcel2007«á¥¨¶°¥\¯àªí¤u¨ã¦C¤§«ü©w»Pªþ¥[¡A­n¦Û¤v¤U¸ü¤pµ{¦¡Custom UI Editor¥t¥~½s¿è©Î¥ÎVisual Studio»s§@¡A¼W¥[¤F¼W¯q¶°¦Û­q¤u¨ã¦Cªº§xÃø«×¡A¥t¥~Visual Studio¥i¥H»s§@VBA¡A³o¨S¦³VBA¿ý»s¥\¯à¡Aı±o·|¦n¥Î?
Custom UI Editor¦Û­qOffice 2007¤¤¤å¥\¯à°Ï(Ribbon)https://super999.tian.yam.com/posts/13675006
Visual Studio 2017 ÂX¥R¦Û°Êµ{¦¡½X UI ´ú¸Õ©M°Ê§@°O¿ý¥H¤ä´© Microsoft Excel https://msdn.microsoft.com/zh-tw/library/ff398055.aspx

«Øij·L³n¤Å¥ÎVisual Studio¨ú¥N¤º«Ø¤§VBA¥¨¶°¡A«Øij·L³nºÉ³t±NCustom UI Editor¦Pµ¥¤§½s¿è¾¹¤º«Ø¦bOffice¤º¡A¤Å¦A©¿²¤¥H©¹¬J¦³¤§UI¥\¯à

¥Ñ¸Õºâªí40¦~¾ú¥v¥i¥HÁA¸Ñ¡A¸Õºâªí»Ý­n¤U¦Cµ¥¥\¯à:
1¸Õºâªí»P¨ç¼Æ¡A2¹Ï§Î¡A3¸ê®Æ®w¡A4XLM»PVBA¥¨¶°¡A5¼Ï¯Ã¤ÀªR¡A6¯àÅý¶}µo¤H­û¡A¦Û­q¨Ï¥ÎªÌ¤¶­±¡A7ÂX¥R¬°¦h­¶¸Õºâªí¨Ã¥iÀ˵ø¦C¦Lµ²ªG
¨ä¤¤Ävª§³nÅé¡AµLªk¨ú¥Nªº¬° 4XLM»PVBA¥¨¶°¡A5¼Ï¯Ã¤ÀªR¡A

**********************************

¿ì¤½«Ç­pºâ³nÅé³o¥|¤Q¦~¨Ó¤£Â_±À³¯¥X·s

1978 VisiCalc For Apple2 (VisiCorp)±À¥X³Q»{¬°¬OApple2¹q¸£¦¨¥\¥D¦]¡CSuperCalc For CP/M(Sorcim¤½¥q) °lÀH¨ä«á

1981 VisiCalc»PSuperCalc¤À§O±À¥XIBM PCª©¥»

1983 Lotus123 For IBM PC(Lotus Development Corp)¡A²Ä¤@®M16¦ì¤¸³nÅé¡A¥¦¯u¥¿¥X¦â¦¨¥\ªº¦a¤è¬O¾Ö¦³¥¨¶°¤u¨ã¥B¥¿¦¡µ²¦X¡A1¸Õºâªí»P¨ç¼Æ¡A2¹Ï§Î¡A3¸ê®Æ®w¡A4¥¨¶°

1989 Lotus123 For Dos»POS/2 (80286PC)¡AÂX¥R¬°¦h­¶¸Õºâªí¡A¨Ã¥iÀ˵ø¦C¦Lµ²ªG

1990 Windows3.0½Ï¥Í¡AVisiCorp¤£­«µøWindowsÀô¹Ò¡A±À®i¹LºC1991¦~©³¤~±À¥X¡A«á´Á¤£­«µøLotus¸Õºâªí¡A¤Ï¦Ó­«µøNotes¡A³y´NExcel±¸°_¡A³Ì«áLotus Development Corp©ó1995¦~³QIBM¶R¤U¡ALotus123³Ì·sªº¥\¯à¬OLotusScript¡A¬O¤@ºØ¦üVBA»y¨¥¡ALotus©Î³\À³¦VMicrosoft¥Ó½ÐVBA¨Ï¥ÎÅv

¥Ø«e¤w°±¤î§ó·s
IBM Lotus 1-2-3¤w©ó2013¦~6¤ë11¤é°±¤î¾P°â¡A³nÅé¤ä´©ªA°È±N«ùÄò¨ì2014¦~9¤ë30¤é
https://zh.m.wikipedia.org/zh-tw/Lotus_1-2-3

-----------------------------------
1987 Quattro¸Õºâªí±À¥X¡A¥i¬Û®eLotus123¥¨¶°

1989 Quattro Pro¸Õºâªí±À¥X

1990 Quattro Pro2.0¥[¤J3D¹Ï¡A3.0¥[¤J¨Ï¥ÎªÌ¹Ï§Î¤¶­±»P¤Û¿O¤ù¡A4.0¥[¤J¦Û­q¤u¨ã¦CSpeetBars¡A5.0¦h­¶µ§°O¥»¡A¦P¼Ë¦]¤£­«µøWindowsÀô¹Ò¡A±À®i¹LºC1992¦~¤~±À¥XWindowsª©¥»¡A­È±o¤@´£ªº¬OQuattro Pro ³Ð·sªº¥\¯à¤@ºØ¥s§@UI Builderªº¥\¯à¡A¯àÅý¶}µo¤H­û¡A¦Û­q¨Ï¥ÎªÌ¤¶­±¡CLotus123(Lotus)»P Quattro Pro(Borland)¡A¦³¤@³õ123¥¨¶°¬Û®e©Ê»P¥\¯àªí¿ï¶µªº¶D³^

¥Ø«e³Ì·sª©¥»¬°Quattro Pro X5¡V¹q¤lªí®æ¡A³QNovell¦¬Áʨ֤JWordPerfect Office
https://zh.m.wikipedia.org/zh-tw/WordPerfect_Office

-----------------------------------
Excel2.1ª©¨Ï¥ÎXLM¥¨¶°ªí¡A¥¨¶°ªí«P¦¨«áÄòª©¥»¡A¥¨¶°¦w¥þ©Êªº³]¥ß

1992¦~¡AExcel4.0ª©¡A·s¼W¤FVBA¼Ò²Õªí¡A¦¹ª©¥»Excel VBA¦¨¬°¥¨¶°¯f¬r·P¬V½d¨Ò¡C¦¹ª©¥»´N¦³VBA¦ýVB½s¿è¾¹¤£§¹¾ã¡A°±¯d¦b¼Ò²Õªí¤è¦¡(«DXLM¥¨¶°ªí)

1993¦~¡A§@¬°Microsoft Officeªº¤¸¥óµo¥¬¤F5.0ª©¤§«á¡A¶}©l¦³§¹¾ãVBE½s¿è¾¹¡AExcel´N¶}©l¦¨¬°©Ò¾A¥Î¾Þ§@¥­¥x¤Wªº¹q¤l»sªí³nÅ骺ÅQ¥D

¥Ø«e³Ì·sª©¥»¬°Excel2016 / Excel16
https://zh.m.wikipedia.org/zh-tw/Microsoft_Excel

-----------------------------------
¥ÑExcel¬Û®e©Ê¬Ý¾ú¥vÀɮ׮榡¦Cªí
https://support.office.com/zh-tw ... d-aaea-b83d51d46247

¦^´_ 3# baa168


¥i¥HÂsÄý¤@¤U libreoffice
    https://documentation.libreoffice.org

TOP

¦n¸ÔºÉ
­ì¨Ó excel ÁÙ¦³³o¼Ë¤lªº¾ú¥v­I´º

TOP

¦n¸Ô²Óªº¸Ñ»¡¡AÁöµMµ¥¯Å³s¬ÝÀ´¤@«}«}³£ÁÙ«ÜÃø¡K
¥¿§V¤O¾\Ū¤À¨Éªº³sµ²
ÁÂÁªü¦N¤j­ôªº¤À¨É

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD