ÊÖ»úÕ¾
ÍøÍ¨·ÖÕ¾
µçÐÅÖ÷Õ¾
ÃÜ¡¡Âë:
Óû§Ãû£º
µ±Ç°Î»Öà : Ö÷Ò³>³ÌÐòÉè¼Æ>VB>Áбí

ÕæÃ»Ïëµ½VBÒ²¿ÉÒÔÕâÑùÓÃÖ®VBÄÜ×öʲô

À´Ô´£º»¥ÁªÍø ×÷Õߣºwest263.com ʱ¼ä£º2008-02-23
Î÷²¿ÊýÂë-È«¹úÐéÄâÖ÷»ú10Ç¿£¡40ÓàÏîÐéÄâÖ÷»ú¹ÜÀí¹¦ÄÜ,È«¹úÁìÏÈ!Ë«Ïß¶àÏßÐéÄâÖ÷»úÄϱ±·ÃÎʳ©Í¨ÎÞ×è!Ãâ·ÑÔùËÍÆóÒµÓʾÖ,.CNÓòÃû,×ÔÖú½¨Õ¾480ÔªÆð,Ãâ·ÑÊÔÓÃ7Ìì,ÂúÒâÔÙ¸¶¿î! P4Ö÷»ú×âÓÃ799Ôª/ÔÂ.Ô¸¶Ãâѹ½ð!
VBÒ»Ö±ÒÔÀ´±»ÈÏΪÓÐÒÔÏÂÓÅȱµã£ºÓŵãÊÇÉÏÊÖ¿ì¡¢¿ª·¢Ð§Âʸߣ»È±µãÊÇÄÜÁ¦ÓÐÏÞ£¬ÔËÐÐЧÂʵ͡£ÕâÕýÊÇÓÐЩÈí¼þ°ÑVB×öΪÊ×Ñ¡ÓïÑÔ£¬¶øÓÐЩÈí¼þ¿Ï¶¨²»»áÓÃVB×öµÄÔ­Òò¡£¶øºÜ¶àVC£¬DelphiµÄ³ÌÐòÔ±¶¼ÈÏΪVBÀï¸ã¿ª·¢²»×ÔÓÉ£¬ËüÈÃÎÒÃÇ×öʱäÈÝÒ×µÄͬʱ£¬Ò²ÈÃÎÒÃÇ·¢»ÓµÄÓàµØÔ½À´Ô½Ð¡¡£µÄÈ·£¬¼òµ¥ºÍ¹¦ÄÜÇ¿´óÕâÁ½Õß±¾Éí¾ÍÊÇÒ»¶Ôì¶Ü¡£ÄÇÅÂÒ»ÐдúÂ벻д£¬½ö½öÆð¶¯ÔËÐÐÒ»¸ö¿Õ´°ÌåÕâÑù¼òµ¥¶¯×÷£¬VBÔÚµ×ϾÍΪÎÒÃÇ×öÁË´óÁ¿¸´ÔӵŤ×÷£¨¾ö²»½ö½öÊÇ×¢²á´°¿ÚÀà¡¢ÏÔʾ´°¿Ú¡¢Æð¶¯ÏûϢѭ»·Õâô¼òµ¥£©£¬ÕâЩ¹¤×÷¶Ô³ÌÐòÔ±ÊÇ͸Ã÷µÄ¡£ÎÒÃÇÔÚ¸ÐлVB¿ª·¢Ð¡×é¶ÔÎÒÃdzÌÐòÔ±ÌåÌùÈë΢µÄͬʱ£¬²»½ûÒ²ÒªÔð¹ÖΪʲôÔÚÎĵµÖжÔÕâЩµ×²ãµÄ¶¯×÷Ö»×ÖδÌᣬËäÈ»ÕâЩ¶¯×÷¶Ô×îÖյijÌÐòÒ²Ðí²¢ÎÞÓ°Ï죬µ«ÎÒÃÇÓµÓÐÖªÇéȨ£¬¸üºÎ¿öÕâЩ¶¯×÷ÓÐʱµÄÈ·»áÓ°ÏìÎÒÃǵŤ×÷¡£

