ࡱ> r  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqstuvwxyz{|}~Root Entry F2]̒P܏2Workbook_VBA_PROJECT_CUR"`~3܏P܏VBAP:܏0 D܏ (ɀ\pThomas Harmening Ba=DieseArbeitsmappe=,\:&8X@"1Arial1Arial1Arial1Arial1>Arial1Arial1 Arial1$Arial1Arial3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q*6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k)3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-,>_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{+;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_-"Ja";"Ja";"Nein""Wahr";"Wahr";"Falsch""Ein";"Ein";"Aus"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                 + )   , * (X (X 1(P  ` AntwortenEigene beitrge11!  ;9 !  ;k Makro1 Makro2V< ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV;9 V< ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV;jX> ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV_1;9 X> ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV_1;jTrj0?!3 A@@  4 Eigene ThemenDatumForum Antworten S (ɀ : {C !%*c/+48=BKGLPUkZ3_chmSrw{s;˓[#{C Ӿc+Kk3S s;#(,1[6#;?D{ICN SW\ca+fjotKy~ۂk3ÚSs;[#  dMbP?_*+%"<~?<~?U } $Q} } *: @                                       Dl* !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                     Dl !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Dl                                Dl                                Dl                                Dl                                Dl                                                                                          Dl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ? Dl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  [  \  ]  ^  _ Dl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~   Dl                                                                Dl                                                                Dl                                                                Dl                                                                Dl                                                                                          Dl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ? Dl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  [  \  ]  ^  _ Dl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~   Dl                                                                Dl                                                                Dl                                                                Dl                                                                Dl                                                                                          Dl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ? Dl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  [  \  ]  ^  _ Dl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~   Dl                                                                Dl                                                                Dl                                                                Dl                                                                Dl                                                                                          Dl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9   !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9 8T <(  ~  <+CC@ ],@+%ȋH+9 $ < Autofilter<3 ~~  <|,CC@],@|,&,9 $<Web<H>@MI>ubbmisc.cgi?action=getbio&ViewNTopics=ALL&UserName=charlieBV_1 D]Zhttp://ww3.cad.de/cgi-bin/ubb/ubbmisc.cgi?action=getbio&ViewRTopics=ALL&UserName=charlieBVS>ubbmisc.cgi?action=getbio&ViewNTopics=ALL&UserName=charlieBV_1me# 4# 7 Tabelle2 (ɀ  kmO  dMbP      !?_*+%"<~?<~?ctU } 8} } mk@                                       Dl* !"#$%&'()*+,-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _Dl`abcdefghij ` a b c d e f g h i jT ><(  ~   <8DCC@s&], @8D)C9 $ < Autofilter<3 ~~  <DCC@],@D*`D9 $<Web<H>@MI>ubbmisc.cgi?action=getbio&ViewNTopics=ALL&UserName=charlieBV_1 D]Zhttp://ww3.cad.de/cgi-bin/ubb/ubbmisc.cgi?action=getbio&ViewNTopics=ALL&UserName=charlieBVS>ubbmisc.cgi?action=getbio&ViewNTopics=ALL&UserName=charlieBV_1me# 3# 7 Tabelle1 Modul1 __SRP_2$__SRP_3+DieseArbeitsmappe$.  !"#%&'()*,-/0123456789:;<=?@ABCDEFGHIJKLMOPQRSTUVWXYZ[\]_`abcdefghijklmnopqrstuvwxyz{|}~LxMEP6 L<<< 140% `xP8k6Makro am 07.03.2008 von Thomas Harmening aufgezeichnet 14  `$k86Makro am 07.03.2008 von Thomas Harmening aufgezeichnetP 6@x @8h @X @hH @8 h8 @Pl @\ @X @H @8 @( 8@$ 8RQI $*\Rffff*1>495153e5*\R1*#21c*\R1*#1b0*\R1*#df*\R1*#285"10"HKP `8op&A1$!"B@$FA:C$6B@oHAttribute VB_Name = "Modul1" Sub Makro1() L.DescriptionrX am 07.03.2 008 v4Thomas Harmening aufgezeic0hneti[Pr@ocDatagInvoke_Funcg \n146 Columns("A:C").AutoFilter End 22b-b Rang ec1bQueryTable.Refresh Background:=Falser rU~| Ait81:h%x$ `x8x581D8$ xH8PKf8%X'\%:l%$ XaHj$$ )X$5HXP$ X$HfrU $`a$`an'-q#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0RQI xAttribute VB_Name = "DieseArbeitsmappe" " Bas0{00020819-0C$ 0046} |GlobalSpacIFalse dCreatablPredeclaIdTru BExposeTemplate`DerivBustomizD2'#Tabelle1 >Tabelle2N_VBA_PROJECT ^ dirOxME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0RQI xAttribute VB_Name = "Tabelle1"  Bas|0{00020820-; C$0046} |GlobalSpac False dCr@eatablPredeclaDIdTru BE xposeTemplateDeriv$Bust0omizD2'#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0RQI xAttribute VB_Name = "Tabelle2"  Bas|0{00020820-; C$0046} |GlobalSpac False dCr@eatablPredeclaDIdTru BE xposeTemplateDeriv$Bust0omizD2as *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.4#0#C:\Program Files\Microsoft Office\Office10\EXCEL.EXE#Microsoft Excel 10.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.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 10.0 Object Library RQI  Modul11>495153e5 Modul1"DieseArbeitsmappe0w49515155)"DieseArbeitsmappe-q-Tabelle10x49515155+Tabelle10-Tabelle21;495152b6-Tabelle2H-hH0'I4-H7KcrtG.DD66|Ndp7F"ZOjG(RFalse Excel+ VBAWin16~Win32MacVBA6#Projekt1A stdole` VBAProject Officeu Modul1 _Evaluate(Makro1C|Range  SelectionZ AutoFilter(Makro2D| QueryTableRefreshBackgroundQuery DieseArbeitsmappe Tabelle1R Tabelle2S WorksheetWorkbookk Tabelle11 Makro3E|Columnsp9_Defaultjl)+-HK0* pHd VBAProject4@j = r RQI J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\@10\MSO.DLL# 10.0 Ob Libra,ryK"Modul1GMdu12NHB1Bo`B,Q!B+BDieseArbeitsmappeG"iQsArbizsmap@e$&2O,-O,-q)#E,&TabelleHA;$'l I22G2D22 0K*s__SRP_0 .__SRP_1PROJECTwmPROJECTrU~~~~~~~m Axm@JByӋ a p   ! )Modul1DieseArbeitsmappeTabelle1Tabelle2 VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA a 0F4C:\Program Files\Microsoft Office\Office10\EXCEL.EXEExcel Y@0FC:\WINDOWS\System32\stdole2.tlbstdole iPL-[DR?C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLLOffice a`Makro1Makro2  A:CFFAutoFilter A1(DF rU 6Makro am 07.03.2008 von Thomas Harmening aufgezeichnet 14bModul1Modul1DieseArbeitsmappeDieseArbeitsmappeTabelle1Tabelle1Tabelle2Tabelle2ID="{B75A241A-5440-43DD-84E9-37B7E95276CF}" Module=Modul1 Document=DieseArbeitsmappe/&H00000000 Document=Tabelle1/&H00000000 Document=Tabelle2/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="2527F2C212FA16FA16FA16FA16" DPB="6163B63BB73BB73B" GC="9D9F4A4ABA87BB87BB78" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Modul1=110, 110, 883, 520, Z DieseArbeitsmappe=0, 0, 0, 0, C Tabelle1=0, 0, 0, 0, C Tabelle2=0, 0, 0, 0, C Oh+'0@HTp Thomas HarmeningMicrosoft Excel@5@1܏՜.+,0@ PSummaryInformation(DocumentSummaryInformation8pCompObjiXd lt|   AntwortenEigene beitrgeGAntworten!ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBVO'Eigene beitrge'!ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBVIAntworten!ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV_1Q'Eigene beitrge'!ubbmisc.cgi?action_getbio_ViewNTopics_ALL_UserName_charlieBV_1 ArbeitsbltterBenannte Bereiche FMicrosoft Excel-ArbeitsblattBiff8Excel.Sheet.89q