ࡱ > %` =A bjbj 4D ̟ ̟ * + + + 8 J+ 4 ~+ D * + + ( , , , - - - e $ W h 8 9 - - - - - 8 , , q / / / - X , , e / - e / /
, + 0 + w- 0 b ! D 0 O . O + O < - - / - - - - - 8 8 / X - - - - - - - * * * d * * * * * * VBA = Visual Basic for Applications
= programming language
= accessible from all major Microsoft Office applications
Macro = set of instructions telling the MS Office application which commands to execute
= program written in VBA
You can create a macro by:
writing the program yourself
or by recording some actions and letting MS Office write the program for you
This document contains a macro. Put your cursor here and try Alt+A
Examples of uses:
speeding up routine editing or formatting
inserting a table with specific size requirements
reorganizing data in an Excel spreadsheet
Shortcut key:
If you want to set up a shortcut for your macro, go to HYPERLINK "http://office.microsoft.com/en-us/word/HP051866641033.aspx?pid=CH060831551033" Keyboard shortcuts for Word to check if the one you want is already reserved.
Recording a macro in Word
To open the Record Macro window
(Tools (Macro (Record New Macro
Give the macro a meaningful name (no spaces etc.)
We will not assign the macro to a toolbar or a keyboard, so dont click either icon.
You can store the document as available to all documents, or just the current document.
Add to the description if appropriate.
(OK
Everything you do now is being recorded.
To stop recording
(Tools (Macro (Stop Recordingor use the macro control windownote: there are some things you cant record, for example selecting multiple table cells, so be prepared to delete the macro and try again.
Using/running a macro
(Tools (Macros (Macros (the name you gave the macro (Run
Deleting a macro
(Tools (Macros (Macros (the name you gave the macro (Delete
If you get a security warning
(Tools (Macro (Security In the security window, select a lower security.
Macros in Excel
Very similar to above. One difference is that you will be asked for a shortcut key. You can ignore this if you want many of the shortcuts are already used by MS Office applications.
some examples - there are also examples in the slides for VBA
if in Excel, you select cell C9 and type in =TODAY()
then the VBA macro code is Range("C9").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
if in Excel, you select cell F6 and type in =SUM(F2:F5)
then the VBA macro code is ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)"
if in Excel, you select cell F6 and type in =IF(SUM(D2:D5) 1 0 0 , " b i g " , " s m a l l " )
t h e n t h e V B A m a c r o c o d e i s
A c t i v e C e l l . F o r m u l a R 1 C 1 = " = I F ( S U M ( R [ - 4 ] C : R [ - 1 ] C ) 1 0 0 , " " b i g " " , " " s m a l l " " ) "
W o r k i n g w i t h V B A c o d e
( T o o l s ( M a c r o ( M a c r o s & ( t h e n a m e y o u g a v e t h e m a c r o ( E d i t
Y o u m a y n e e d t o o p e n t h e P r o j e c t a n d P r operties windows
(View (Project Explorer
(View (Properties Window
Stepping through VB code
Reduce the VBA window so that you can see whats happening in the Word or Excel document.
(View (Toolbars (Debug
(anywhere in the code window to select the macro you are testing
(Step Into icon
As you keep clicking the Step Into icon, you can see each statement of code being executed and what the result is in your document
Absolute vs Relative references
The default is absolute reference what happens does not depend on where you cursor is when you run the macro, and the results are always in the same place. To code relative references,
(Relative Reference icon in the recording toolbar.
Create a macro from scratch
In the VBA editor (Insert (Module
Type in the full subroutine.
________________________________________________________________________
Words of advice
- dont work on two spreadsheets at the same time you may accidentally change code for one spreadsheet when you meant to have it apply to the other one
- save often, esp. after you have got something working and before you start on the next step and use Save As so that you can go back to previous versions if you get into trouble for example if your first file is called A01Test.xls then at 1:30pm you Save As A01Test1330.doc, then an hour later as A01Test1435.doc, etc.
Finding and using some good macros
- there are lots of examples on the internet, just Google vba macro examples
- copy the code (from the Sub down to the End Sub statements) into your clipboard
- in your Excel spreadsheet: ( Tools ( Macro ( Visual Basic Editor
- in VBA: ( Insert ( Module to open a new blank module window
- paste the code into the module
- ( View ( Project Explorer
- ( View ( Properties Window
- in the Project window, select the new module
- in the Properties window, change the name to something meaningful
[optional:
- in Excel: ( Tools ( Macro ( Macros
- select your new macro, ( Options and enter a shortcut key]
- to run the macro in Excel: ( Alt+F8 ( your macro name ( Run
Create a Form to capture input
a form can be triggered from a command button (as above) or from a macro that has the statement UserForm1.Show in its subroutine
in your Excel spreadsheet: ( Tools ( Macro ( Visual Basic Editor
in VBA: ( Insert ( UserForm1 to open a new blank form
( View ( Project Explorer
( View ( Properties Window
select command buttons, text boxes and labels from the Commands Toolbox
functions in Excel and VBA
(1) get the function working in Excel first
(2) copy the formula to your clipboard and paste it into an unused cell, but prefix it with a space so that its text and visible to be copied
(3) create a macro for the same function, using the record macro feature, carefully typing in the formula you see on the screen
(4) look at the macro code to see what was created
(5) now you know how to program it!
Add a command button to your spreadsheet
- do this only AFTER you have created and tested the form that will appear when you click the button, and given the form a name
- do this only if you dont mind the button showing all the time (incl. in hardcopy)
- in Excel: ( View ( Toolbars (Control Toolbox
- in the control toolbox: add a command button
- right( on the new command button ( Properties
- in the properties window: change the name and the caption
- right( on the new command button again ( Edit Code
- in the new subroutine, enter UserForm1.Show (use your own form name of course)
- in the control toolbox: ( s N
O
^
A B C D ^ _ 0
Ҿڷ⨤ j
h Uh h 6h h 6 j hx; h h h h 5 h h> h) h) h) h) 0J j hcDY Uj h) Uh) hJ
h& h h hw$ h h& >* h h& 2 % = y z $ s %
O
P
^
B C D ^
&d P gd> ^gd) gdJ
& F. gd gdw$
& F-
^gd& ^gd& gd& @ G H R S n q r z d ®®® hTB hJ
5h hJ
5 hTB 5hJ
h hJ
h> h> hSY 5h> h> 5 j hx; hSY hSY 5 h 6hSY hSY 6hSY h` 6 h hSY jZ hSY UhSY h h 7
:
;
<
# 4 y z z z `gdw$ gdSY V kd/c $$If l 0 $ L
t 6 4 4
l a ytSY $$If a$gd $ $If ^ `a$gdSY
D r O P ( l 0
&d P gd) |]|gdw$ gdw$ gdSY gdJ
&d P gdJ
_ O ~ & ( j 0 2 B D R T h j + , 3 4 H a ) üммим hy| hD6 hD6 6 j hx; 6hD6 hD6 hD6 5hSY hTB 6hTB j hx; h) h) 5 hD6 5h) hJ
hx; 5 hw$ 5hx; h^q hw$ hI hw$ h^q hw$ 5hw$ 8 + F G H a * * + t u gdUq
&d P gdcDY
&d P gdy|
&d P gdD6 gdSY ) * m w * + t u ` b C D K L S T v w $ % , L ѽѮѧѧѧѧѧѧѧѧѧѧѧѧѧѧѧѧџ hbT hUq 5 j hUq h0 hUq h0 hUq 5 hUq 5hN& hUq 5 hqW hUq hUq hw$ hco" hcDY hcDY 5 j hx; hcDY hy| hy| 5hy| hS > ` a b & i 5 y * + , L K e ^gdx; ^gdUq
&d P gdw$ gdUq $ % K L R S e f l m x | $ % ! O! P! r! s! ! ! @ @ @ @ @ @ @ @ @ @ A A $A %A ۶
hx; 0J j hx; 0J Uhx; hg j hg UU j hGEJ hPY2 hGEJ hGEJ 5hPY2 hGEJ 5hGEJ hjt hUq 5 hUq 5 j hUq hUq hD hUq 5 >e S w x y z { | % z ! L^ `LgdGEJ gdGEJ
&d P gdGEJ h^h`gdx; gdUq
&d P gdw$ ^gdx; ! H! ~! ! @ @ @ @ @ @ @ @ @ @ 9A :A ;A { ?E/ E=@ h Y }~ ^ dz,>{ ?E/ E=@ h Y }~ ^ dz,>{ ?E/ E=@ h Y }~ ^ dz,>{ ?E/ E=@ h Y }~ ^ dz,>{ ?E/ E=@ h Y }~ +:H @Om?sYU :0ԕj
vOj_PF ۻ qkjaiƧ"tQ2Gj:(p]XPH n#$3zֿJPqW~Ey>zK=-tCt{z ~B^{8
^X!L A5h跶rXOR_DBڌF G0ޙ;FAysZwj\D4讣ZMmLc% *F@8Xu
wBKfP`$UQ ;-m8.|W Do?زJ9? zq`x}(؏ /؏ b>\Gҋ}Qp J.#E>}(؏ b>\Gҋ}Qp p p p p p p p p p p p J.O: όm/wwe 1L[&I{t%A%#Aȗ+WF$[rOXiF^ײN m ]"v#gVN< Ob joC/Z 35: 3Ѵ=CvwX,# d լao6'̋iBs)^[!Pi\e[>ka: ׆QdV4Df B
炣nh%6pu 7L0pyx<II$±^rL+vf1 "EX(9 b%
Y%qDΗɄrHVݩf%W#{3})EIbhmۅHl=(m K4t5b@Ï>o =# ٭ Т`5\, f B ?Qp}zG }
.[ H Ek (X>o =# ٭ Т`5\, f BH Eh?Т`4 ?Qp} (X>\, fzG }
.A =# ٠ BH Eh?Т`4 ?Qp} (Xמd #"m@5\ѱӅU9l54I-eΒ5aIO
8NIZ{L7WBij_d#hR##:zJ$U0Қj OˋOD`eTpP jռz+|?c
ϚLQ[hE#ݶ8
/; TUO3 / G3 n?*_*f; TU , v?ݸ 9X?q R Ts0a v a`ñK Qcۏ
/ G3 n?*_*f; TU , v?ݸ 9X?q R Ts0a v a`ñK Qcۏ
/ G3 n?*_*f; TU , v?ݸ 9X?q R Ts0a v a`ñK Qcۏ
/ G3 n?*_*f; TU , v?ݸ 9X?q R Ts0a v a`ñK Qcۏ
/ G3 n?*_*f; TU , v?ݸ 9X?q R Ts0a v a`ñK Qcۏ
/ G3 n?*_*f3ull2EpgpG٥=*lE ǃo Tqߏ]+U%/nΛc0i#]2|q5 oǩR_[=+KeLrS9^qz OhgͱZ+`[(=s$c =>{,ofm d0*r-5*k=N
mS #sހ @ۿ4ϱO> c;7g:'}kJMN-%0Jg@
`Ƞ ή.a >lcn]q~eqZ
(
(
(
(
(
(
(
(
(ſ,QxK<%n5K j֒ MR'M&ѱa A# ː!` zO\o hau-ukyE(Dd'!N @i4[Wk.bDvHa`$SG\0 փit}= I@ | |7}[mn-;Ŝ. ,L.d)fS:GH`.V"Xu;!"BCʠn ?VK&XdNˎko6Hc zr/@ ITh4yȳXTYVM#̧Pz P@ P@ P@ P@ P@ P@ P@ P@ P'ݸ Y꣸0x7 KhZkV1;%0mͅ=Cb/XhF[ uۗ
ʮ=CqϽ%4:oc$2,. "H@vXqwcRNn⸵v v +( ,,}c6Uky|KOۣ3h;*
I= XTK/[7v 6ssn'#:?¼D\2@9|?=:\
wX.k7EU[| 7p (u}jiN|3YG\,u { P@ P@ P@ P@ P@ P@ P@ P@ P@u7t F-4'_n?z <%
Dn\䭼N3}jl"[ " ڷ_ ?E պ 8 ( E{.Gq[J¼e`)0 EV| ڷ_ ?E պ 8 ( E?n ,u >p Q`[ " jϜ? XV| ڷ_ ?E պ 8 ( E?n ,u >p Q`[ " jϜ? XV| ڷ_ ?E պ 8 ( E?n ,u >p Q`[ " jϜ? XV| ڷ_ ?E պ 8 ( E?n ,u >p Q`[ " jϜ? XV| ڷ_ ?E պ 8 ( E%F,&'`zm # ſ,Ql<%
Dk}}Ϗ<'x߳8ݷ3h/=..e~[KR1,nαF\ ~SqjͭĚ Ha@ PZ dE p#OWWC
(
(
(
(
(
(
(
(
ox/ K=Tw v I`[3|[gW>?/CϚ ۳n7cz=ז+s|] #9mmԁ>4~J 9(" =ӽ21?gάK[>=W7+ &Z~D\7Z,?ow~l* Ӌv} :om5vi0j--&[hća;X|Ғ#".jI$>tmw[++u%7=o [KLR4" wYS|2zk:qҾN;E'7k^]^=<ֿh+74eqFXiCߞpz٧}bwoH٫z[*vnREA& kWi^ Ym8ݻ8.WhY kn'}=m ,E7tmNZ ?.wkYkkkuöMIJb5ۛ4ri;&e_8|Ƙ8ҡ8{(vR.z;¤ewց]}` 7ߏ7/uecnmv 7~wױr%t Q\F| ~K yO =( {/P?_'@ O) 缟 S y?%
< ~K yO =( {/P?_'@ O) 缟 S y?%
< ~K yO =( {/P?_'@ O) 缟 S y?%
< ~K yO =( {/P?_'@ O) 缟 (!b(#ſ,QxK<%n۩cy1i qBrQʽ|%SѮ
$D =y55^.єJji wo'~ʧkO xwo'+{Z̾ ÿ )?ƏeS_ecLԝN-nXC*P~%b8eꒂ
(
(
(
( [L[D8/+Qi6ڊ3+t
OU?{Z̾ ÿ )?ƏeS_ ֟/?,t
OTW0 } g; R ʧ'״6:̤d$3>ԸJ*4RefIA@ P@ P@ P@- v Ig_ ,KpFH45C MAhlmGjUw SefhaO-aTA%68R[FU I,@2̠t:Va&+~= P@ P@ PNwg}%o/%m&VPMCQv+i/p2~s̟7$@t}jVoM$w)kwJ2 YJ:?}Ge_?j6 vPq4}BmS
(
(8 1>mc?U^9-GZ]Ky>A%'
У,NpON0 6YF_TpI''⸗bͧo)m ;J\dH6 &F&~8G3[-^4Hm(w%Bd7h`vGSXܪ,ׇLP dZޞ '3*|,|k7Oc-klg Cm
1 Ǵ UY]\wtn+dpY$e1dV:-yt=>jZy;%k10CǖRv@X o֟ڿ۾m// Og@#RdVcE%q[]I|34kRi cm}
%C`<i~AXͼmƥp } P@ P@ P@ fHqC%?:ڵWG kCBO&ÝFSF fٿn {V/sCҬUG:I tP+>q
.6ei{q Lbfw9̔aO.g6/oMԬ 5;3iQ
tz
Ã?I O2~hkS*tZ]\Ii``d
bH."IJI ]H # I@ P@ P@ _n?z <%
Dmԁ{,vutm.ym) yq
m 8 #&ewnqWo^vwfŃm2x QWuE2 BtO +{E2D}'e<#ضo7m&33{}=YONK/i;eñ#.FG]ރ/?7꺆!+K[i U L7&AJO7撷O7(
(
(
( 1s5m%¶[H]`v$ݑ+ZvfsJ^k~ҵ%bI,v /,q4Beb3N/hF+ -{ K ȴ?h/+x "_EخAG CE$
:ˡ*GBh+{E3Ķ:.ڄ&!c~ZEc\E]5ӯUĹshn1P@ P@ P@ P'ݸ Y꣸0x7 KR@ P@ P@ P@ P@ P@ P@ P@ P@ P@ P@ bx<ۏ%; ǃo Q-u P@ P@ P@ P@ P@ P@ P@ P@ P@ P@ P'ݸ Y꣸0x7 KxTִukBE~e
yW I`a#3+l!@GxUuPjj҉b[xc! 3$\Ec_ /^ΘIEmBm>κړH@ P@ P@ P@ P@ P@ P@ P@ P@- v Ig_ ,KpFW#R3]s H{ ˔īVY7*%iry'R$UFk3&I)'2Yn 3 0H\9+ayheIM2,@屖m1$9M Ù>6M^xl_NDgL<Ӟu\9 ӽ < w Y9_Ù N / G+s e hd ;,M ã { L9y y 4r2??_&W0A ӽ < w Y9_Ù N / G+s e hd ;,M ã { L9y y 4r2??_&W0A ӽ < w Y9_Ù N / G+s e hd ;,M ã { L9y y 4r2??_&W0A ӽ < w Y9_Ù N / G+s e hd ;,M ã { L9y y 4r2%<" %d ܝr2+ lX G /r0B6`zf_OsTox/ K=(S ǃo Q-:?翸Y y c@H*v w=cB4fTE%eG%}ݣu ծN
^QxYk2i:;V6XcvA*\;9ڊǁI.G^ZǪؽB{hV EYp @^IgkuDp&*Cb787.oqy6)H[F2F9cg %tx>j1 ic[}8Ǘϝ?xz;6ǩ^Oquikv7Fi#*۪ʹ}ˏ0o%Y æxś^2~'lK
(]0F-SrE}9f`v[' /%P=kZNJ O4Au ;+ L0H젖`6q@4
XD 1\ YİE?xzqVh|,ſ,ܶ v I`[6-e^q$nbC_J[2_j ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻۵?g ഻^K[/qlC$
A|ο 2 W2q7˨2p3{ PBNj#ox/ K=Lw-ݷ X(477,X^ZKH&%I {F,e Ug,ִ~jvoٱqPk
W_1KV)i r@' |IõR[(!$yFAa7.@#>)E6ΚmgY+#V0~zPrP;VA9X$ppH-3}6y!GXW8Qy>4
(
(
(
(
(
(
(
(
ox/ K=Tw v I`[9xIJ,`et٤ 8!H x2ikXn͝[[v[`sn~`
'K״B;ˉ9 _%TWvGBm#ϖV MCL JHb,$F|$.aH
Uƻ"ٛd;7Kd,l˰*dm Q|#e#ٽe}nQf Xoj:Ok
m9+,w dǘ=@ P@ P@ P@ P@ P@ P@ P@ P@ _n?z <%
Dk G{hn_< ݱH``gf?gɒ'_FAQq?n E?n E?n E?n E?n E?n Eaik@Y72F ;Pav)ٕ8⋀]ZZOi
ƣr^JamCVҋ 2}Rf.!?esqcku>\ ɤ aͭǭd1UZ2cmok)AE ! 4\
EX%;WnO )4\ N[mJa<Αs*$ zp# g_gd7ۗ\/̿:8Hu%jS Ft{T
POm': C hD. cx-GǙKeٜ;ApqCE_ MZاWeH$̑
>ݨ~^Lr.u ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ pu ۟ p+j亝tX&,裱1 - v Iga/om
%"=WF5]&}=6]YZjܸ"8ͻFº f@;0FL=ދ ڮobژE YY.Ym 9 fi3|m \Ρ><@$Gߧhc1Rۖ "Y| ?pv㍔]N[{kru`.g voDB 5{[˯h./ⴹuE$%d#@$ u >gfhՅlc|^$f}/)0|@| # -mnFvO . mu8ϴ7Wb"yجK D~)s e A q\:uT^M3-A(mnvx f@:zCŬv3-ɳɺX $ X5{ K4 $K!iPTW)Wԍg{
ߟ\^ܦoIy$V0h WTF7 7x4mG tQe*,,{lUR6M6~~q{r%Z ";x~\Q#`ŬSf} 7Zy`k0Elo#e
(\g>h@ҢfLœ# y]vyJ(!`
,.> xG
ԚW[c"F Ev1rN ;?>.M&]et=f
EDS9U떍! 1 .IRL1![yZ9 [d" z@~!Qz]W-k&X4A'IIoedk:݇76J{S3$]ĊLn|).{-E,=Di厡q" ˢeCx;6D&p) 垩Zj> ;58|E&:nڳ yㄉkjm>$i6JD~hhm{ț6-ͨ[{=1vk&YFhZM,Oacs9;D!F qZkv֖Vgju, rf 0x踠/ ӌ0k7_crڶmՖBs WR` umb;=Z\}&~Lo -M[{7tl` z۽ZZq˱gH Xd_+I)@ G~ګEi/O4nA ];F ; (
(
( (oZhOſ,qxK<%n4//t F5C^@ P@ P@A
VGHB(
8 I@A
VGHB(
8 I@ Cp;u +Vb (
(
(
(
(
(
9_1i9? ǂ q pa/om
%#п _ z P@ P@ P@ P@ P@ P@ P@ P@ P@ P@u7t F-4'_n?z <%
DtZ^oki櫬.zjkb' =: ξa -oHӧ /G ' O ӧ G :
X =:9 dx -?~m N G ' O ӧ G :4BTcO&Q;Gmڜ*pqi_V@qm[̇ſ,w v I`[6@(
(
(
(
(
( }lּ4&A cWx =Mej oOSG(}N>5>{mV @2~`]PP$Vs^G]F,&C d_0~eLb> m@>ޞ(4rjr|q. h¶_^Oԃn ?1 rTv7,ה}W措< * F~Er%RzG)cEXGS[K[xof(R9H4H[r
Iª(3 ZBtvVn(>R[BbO>ekIX|T! VN>l+Ş.o/. zDR1hwHIbwe`=CIU' sD't Oq\vs nF_ʾ- v IgC ǃo Q-u P@ P@ P@ P@ P@ P/WmeϽC.˱ׁߖ ;fRvd[3;{ ?7 ]W ?{ ?7 G _ I E W ?{i+ȫ&Z iRQy6́ 3z_ZT2cLlnqp{d;m/ Mw @
k }^A (/K_A 5 5 Qz_gL)9{GeB O'u VX?T< nto<%{qy*] W< c$wd ? !My-^K|. wm[;[> o u ; ^$gYy\4v ms{|w W亹Wqwc^h /, ` . ~?EI & X: \? i "c . ~?DvZ:iYH6D.N\p=a㈖"UCr̥U%O}o]-Է_n?zcZ~x` .n9GKfF iKPbЎ<]H2z'J.OAywmSv\a,Hns֩";o?
.iW~'l 9#J2'G[cF9|G Ra { O*[ԏԺ!AtaF ՍaSJ+ˣ7(ݖ|SK7Wp?$AJX Z-5R :phy\[kh.,ŸpO3OYRDwͰukmGK-%c^}oB[?( qƼ6*U*83Fg\e{Wy ?O 1TZ]}U;+[]/A5k8u7v{Vg g'O:i$N-m?i5̳Lff⪽
+:%V\̨AAY5m+9-/ŴLnMszQ*o;(+1^} zO`px zRr)E-eܵō3 ,q2N?
!OV6^[s:3
m◌9Ϥ٬mq}۹C Y <<ʧƏH5=UKy#^Jv+wFA XWLRqD/ ? O n_ H ?&T =! x 9P h@ ۗ \ KGЁ} ÿ |=
WYѾ}q̗S&Tp @W-Oٜ $$If !v h5 5L#v #vL:V l
t 0 6 , 5 5LytSY @ @ @ N o r m a l CJ _HaJ mH sH tH l @ l )?D H e a d i n g 1 ! $ < -D @& M
5CJ KH OJ QJ \^J aJ D A@ D D e f a u l t P a r a g r a p h F o n t R i@ R T a b l e N o r m a l 4
l 4 a ( k@ ( N o L i s t < O < E m p h a s i s R e d 5\ph < O < J e m p h a s i s r e d 5\ph 4 @ 4 H e a d e r
! 4 @ "4 F o o t e r
! . )@ 1. P a g e N u m b e r H BH Q- B a l l o o n T e x t CJ OJ QJ ^J aJ j @ Sj
T a b l e G r i d 7 :V 0 6 U@ a6 ) H y p e r l i n k >*B*ph D % = y z $ s % O P ^ B C D ^ _ 0 : ; < # 4 y z D r O P
$
e
G c : ; < \
L
M
S
o
` 8 Y u 7 v [ T U V q , 1 5 e
] 0 0 0 0 0 0 0 - 0 - 0 0 0 . 0 . 0 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 0 @ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 @ 0 0 @ 0 X 0 0 @ 0 X 0 0 @ 0 X 0 0 @ 0 X 0 0 @ 0 @ 0 @ 0 X 0 0 ( % = y z $ s % O P ^ B C D ^ _ 0 : ; < # 4 y z D r O P
$
e
G c : ; < \
L
M
S
o
` 8 Y u 7 v [ T U V q , 1 5 e
] 0 0 0 0 0 0 0 - 0 - 0 K 0 0 0 . 0 . 0 X 0 0 % X 0 0 % X 0 0 % . 0 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0 0 0 K 0 0 I 0 0
I 00 @ 0 P I 00 I 00 I 00 I 0 0
I 00 K 00 I 0 0
K 0 0
@ 0 0 0 0 0 0 0 0 0 X 090 L X 090 L X 090 L Z 090 L Z 090 L Z 090 L X 090 L X 090 L X 090 L X 090 L X 090 L Z 090 K X 090 I I 0 0 X 090 Z 090 Z 090 K 0 0 K 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 K 00 K 00 @ 0 I 00 @ 0 K 00 K 00 @ 0 @ 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 I 0 0 K 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 I 00 0
) %A =A ! ^
e ! =A
P L:" g B b
Lp(y 9 -
N sk s082 vW|" ?M? s ( v !T; Qc fw$b\ H8$ !&W *d 4- 4/I =5 R E94
O:V X-1Α mV2 ypg1 jpUr{T Z[u`Ƽ| ob}M ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " h ^`OJ QJ o( h H h ^`OJ QJ ^J o( h H o h p p^p`OJ QJ o( h H h @ @ ^@ `OJ QJ o( h H h ^`OJ QJ ^J o( h H o h ^`OJ QJ o( h H h ^`OJ QJ o( h H h ^`OJ QJ ^J o( h H o h P P^P`OJ QJ o( h H ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " h ^`OJ QJ o( h H h ^`OJ QJ ^J o( h H o h p p^p`OJ QJ o( h H h @ @ ^@ `OJ QJ o( h H h ^`OJ QJ ^J o( h H o h ^`OJ QJ o( h H h ^`OJ QJ o( h H h ^`OJ QJ ^J o( h H o h P P^P`OJ QJ o( h H ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " p p^p`OJ QJ o( " @ @ ^@ `OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " ^`OJ QJ o( " P P^P`OJ QJ o( " . SN
g X-< b
vW| m F B }^ 9 -
H8$ yp O: s0 s jpUr x(ee U] T= IS 4/ ;(9R !& E9 P !fc fw$ UX m L ;i u\ S][ ? 4- * s !@l Pf fYl =5 Z[u gR ob} "= !T; . . L~
+ʔ`\l,bسxi Ԝ Vb lJͬ
3^.wNKb *[0*lTZ]f #^K7X2 PL"PZ ڏ F~ x{ XQdP 2_ pXVH
R<СhO" DZڡ& d^RRB ^ܓjWb N.1:k VJjtdrR:PƤz a֨) `s >x1D]@y_4*z(x0e NXtdZbuz[ t^*6_FC $1rTί8
.ȇhtj>`xcd:t z 9J}|RҼ(^:j: $"ԬCZ x6\3^8&R~ k` 0İh
,ɴ(tDZJl,
vN` jꃨP%DʈjpU4 <Vԙ|4\MX@aVi YHZ۲Dn\! RT뤑7 v?j°^ T|PۘD~T&=
8d\`DņRD\b,LM xȮf>*{ >Xn
ZJ@bP
J|;x_ܕY̖n~_Ě Pp *"C&fwX2{ 䆕Rf!©p)H.Z6~nbw &zx BU
df hh x$D*np0<: ,f %lnrΨna@62( ,^ F$~x<-lU.t"sʪ>yشޜ UXeq:J̴HtL֠sʎ R`LKDs4
V*\ʭ{|"foys 3ޓ⊠ h,{&d,^
5 ^{ \ʪ"^T|O6肎 bl0 0' , 2wF vT` Fzi xaw g D6g jFPFzi Od9;{ rs m kS] 7\ i
J"E%. [ oQI w ?T.8y d6}x Q i &\u l/6d ^OE%. Qt_7Q !g 3t_7Q 9 w {o} +^<% #oQI 0 7m#T ]vV~ j DO m ~T` M 6U_ j zRzD C(w g aJrs !Ye z} j5h 2Fzi R0|rI. ~
(~ UJ cbl/6d jg T bZ
z f c e %It Xb i ` Sa o] c ^` ]$ m#T
rI. M
T` \ i
4 s
} t
R< <
c m
kLs E
UJ M
R< P
n
(~ w y* z rF w g c nw4 )zB UJ ?y 1
m#T o ~;u ~\m
xxN 93z *>0L .K:<% hgoQI XeS] 03nw4 Df r:5v b"t A E 0 ![rs !
J>0 R vV~ . i ]'c .8y T*~; mN v{M T /05h cw g T ~:MB voQI y w oQI Fh\ i
:MB m
t_7Q 9;boQI j ]E c a & 5rs SK&N X<% )7'
= j) G R< TS r 1 \u } Df R NZ T` eS] r$ UJ K "t @| BQ ? B| } Y E%. g w o ', eS] B UJ 76 e \u T0L t+ T.4+u [ =+
= iy+m#T p+e A+
(~ 3g+AK'i -,eS] B,A \,m#T h, U- Y]-eS] Vs-eS] |b-Hd ?-j [!.
(~ E%.][ bH.c C/ax /e /(t I/ 0jg J>0G YE ; 0c F0"fz M0nw4 |0rs QK1
M\1R9_ Y8_1 bu1rs FO1 mN OF2eS] e2<% Bw20L 4 j4"fz nw4e` ?U4"fz H94z ml4A 64g 5eS] U)5 < 5}0f
- 6 #i6 36~y 46T` c26M A6c s[6oQI ;C7A Dz7Sa D7m#T :7g H7 8}0f
\J8>0L 8r &t8t_7Q XE9AK'i Mp9p|"A Zq9vSv |9=k| w)9 i 9vV~ ?W9\ i
%.9 %9uP_
9Fzi i[ :.8y u:UsG %k^:UJ Aj: w , :A 4@C; 'k;Sa N?|;Sa /;Fzi *~; ;"t DK<z >U<&N wx<\ i
R<3(g <7QY Hj=oQI $="t \=E%. Q=hvfQ
=0(
=T` )q0>9;{ RC>R9_ zx_>UJ q > BQ ?Y-u f&?Sa &yO?e
)? u @
O C qx@ax @m#T b@ i !V@g @"t H@eS] $AoQI ]M
Aw g p|"Az6
AT b^A i A} :MB UUz
wB0LY8_1 ;1Ll/6d s9LSa HL#m ^Lj \LSa 9M [MiW N"Ml/6d P!gMrI. Me JMg rM~y +qM(t EMAK'i M&N tMeS] ",N'+% CNzD xNP
2N CN5h vNE%. mNR &O
O C RxP"t pPm#T jPrs P\u ,P(t BP'+% 6%PSa t_7Q, hvfQ0yc" ,Qe @Qax Q\ i
+R
O C ?R 8 eRm#T !R"D "3S|9 3eS 8sS}0f
0S
= `pSoQI RS\u ^S"t 4 S
(~ n.1Tw g 5jbTe >toTw g 1qTeS] k T ZTe LT} m#TTS zTw g AKU'+% C/U"fz b.Urs {UvV~ FxUax .Um#T ,FV EAVUJ %BvVrI. Vg ? V9;{ ]Vm#T Xr
W.8y akWHd iWI" *KWoQI %"WA QWl/6d > Xe ROX zXoQI WdX i XBQ ? *.Xg e YSa 5Y 8Y:MB )JNYuP_ qYUJ Y|9 Y Ym#T T[ lq 9l'+% (Plrs Bl:5v am
= kmT` #m Am:MB nmu [ m|9 Xm i QR n5h On .gnc 2Ckn
~7nn
pnT` 7tn %~nR<
n
O C W2nT \nq nUJ -hors {o\ i
RoUJ o
<pM PHpnw4 'Sp w qZpq w q~y 4qeS] .NqUJ qjg
Ggqc z>r yoQr(t %rBQ ? kLs `s<% $s &9s
(~ E 0 w Zs 6}xI/ ax7tn +&xax ~QxeS] +sTx} {kxR9_ xeS] pFx9;{ mx}0f
KN yjg ?
yAK'i E& yt_7Q '1y|9 d3y mN .8y ^Ys ~ySuf kyoQI Xcz t'!zE%. UUz zOn "fz5Y F-{oQI FM{q > iV{m#T { w 6{ w T{m#T U{l/6d 9;{o n+{\ i
0 | DO|9;{ zT|rs =k| (R|w g [b|m#T o|T` y&}Fzi E}Hd An}c umv}A X}'+% @}|9 ,%~c
(~z>r vV~'jWf V~|9 I~m
q$~ w &\'#m &Nk T ?y J?\ i
I H 1J J W
J
w
Q- D6 M y| MR co" j$ m% x; @? 7@ )?D E GEJ zJ s Ws %x f> & L} I1 Un ] PX > > *V / ` l . Uy X E d ) &{ SY g } S 5P t. - j@ x w$ @ TB S ^ : ; < V 4D P r o j e c t . N e w M a c r o s . d e l e t e T H I S T O O P R O J E C T . N E W M A C R O S . D E L E T E T H I S T O O @ e e C* e e 4
y @ @ @ @ ( @ @ @ U n k n o w n G z T i m e s N e w R o m a n 5 S y m b o l 3& z A r i a l ; W i n g d i n g s 5& z a T a h o m a 7& V e r d a n a ?5 z C o u r i e r N e w " 1 h F&tF M - M - # 8 4 d 2Q HX 0 *V 2 l e c t u r e o u t l i n e K e r s t i W a i n - B a n t i n K e r s t i W a i n - B a n t i n .
! " # $ % & ' ( ) * + , - Oh +'0 $ 0
P \ h
t lecture outline Kersti Wain-Bantin Normal Kersti Wain-Bantin 11 Microsoft Office Word @ H @ v #@ +@ M ՜. +,D ՜. +,P h p
University of Toronto - ' lecture outline Title 8 @ _PID_HLINKS A R
N h t t p : / / o f f i c e . m i c r o s o f t . c o m / e n - u s / w o r d / H P 0 5 1 8 6 6 6 4 1 0 3 3 . a s p x ? p i d = C H 0 6 0 8 3 1 5 5 1 0 3 3 ;
! " $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T 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 { | } ~ R o o t E n t r y F + @$ D a t a
# c 1 T a b l e U W o r d D o c u m e n t 4D S u m m a r y I n f o r m a t i o n ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 M a c r o s 00 V B A 00 d i r ; _ _ S R P _ 0
? _ _ S R P _ 1 _ _ S R P _ 2
T
" # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < > ? @ A B C D E F G H I J K L M N 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 { | } ~ 7 0* pH d ProjectQ ( @=
l qMI J<
rstdole>s t d o l eP
h %^ * \G{00020430- C
0046}# 2.0#0#C: \WINDOWS \system32\e2.tlb #OLE Automation ` ENormalENCr m aQF * \C
蠝I+ !OfficgO f i cg !G{2 DF8D04C- 5BFA-101@B-BDE5gAjAe42gg ram File s\CommonMicroso ft Share d\OFFICE 11\MSO.DLL#M 11 .0 Ob Library% "z (BeThisDo cumentG
Tfi s "DHc u@Ie nn 2 ( HB1BX B,!"B+B ^ NewMa>G N Xw M kc r %s 62 O ܀M N ! C K*y *\CNormalrU ~ ~ ~ ~ ~ ~o SICyF*ɥH
Q p )
yOjuN:DZj ThisDocument NewMacros Project F / C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL VBA
A 0 F 5 C:\Program Files\Microsoft Office\OFFICE11\MSWORD.OLB Word
9 @ 0 F C:\WINDOWS\system32\stdole2.tlb stdole
! I P L-[ DR ? C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL Office
1 `
deleteTHISTOO
R rU
. Macro recorded 6/24/2008 by Kersti Wain-Bantin Project.NewMacros.deleteTHISTOO^ rU ~| k rU $ _ _ S R P _ 3 o N e w M a c r o s ! T h i s D o c u m e n t = Y _ V B A _ P R O J E C T O
` a n < j (N x ME @ @ 6
- Wordk VBA Win16~ Win32 Mac VBA6# Project1
stdole` Project- ThisDocument< _Evaluate Normal Officeu Documentj Module1b NewMacrosj TryTableBordersk SelectionZ EndKey5 Unit wdStory& ActiveDocument\ Tables Addr Range NumRows
NumColumns} DefaultTableBehavior wdWord9TableBehavior AutoFitBehaviorm wdAutoFitFixed@` Stylep ApplyStyleHeadingRowsb ApplyStyleLastRow ApplyStyleFirstColumn$
ApplyStyleLastColumnb BordersC" wdBorderTopm LineStylew wdLineStyleNone wdBorderLeft wdBorderBottom
wdBorderRight wdBorderDiagonalDown^ wdBorderDiagonalUpj MoveRight wdCharacter Count0v MoveDown̝ wdLine MoveLeftv Columnsp9 SetWidthH ColumnWidth
RulerStylea wdAdjustNone~ Itemz
deleteTHISTOO{ TypeText Application* WindowState| wdWindowStateMaximizeU ` $ ID="{8A170304-01EC-4F99-B239-22CC0D29BDBB}"
Document=ThisDocument/&H00000000
Module=NewMacros
Name="Project"
HelpContextID="P R O J E C T P R O J E C T w m G C o m p O b j q 0"
VersionCompatible32="393222000"
CMG="5F5D8326BD5AD85ED85ED85ED85E"
DPB="7E7CA247DE79FC7AFC7AFC"
GC="9D9F41647F828082807D"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
[Workspace]
ThisDocument=0, 0, 0, 0, C
NewMacros=7, -17, 768, 483, C
ThisDocument T h i s D o c u m e n t NewMacros N e w M a c r o s
F Microsoft Office Word Document
MSWordDoc Word.Document.8 9q