¡¡¡¡È»¶ø£¬ËùÓÐÏ£Íû´Ó±¾Îĵõ½"δ¹«¿ª¼¼ÊõÃØÃÜ"µÄÅóÓÑÄ㽫»áºÜʧÍû£¬ÒòΪÎÒÄܹ»ÖªµÀµÄºÍÄãÒ»Ñù¶à£¬ÎÒÃÇËùÄÜ×öµÄÒ»ÇоÍÊÇÕ¾ÔÚÍâÃæÀ´²ÂVBÔÚÀïÃæ×öÁËʲô£¿ËùÒÔÎÒ¾ö²»ÊÇÒª´ø´ó¼ÒÒ»ÆðÈ¥½«VB·´Ïò¹¤³Ì£¬¶øÊÇÏëͨ¹ý²ÂÏëVBµÄÄÚ²¿¹¤×÷À´½«Ò»Ð©Ô­À´±È½ÏÄ£ºýµÄ¸ÅÄî¸ãÇå³þ¡£×÷Ϊһ¸öϵÁеĵÚһƪÎÄÕ£¬ËüµÄÄ¿µÄÊÇΪÁ˺óÃæµÄÉîÈë´òÏ»ù´¡£¬ËùÒÔÎÒ»áÔÚÐèÒªµÄʱºòÖ¸³öÎÒÃDZØÐëÕÆÎÕµÄ֪ʶµã£¬Èç¹ûÄã²»Çå³þ£¬Ç뼰ʱµØÑ§Ï°Ïà¹ØÊé¼®À´²¹¿Î¡£

¡¡¡¡×îºó£¬ÒªÉùÃ÷ÎÒÔÚ±¾ÎÄÖÐËù×öµÄ¸÷ÖÖʵÑéºÍÍÆ¶Ï½öÊÇÎÒ¸öÈ˵Ĺ۵㣬²»Äܱ£Ö¤ÆäÕýÈ·ÐÔ£¬²¢ÇÒ²»³Ðµ£ÈκÎÏà¹ØµÄ·¨ÂÉÔðÈΡ£

¡¡¡¡ºÃ£¬¿ªÊ¼°É£¡Ê×ÏÈ×¼±¸ºÃÎÒÃǵÄÎäÆ÷£¬ÎÒÏÂÃæÒªÊ¹ÓõŤ¾ßÖ÷ÒªÓУºVB6ÖÐÎÄÆóÒµ°æ SP5£¨·Ï»°£©£¬»¹ÓÐSPY ¡¢Dependency WalkºÍOLE Viewer£¨ÒÔϼò³ÆSPYºÍDEPENDºÍOLEVIEW£¬SPYÔÚVB¹âÅ̵Äcommon\tools\vb\ϵÄSPYĿ¼ÖУ¬OLEVIEWÊÇÆäÏÂOLETOOLSĿ¼ÖеÄOLEVIEW.EXE£¬×¢ÒâÆäÏ»¹ÓÐÒ»¸öOLE2VW32.EXE¹¦ÄÜÀàËÆ£¬²»¹ý±¾ÎÄËùÖ¸µÄÊÇOLEVIEW.EXE£¬»¹DenpendÔÚÆäϵÄUnsupprt\DEPENDÀ¡£»¹ÒªÓÃÓÃVC£¨ÉÏÃæÌáµÄ¹¤¾ßÔÚVCÀïÓУ©£¬ÒòΪÎÒÃÇ»¹Òª¿´¿´VBÉú³ÉµÄ´úÂ룬¸ãVB¸ß¼¶¿ª·¢µÄÅóÓÑÒ»¶¨Òª»áÓÃVCµ÷ÊÔÆ÷£¬¶®µã»ã±à¸üºÃ¡£µ±È»£¬±¾ÎĵÄÖØµã²»ÔÚÕâ¶ù£¬ËùÒÔûÓÐVCÒ²²»Òª½ô¡£

