ÈçºÎ½â³ýVBAProject µÄ¿ÚÁî±£»¤
ÕâƪÎÄÕÂÊÇ´ò¹þÇ·Õë¶ÔExcelËùдµÄһƪÎļþ½á¹¹·ÖÎöÎÄÕ£¬µ«Ò»ÑùÊÊÓÃÓÚAccess¡£(ÒÔÏ·½·¨½öÌṩΪѧϰʹÓã¬Çë²»ÒªÀÄÓã¬ÆÆ»µ VBA ±à³ÌÈËÔ±µÄ¹¤×÷³É¹û¡£Çë´ó¼ÒÇëËùÄܹºÂòÕý°æ) ×¢Ò⣺ ±¾ÎÄËùÔØÈ«²¿¡¢²¿·ÖÄÚÈݲ»µÃתÔØ¡¢ÉÌҵʹÓã¬×÷Õß±£ÁôËùÓз¨ÂÉȨÀû¡£ ËùÃèÊö·½·¨²»±£Ö¤²»¶Ô office Îļþ¡¢ÏµÍ³Ôì³ÉË𺦡£×÷Õß²»¶ÔʹÓÃÕßÐÐΪ¼°ÐÐΪºó¹û³Ðµ£·¨ÂÉÔðÈΡ£ ¼Ù¶¨£º 1¡¢Äã»áʹÓÃUltraEdit32»òÆäËü¶þ½øÖƱ༹¤¾ß 2¡¢ÄãÀí½â¶þ½øÖÆ¡¢Ê®½øÖÆ¡¢Ê®Áù½øÖƵĸÅÄî Excel ÖеÄ_VBA_Project_CUR storage(ÎÒÃÇ¿ÉÒÔÀí½âΪһ¸öĿ¼) ϵÄProject Stream(¿ÉÒÔÀí½âΪһ¸öÎļþ)ÊÇÒ»¸ö´¿Îı¾Îļþ¡£ÈçÏÂÀýËùʾÒ⣬ÊÇÒ»¸ö°üº¬ÁËÒ»¸ö¹¤×÷±í(Worksheet)¡¢Ò»¸öÄ£¿é(Moudle)µÄProject stream¡£ Æä±í´ïʽΪ: ÃüÁî·û=´® ... [С½Ú] ÃüÁî·û=´® ÿÐмäÓà &h0d;¡¢&h0a; (»Ø³µ¡¢»»ÐÐ)·Ö¸ô¡£ËùÒÔ£¬Õâ¾ÍΪÎÒÃǼòµ¥µØÆƽâÌṩÁËÌõ¼þ¡£ '******************************************** '*** ´øÓÐ VBA µÄExcel£¬Ã»ÓпÚÁî±£»¤ *** '******************************************** ID="{87EEB809-E9F0-11D6-95A2-008888998168}" Document=ThisWorkbook/&H00000000; Document=Sheet1/&H00000000; Module=Ä£¿é1 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="DBD91940F044F044F044F044" DPB="B6B474AD94536E546E546E" GC="91935354545454AB" [Host Extender Info] &H00000001;={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000; [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Ä£¿é1=22, 22, 155, 343, Z ÏÂÀýÊÇͬһ¸öÎļþ£¬Ôö¼ÓÁË¿ÚÁî±£»¤µÄproject stream¡£Çë×¢Òâ¿´ ID¡¢CMG¡¢DPBÒÔ¼°GC´®¡£ '******************************************** '*** ´øÓÐ VBA µÄExcel£¬ÓпÚÁî±£»¤ *** '******************************************** ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000; Document=Sheet1/&H00000000; Module=Ä£¿é1 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="B1B31D5B215B215F255F25" DPB="6260CEBD62DA62DA9D2663DAB338442F98229B892DDBD831C3AC5373F78FF8D2FB2E1F1B3B" GC="1614BA74DA9C8F9D8F9D8F" [Host Extender Info] &H00000001;={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000; [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Ä£¿é1=22, 22, 155, 343, Z µ±ID»òDPBÖеÄÄÚÈݱ»¸ü¸Äʱ£¬¾Í³öÏÖËùνµÄ¡°¹¤³Ì²»¿ÉÊÓ¡±×´Ì¬¡£ ¶øÆƽâµÄ·½·¨Ò²¾ÍºÜ¼òµ¥£º 1¡¢¼òµ¥¸²¸Ç ½«ID¡¢CMG¡¢DPBÒÔ¼°GC´®(°üÀ¨ ÃüÁî·û=´® )£¬¸²¸ÇΪ &h0d;¡¢&h0a;(×¢Ò⣺Çë³É¶ÔʹÓÃ)£¬Èç¹û³öÏÖµ¥×Ö½Ú¿ÕÓ࣬ÓÃ&h20;(¿Õ¸ñ)¸²¸Ç¡£ È磺 00000000h: 49 44 3D 22 7B 38 37 45 45 42 38 30 39 2D 45 39 ; ID="{ 87EEB809- E9 00000010h: 46 30 2D 31 31 44 36 2D 39 35 41 32 2D 30 30 38 ; F0- 11D6- 95A2- 008 00000020h: 38 38 38 39 39 38 31 36 38 7D 22 0D 0A 44 6F 63 ; 888998168}".. Doc Ì滻Ϊ£º 00000000h: 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A ; .................. 00000010h: 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A ; ................... 00000020h: 0D 0A 0D 0A 0D 0A 0D 0A 0D 0A 20 0D 0A 44 6F 63 ; .......... .. Doc 2¡¢ÆäËû·½·¨ ±¾ÎIJ»ÔÙÌṩ¡£ ×¢ÒâÊÂÏ 1¡¢Excel ÖÐµÄ Stream ²ÉÓÃlaola Îļþϵͳ´æ·Å(Çë²Î¿¼×¾×÷¡¶Excel ¶þ½øÖÆÎļþ½á¹¹·ÖÎö¡·)£¬Òò¶østream ÄÚÈÝ¿ÉÄܲ»Á¬Ðø´æ·Å¡£ ÀýÈ磬project stream °´Ð¡Îļþ¿é·½Ê½´æ·Åʱ£¬Ã¿ 64 ×Ö½Ú(Laola Header Æ«ÒÆ&h20; ¶¨Òå)Ϊһ¸ö¿é£¬ÏàÁٵĿéÔÚExcelÎļþÖÐ ²»Á¬Ðø´æ·Å¡£ÔÚ²ÉÓüòµ¥¸²¸Ç·½Ê½Ê±Çë×¢Òâ²»Òª¸²¸Ç´íλÖá£
--------------------------------------------------------------------------------
Ïà¹ØÎÄÕÂ
ÆƽâAccess(*.mdb)Ä¿Ç°ËùÓа汾µÄÃÜÂë 2003-11-17 11:31:05
·ÀÖ¹Access 2000ÃÜÂë±»ÆÆÒëµÄ·½·¨ 2003-11-13 11:14:21
Access 2000Êý¾Ý¿âµÄÃÜÂëÍüÁËÔõô°ì 2003-11-13 11:05:39
|