¡¡¡¡´ò¿ªVB6н¨Ò»±ê×¼EXE¹¤³Ì£¬ÔÚ"¹¤³Ì"->"ÒýÓÃ"¶Ô»°¿òÀïÓ¦¸ÃÒÑÓÐËĸöÒýÓ㬼òµ¥µã¾ÍÊÇ£º

¡¡¡¡1¡¢Visual Basic For Application(VBA)

¡¡¡¡2¡¢VBÔËÐÐʱ¶ÔÏó¿â

¡¡¡¡3¡¢VB¶ÔÏó¿â

¡¡¡¡4¡¢OLE×Ô¶¯»¯¡£Ç°ÃæÈý¸öÊÇÈκÎVB¹¤³Ì¶¼±ØÐëµÄ£¬ÄãÏë²»Òª¶¼²»ÐУ¬²»ÐÅÄãÊÔ×ÅÈ¥µô¶ÔËüÃǵÄÒýÓá£ÄÇôÕâÈý¸öºËÐÄÀàÐÍ¿â¸÷ÓÐʲôÓã¬ÔÚ×îÖÕÉú³ÉµÄ¿ÉÖ´ÐгÌÐòÖаçÑÝÔõÑùµÄ½ÇÉ«£¬ÕâÊDZ¾ÎÄÒª·ÖÎöµÄµÚÒ»¸öÎÊÌâ¡£

¡¡¡¡1£©VB¡¢VBA¡¢VBSµÄÇø±ðÄã¸ãÇå³þÁËÂð£¿

¡¡¡¡Ê×ÏÈVBS²»Ó¦¸ÃºÍVB¡¢VBA·ÅÔÚÒ»Æð±È½Ï£¬ËüÊÇ΢Èí°´ÕÕ×Ô¼º¶¨ÒåµÄActiveX Scripting¹æ·¶ÍêÈ«´ÓÍ·¿ªÊ¼Ð´³ÉµÄ½Å±¾ÓïÑÔ£¬ËäÈ»ËüµÄÓï·¨½á¹¹ºÍVB·Ç³£ÏàËÆ£¬µ«VBS½ö½öÒÀ¿¿×Ô¶¯»¯¶ÔÏóÀ´À©³äÆä¹¦ÄÜ£¨Ö»ÓкóÆÚ°ó¶¨£©£¬Ëü²»ÄÜÓÃimplementsÀ´ÊµÏÖ½Ó¿Ú£¬²»¿ÉÄÜÔÚVBSÀïÖ±½ÓʹÓÃAPI£¬Ã»ÓÐVarPtrÕâÑùÄܵõ½Ö¸ÕëµÄº¯Êý£¬¶øVBSȱÉÙµÄÕâЩ¹¦ÄÜÕýÊÇVBºÍVBAËùÌØÓеġ£µ±È»£¬Õâ²»ÊÇ˵VBS²»ÈçVB»òVBA£¬WindowsÒѾ­ÎªVBSÌṩÁË×㹻ǿ´óµÄ¹¦ÄÜ£¬ÎÒÃÇ¿ÉÒÔÓÃVBSÀ´×ö½Å±¾COM×é¼þ£¬¶øÇÒ½è×Ô¶¯»¯¶ÔÏóµÄÄÜÁ¦VBS¿ÉÒÔ˵ÄÜÁ¦ÎÞÏÞ£¬ËùÒÔÓв¡¶¾ÓÃVBSÀ´Ð´£¬¶Ô³ÌÐòÔ±À´ËµVBS×îÖØÒªµÄ¹¦ÄÜιýÓÚ¿ÉÒÔ¸ø×Ô¼ºµÄÈí¼þÌṩºê¹¦ÄÜ£¬¾ÍÏóVCÖÐÌṩµÄVBSºê¹¦ÄÜÄÇÑù¡£×¢Ò⣬VBSÊÇFreeµÄ£¬ÕâºÍÔÚOfficeÖÐʹÓÃVBAÀ´Ìṩºê¹¦Äܲ»Í¬£¬Òª¼¯³ÉVBAÐèÒª¼Û¸ñ²»µÍµÄÐí¿ÉÖ¤·ÑÓ㬹ØÓڽű¾ÓïÑԿɲμûMSDNÖÐPlatform SDK\Tools and Languages\Scripting¡££¨ÔÚ±¾ÏµÁкóÃæµÄÎÄÕ¡¶½Å±¾¹¦ÄÜ¡·ÖÐÎÒ»áʵ×öÒ»¸öÓÃVBSÀ´Ìṩºê¹¦ÄܵÄСÈí¼þ£©
ÄÇôVBºÍVBAÓÖÓÐʲô²»Í¬ÄØ£¿ºÃ°É£¬ÑÛ¼ûΪʵ£¬¿ªÊ¼ÎÒÃǵÄʵÑé°É£¡

¡¡¡¡Èç¹û×°ÁËOffice 2000ÒÔÉϰ汾£¬ÄÇô´ò¿ªOLEVIEW£¬µã»÷FileϵÄView TypeLib²é¿´Î»ÓÚE:\Program Files\Common Files\Microsoft Shared\VBA\VBA6ϵÄVBE6.dllµÄÀàÐͿ⣬ÔÙÓÃͬÑùµÄ·½·¨¿´¿´MSVBVM60.dllµÄÀàÐͿ⣬Äã»á·¢ÏÖËüÃǵÄÀàÐÍ¿â»ù±¾ÉÏһģһÑù£¬³ýÁËVBE6¶àÁËÒ»¸öVBEGlobal½Ó¿ÚºÍʵÏÖÕâ¸ö½Ó¿ÚµÄGlobal¶ÔÏó£¬Õâ¸öGlobal¶ÔÏóÎÒÃÇÒ²¿ÉÒÔÔÚVBA±à³Ì»·¾³£¨±ÈÈçÓÃWORDµÄVB±à¼­Æ÷£©ÖÐÓöÔÏóä¯ÀÀÆ÷¿´µ½¡£ËüÓжþ¸ö·½·¨LoadºÍUnLoad£¬»¹ÓÐÒ»¸öUserFormsÊôÐÔ£¬ÕâÊÇÒòΪVBA6ʹÓÃMS Form 2.0 FormÉè¼ÆÆ÷(FM20.dll)À´Éè¼ÆºÍʹÓÃUserForm´°Ì壨¶øÔÚVB6ÖУ¬ÎÒÃÇ¿ÉÒÔʹÓöà¸öÉè¼ÆÆ÷¡£±ÈÈçͨ¹ýʹÓÃMS Form 2.0 FormÉè¼ÆÆ÷£¬ÎÒÃǾÍÄÜÔÚVBÖÐʹÓÃVBAËùʹÓõÄUserFormÓû§´°Ì壩¡£

¡¡¡¡ºÍVBAµÄGlobal¶ÔÏóÀàËÆ£¬ÔÚVBÖÐÒ²ÓÐGLobal¶ÔÏ󣬴ÓVBµÄ¶ÔÏóä¯ÀÀÆ÷ÖпÉÒÔÖªµÀËüÔÚvb6.olbÕâ¸öÀàÐÍ¿âÖУ¬Õâ¸öÀàÐÍ¿â¾ÍÊÇÿ¸ö¹¤³Ì¶¼±ØÐëÒýÓõÄVB¶ÔÏó¿â£¬ËùÓеÄVBÄÚÖöÔÏó¶¼ÔÚÕâÀï¡£¶øVBAµÄUserFormÖÐʹÓõĶÔÏó¶¼ÔÚFM20.dllÖС£
³ýÁËÉÏÊö²»Í¬Í⣬VBºÍVBA»¹ÓÐÒ»¸ö×î´óµÄ²»Í¬£¬¾ÍÊÇVBA²»ÄÜÉú³ÉEXE¿ÉÖ´ÐÐÎļþ£¬µ«¿ÉÒÔ²ÂÏëÔÚIDE»·¾³ÖÐVBAºÍVB¶¼Òª°Ñ´úÂë±àÒë³Ép-codeÀ´Ö´ÐУ¬ºóÃæÎÒ½«ÓÃʵÑéÀ´Ö¤Ã÷µÄÈ·ÊÇÕâÑù£¬ËäÈ»ÔÚ¾ßÌåµÄʵÏÖÉÏVBºÍVBAÓкܴóµÄ²»Í¬¡£

¡¡¡¡´ÓÉÏÃæµÄ·ÖÎöÉÏ¿ÉÒÔ¿´µ½VBºÍVBA»¹ÊÇÓкܴó²»Í¬µÄ£¬ÕâÖÖ²»Í¬Ö÷ÒªÌåÏÖÔÚ±à³Ì»·¾³ºÍ¶ÔÏó½á¹¹ÉÏ£¬µ«ÔÚ±¾ÖÊÉÏËüÃÇÖ®¼äÈ´ÓÐ×Ų»¿É¸îÉáµÄѪԴ¹ØÏµ¡£Èç¹û¸Õ²ÅÄã×ÐϸµØ¹Û²ìÁËMSVBVM60.dllµÄÀàÐͿ⣬Äã¾Í»á·¢ÏÖÈçÏÂµÄÆ¬¶Ï£º

// Generated .IDL file (by the OLE/COM Object Viewer)
[
dllname("VBA6.DLL"),
uuid(35BFBDA0-2BCC-1069-82D5-00DD010EDFAA),
helpcontext(0x000f6ec4)
]
module Strings {
[entry(0x60000000), helpcontext(0x000f665f)]
short _stdcall Asc([in] BSTR String);
[entry(0x60000001), helpcontext(0x000f6e9f)]
BSTR _stdcall _B_str_Chr([in] long CharCode);
¡­¡­¡­¡­¡­
}
¡¡¡¡Ê²Ã´£¿ÔÚMSVBVM60.dllÖеĶÔÏóÆä·½·¨È´¶¨ÒåÔÚVBA6.DLLÖУ¿£¡VB°²×°Ä¿Â¼Ï²»¾ÍÓиöVBA6.DLLÂð£¿ÔÙÓÃOLEVIEW¿´¿´Ëü£¬ÍÛàç£¬ÕæÊÇÏë²»µ½Ëü¾ÓÈ»ºÍMSVBVM60.DLLµÄһģһÑù¡£Ôõô»ØÊ£¿¸Ï¿ìÔÙÄóöDEPENDÀ´¿´¿´VBA6.dll¡¢MSVBVM60.dllºÍVBE6.dllÕâÈý¸öDLLµÄÊä³öº¯Êý¡£¹þ£¬ÓÖÓÐз¢ÏÖ£¬ÎÒÃÇ¿ÉÒÔ·¢ÏÖÔÚÈý¸öDLLµÄÊä³öº¯ÊýÖдӱàºÅ512µ½717¾ø´ó²¿·Ö¶¼ÊÇһģһÑùµÄһЩÒÔrtc¿ªÍ·µÄº¯Êý£¬±ÈÈç595µÄrtcMsgBox£¨rtcÊÇʲô£¿Ó¦¸ÃÊÇRun Time Component? Control? Code?ÓÐË­ÖªµÀÂ𣿣©£¬Õâ˵Ã÷Èý¸öDLL¶¼ÓÐ×ÅÏàͬµÄÔËÐÐʱVBAº¯Êý¡£

ÎÄÕÂÕûÀí£ºÎ÷²¿ÊýÂë--רҵÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú·þÎñ
http://www.west263.com
ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúÒª×ªÔØ±¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!