ࡱ>   !"#$%&'()*+,-./0123456789:<=>?@AJCDEFGHI;KLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryFlMy@ Book  6_VBA_PROJECT 0N1x+y413034e440c  !"#%&'()*, \]\Xc ,,X AddinLongnamehvh |8$p H 6PhXH8,8 AddinAuthorhvh |X$p H 6Ph8HX,8AddinDescriptionhvh |X$p H 6Ph8HX,LD  lh8HX( l (A)%"1>|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#1}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#81*\Rffff*8f31222529Tt80  l ,MErE:@X0`:" VT"Z<@3--------------------------------------------------- SetupSummaryInfo) Called only at localization compile time3---------------------------------------------------DY  AddinLongname$ `( AddinAuthor$ `( AddinDescription$ `(DBkࡱ>3Oh+'0HPt 14b1468318Re34b1468bf0B3130c77b093830c891866,6>,,Localization Table$Xp$ 6^h4t,nt,x\A1:K100$t66>,xLA1:K100$t66,t vpN0N,tpN,x\t>,xLt,,vp0,,$Xp$6N,L ^TT tp\Llx(,(*z@(tx(zj,,Xp$\ 6LZ0vlN\<8,vl6L0,R\NL,vl6,vl<,LPj<HlL\,,x,Xp$h6H Xwind8( hH,winx,Xp$68 (macdHX h8,macx,Hd x8Hh,vh,:T,jhJxh,,4$D0Missing Localization Key  |($4, MISSINGx,,H, MISSINGx,4$T0 Missing Localization Table DJ|(,,h^z,Xp$X3"jX T WorksheethPTNX2,MustHaveSheetActiveTvTPT,<,,Xp$X"jX T RangehPTNX6,MustHaveRangeSelectionTvTPT,<,,h^z,<(TX H 4`x  X "C@@-   $ d,,l AlertTable\v\ $ ,b0p<|L( \L, ,Ltd  ,L\T,,0$,TRandomStringsTable,`,TJ|$$DLocalization Table$Xp$4 6^6hd4$, d@ndvd @T$D$Xp$6"nfdjhRN,vh,:T,jhJxh,,4$D0Missing Localization Key  |($4, MISSINGx,,H, MISSINGx,4$T0 Missing Localization Table DJ|(P$4,H,H hdx $4$,,Xp$l6\ LNl,jL <Next R,,f>*4,jL ,Back R<,h>*4,jL,Finish R<,j>*4^,jL,Cancel R<,d>*4,,jL ,Help R< ,l>*4,NL,LT$ L\l L\l(`ffH(dp$$"jD:TN('Xp$ 6> '!x,,h^z, f,`fdH(,dph$T$D"jDD:TND,T'Xp$D 64>$ h'!dp$$6 6$Xp$6*D4$,,d ,$Xp$/6N$,`ffHR,dp$$"jD:TN,'Xp$ 6>  @BLoadCursor@h) erSetCursortbrSetCursor RunVbaSetCursorGetVolumeInformationA@WNetGetConnectionA@WNetGetConnection:WNetGetConnection32WNetGetConnectionA )\91t:)|Re,,vH8HTMLDB1nH(HTMLDB2nH HTMLDB3-1nHHTMLDB4nHvHvvH&jL,vLvh",jhx,vx ,vh,winTP,Xp$ 6jvd`,td v`N0.,$t`6N,v`0,vd,,Xp$ 6jvd,td v`N0., $t`6N,v`0,td-v\N,6,tdnHTMLDB5 Rt\YD,,t\$t\N,tdnHTMLDB5 fN\,t\z$t\z,t\$t\.,,t\$t\,,v\,,vdF,,LZPPL`x\dh""H`l,,,$\HTMLPict$ d@Xp$l 6Lj6<6lL<,LPl<Ll,, d@Xp$d 6TjhtdT,DHTMLPict$ttTX@NT,D='Localization Table'!Td$t@Td,|D$ttT 6d4$t@4Td,|D$ttT 6d.$t@.Td,|D$ttT 6dl1$t@l1Td,|D$ttT 6d*$t@*Td,@,L<@xtTdR,l4 HTMLDB3-1T,\ HTMLPict3$tt<Z ,,\Localization Table$Xp$L 6<^h4tL<,\ HTMLDB3-1$Xp$< 6Ljhl,xLt,,vp0,vx,(winTP(, Courier New$ TextTable$< HTMLDB3-2$Xp$ 6j6'!dpT$h$6 6$4$Xp$D6*$4D,,H,^z6,,d ,Xp$/6N,,`fhHN,dp$$"jD:TN,'Xp$ 6> '!dpT$h$6 6$4$Xp$D6*$4D,,dH,^z6,,d ,Xp$/6N,h,`fjHF,dp$$"jD:TN,'Xp$ 6> '!dpT$h$6 6$4$Xp$D6*$4D,,  DontFinishh ,j ,,Xp$/6N,,8,^z,,<x,,$4D(H( MISSINGx(4$T0 Missing Localization,,h^z,h^x,dH ,h^z,H ,h^x,`xrH$ hNext$ X-6NX,`zrh$ HBack$ X-6NX,`x:Trh$HFinish$ X-6NX,L4 XP` @(0^z(d(< X t((` @T *X.X6(MustHaveRangeSelectionTvTPT(<((h^z(<,,,z,<~,,dpd$T$D64tD4,vtd@Xp$4 6Djhx4D,JH~ tx4D,,X$Xp$h6Nh,X$Xp$h6 Nh,X$H$ hh8Nh, h68 h8,d ,d ,FirstRun<,T,b ,,P8 , 8nH HTMLDB3-1 RhN8,H Choice1OB$L68N6hX R(8hL,H HTMLDB3-1$Xp$( 68jh8 (8J,,H HTMLDB3-2$Xp$( 68jh8 (8,,, H,dpH$X$("j(D:TN(,H'Xp$( 68>h X'!dp$$6 6$Xp$6*(8h,, ,b\,z,`zjH,@,<,$Xp$6N,$Xp$6N,$Xp$6N,<,,(8h$(@ (`L~X `$l`,``4H`VH`T6$,408D(0 <P@ p A b8)%"1>|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#c}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#59w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#8w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#0w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#6w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#5*\Rffff*9031222529*\Rffff*8f31222529|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#1}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#81|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#0}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#3b}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#31}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#10(   (>l 4\@BXLB4XBomdBlepBB( |,(RandomStringsTable~H(z&(d!(n!~  * l1 x Lt ht$,  l6p ` ~z t px  tH $8(0ZJTJ  T tlTxsT ^h ri jdTP $~d   0&l4, v4l 0P9 x 4 $3t0,0 p@, lP.\ Td,L 8 (7x Zt%\ xp0x@4 $3t 4p nlxN3 p043 t1" dx  3tT8 0&8d \( 8x h  dt0 `, \D8L (( 4@LX (Lptdt(*z@(tx(zHH(z HX(xNd( z   (&x4D`l$HXd1ME ^$b6~ H(0Z@l~P~`t~pX UlZWTz&&,&T|       B(, *4 &@.L&d t | j ,28 $HTHx H  ("@D8|    * & &B @ 8@TBX \d"h l x  66<B  ( "@0TDp    (  "@D,p     "  "@D P h l x  "   "@D4 L "P h p "t   " (   $ & &   $  , 0 ,4 ` ,t :  : B, 0 8 2@ X 2l\ d    .P      2^( \ ` :d  : " (^  : \ :x B  D .   @  2 < @  D L BP T 2b\ 2b   "  , ,   :$&`:r"8<DLT\d &lx   8 $"B,2,(D(\t(x 8 $   X&PP x > >  $     &" $&P,FT t  2: 2$"D 2X,x .*^(T  , .@*^X(T  " 80 (F 4< 4T 4l 4 "(f"< D P X d l8 $  8 $   $"B (02H,`,x,  ##################################CODE TO HANDLE THE DIALOG BOXESCO ##################################Y ##Y ##Y##Y(Y4Y@YLYXYdYpY Y Y$RandomStringsTableY Y omY sTY # ( (  ~%.> ~!!'''FirstRun'z&A@ '[ setup the panelcsince thers are two DB3, I use this trick to bring up the right one depending on the user's choice.de t. t !> HTMLDB3-1 Choice1OB %N! Z HTMLDB3-1 `%j.` HTMLDB3-2 `%j.DBggDB A@`" call panel-specific setup routine   >% $4 On Error Resume Next' `!>'!   >! % ! B@* On Error GoTo 0 gB@ run the panel B@ r   '* * EA@1fA@* " ( (  ("e Y@(  >% !'h h `%j.teL 'e Y'~' E'~f  E'f Next %( ~Back %(( Finish %(k'sh  GP   >% $4On Error Resume Next' `!>'!   >! % ! B@*On Error GoTo 0 gB@ ' B@ GP   >% $4On Error Resume Next' `!>'!   >! % ! B@*On Error GoTo 0 gB@  ' G`o  ' B@g GP   >% $4On Error Resume Next' `!>'!   >! % ! B@*On Error GoTo 0 gB@ ' G`o  ' B@g GP   >% $4On Error GoTo UserCancelOn' `!>'!   >! % ! B@*On Error GoTo 0 gB@ z& DontFinisho 'gz& B@niOA@'j e % NextGP A@BackGP A@FinishGPck A@CancelGPG A@HelpGP A@jklp%#####################################UTILITIES CODE%#####################################3----------------------------------------------------- LookupString3-----------------------------------------------------(YH--YX-- T$tE ~'Tf TT Localization Table `%^%.jza J j %'^ ^$ ^T '`^Missing Localization Key J A@JcaMISSING'grMISSING'Missing Localization Table TT  A@Jzaroneab3----------------------------------------------------- ErrorAlert--3-----------------------------------------------------t  AlertTable$   A@Jker3----------------------------------------------------- VerifyRangeSelection3-----------------------------------------------------' -- $ WorksheetMustHaveSheetActiveA@rgst $RangeMustHaveRangeSelectionA@rgst' nge'& !win~ Ewin'&f !mac~ Emac'&f--etDelete HiddenNamesY-- v4 `!Z0-- v4!0E v4B@f v4oskep3----------------------------------------------------- OpenDependOS and CloseDependOSng3---------------------------------------------------e l Depending the OS,we change the font, the size and copy in HTMLDB1 a picture with the correct font and size.Y$Y4YDYTY`Yl (( General infoin &winArial'.''d,`d,Geneva'.' 'd,  `!jj  ! !>HTMLDB5 !8% !4  (4 !>HTMLDB5a !.  (. !4  (4` !4  (4g4 > MLg5  `!j  ! ! .9> d,9m4  4 &winE Courier New TextTable HTMLDB3-2 `%j%!(>fLocalization Table `%^.$3:K $3 .A1:K1007!(> d,A1:K1007!( 5> !( .9> d,9m( d,m (kYYYliY TLocalization Table `%^.$3` HTMLDB3-1 `%j.n &win Text_Dummy'4_M`'Text_Dummy_Mac'4MLg1 8 HTMLDB1GP Setup HTMLDB1 HTMLPict1 $3%.p0HTHTMLDB2GHTMLDB4GP$3 HTMLPict2 $3%.p0$3 HTMLDB3-1GP$3 HTMLPict3 $3%.p0ht &Set the lenght and position of Line 46Line 46 n% 4 n%!* 4 n%!l1 9*n Rectangle 53 n%4!*5* 9l1mht &Set the lenght and position of Line 42Line 42 n% 4 n%!4 4 n%!. 94n Rectangle 52 n%4!454 9.m1j 8 p0 4A@1k%(YH%YX3 N3 `%j.3HTMLPict 3%='Localization Table'! p0!9 4 3%!4949 4 3%!.9.9 4 3%!l19l19 4 3%!*9*mMLkcttHTMLPict 8 `%j%(kYYYYY1YMLHTMLDB1HTMLDB2 HTMLDB3-1HTMLDB4$ 'D8  D8wi '8 8A@&8wi $&win  `!j  ! !( `  `  `!j  ! !(   !5 !>HTMLDB5 !8 !4  (4 !>HTMLDB5a !.  (. !4  (4` !4  (4gw & ngkࡱ> _h|$p846Z06$p8 $TitleEB$|<6T , HTMLt_j|$p846Z06$p8 $HeaderEB$|<6T , HTMLt_l|$p846Z06$p8 $ DescriptionEB$|<6T , HTMLt_n|$p846Z06$p8 $ LineBeforeCB$|86 , HTMLt_p|$p846Z06$p8 $ LineAfterCB$|86 , HTMLt_t|$p846Z06$p8 $NameEB$|<6T , HTMLt_v|$p846Z06$p8 $EmailEB$|<6T ,,|  HTMLt_ |$p846Z06$p8 R , HTMLt_h|$p846Z06$p8 $PathEB$|<6T ,,, HTMLt_ |$p846Z06$p8 $ Choice1OB$6N6 , Choice1OB$6N6, R<,,$ Choice2OB$6N6N,|  HTMLt_ |$p846Z06$p8 R , HTMLt_ |$p846Z06$p8 $PathEB$ <6T ,,,L,,t<,,L"`hd\88 <F,,pwinTPp>,HTMLFilesForWinx, MyHTMLForWint<,,HTMLFilesForMacx, MyHTMLForMact,,|Pn`HTMLDB5 R@NP,@vt| $Pvx|$0 SaveAsTitlepvp|$p86  & 0 ,$Pp@P0 ~,,vx|$ OpenTitlepvp|$p8 6 0)0 ,$Pp  0,, $| `f>, $|`$PathEB$|<6TN,LFtx,,p 0@PT ,,,d R<:H:,` $D[odq[j,,,T HTMLCount$p8D464Z06$$p8zD4$,,vzfT@,bz,,`zb\,dt`z^, HTMLt _1t ,vtd@p846$Z064$p8DT$,6R $4D,,t0,`zdz,`zt ,,dt,, HTMLCount$td@T$p846Z06  >00, HTMLt _d|$$,6$T$p846$Z06  >00 $,Tvdh,jd, StringTP, HTMLt_|jd$ ="jd,T"$$$p8446DZ06  >00 4$D,, HTMLt_|jd$jd,d @$p846$Z06  >00$,,vdj,Lj"dt00 $4D,,,$L Choice1OB$6,.\ L R<,p846>"p8 46>"j<jv j$,TitleEB$|<6T ,,p846>"p846>"j,.\L jv< j<$TitleEB$|<6T <,,p836>$HeaderEB$|<6T,,$ DescriptionEB$|<6TN,,$ LineBeforeCB$|86N,,$ LineAfterCB$|86N,vj General Date$ LastUpdateEB$|<6T,p866)$NameEB$|<6T,,$EmailEB$|<6TN,winTPN,\\, MyHTMLForWind,HTMLTempForWin`L,,:\, MyHTMLForMacd,HTMLTempForMac`,, HTMLDB3-2$p8 6jh |, fNh,l\|v`|$,PathEB$| <6T X,,v`|$PathEB$|<6T ,,,$ Choice1OB$6N6N, fNf,l\|vd|$,PathEB$  <6T V,,vd|$PathEB$ <6T ,,, HTMLCount$p846Z06$p8z,,vzf@,bz,,`zb\ ,dt`z^ , HTMLt_1|h,vhd @p846Z06$p8$,6R   ,, HTMLt_f|$p846Z06$p8 $ Choice1OB$6N6 , Choice1OB$6N6, R<,,$ Choice2OB$6N6N, Choice1OB$6N6, R, HTMLDB3-1$p8 6jh |, HTMLtT,d^>N PvP0PP,d^>N PvP0PP,d^>N �PvP0�PP,�����,��d������ f�T<�,�����,�JP,�Dd^>NDFH0��PH,d^>N����DvD0PD,d^>N DvD0PD,d^>N DvD0PD,,d fTh,,D,<d^>N 

<HP 

F@0DHP@,,d fT<,,J<,Dd^>NDF@0<@,,d RT*,d^>N 
NDF@0<@NT,,^>N("NDF@0<@NT,,^>N("N("NDF@0<@NT,,^>N("N 
N

HFP0 <@DHPT , ,, f ,  NamevHH | ,T<,P,^>N

P@FD0 <@D T, ,, f ,,  Emailv, ,H, ,,,^>N

<@ D F0<@DHPN ,,^>N v0P,,^>N v0P,,v N ,,$ ,,L  x\\<@DHP T,,p,\PathEB$|L<6jh,Lz,,|,l Choice1OB$|\:6L ,\L, HTMLDB4HvHXPH,L4zHL\P ,,lLocalization Table$p8\ 6L^H\L, &,vDl SalesPRTextnD4 NorthTextnD$ SouthTextnDSepTextnDOctTextnD1366TextnD8487TextnD VersionTextnD3051TextnDvDvLlvD&jL$tH\L\,$tL6NL,tLNL,Regular$t,$t,$t,,$tL6NL,z,, SalesPRText$tHLNL, Bold$tL6NL,$tL6NL,$tL6NL,,vD NorthTextnD SouthTextnDvDvLlvD&jL$tH\L\,$tL6NL,$tL6NL,,vDSepTextnDOctTextnDvDvLlvD&jL$tH\L\,$tL6NL,$tL6NL,,$vD1366TextnD8487TextnD VersionTextnD3051TextnDvDvLlvD&jL$tH\66L\,$ VersionText$tH6L6L,,H,L * HL\D`z,,l Choice1OB$|\:6<L R,\<,L^>*h,,L^>*h,,LTz,<\,,|,,L R<,v8 LBluen8( TextTitlen8 TextHeadern8 LineAboven8 LineUndern8 TextFootern8v8v<lv8&j<l,v8 Redn8 Greenn8 StartHTMLTextn8 EndHTMLTextn8v8v<lv8&j<\,,v8 Bluen8 StartHTMLTextn8 EndHTMLTextn8v8v<lv8&j<l,v8 Redn8 Greenn8 TextTitlen8 TextHeadern8( LineAboven8L LineUndern8 TextFootern8v8v<lv8&j<\,,$vld @Localization Table$p8< 6^660<,$v\d @Localization Table$p8 6^6<60<,8, HTMLDB4vdP,Ll\<8`H,,|\nl HTMLDB3-1 RLN\L,lTitleEB$|L<6\T,L\,lHeaderEB$|L<6\T,L\,l DescriptionEB$|L<6\T,L\,l LineBeforeCB$|L86\,L\,l LineAfterCB$|L86\,L\,l LastUpdateEB$|L<6\T,L\,lNameEB$|L<6\T ,L\,lEmailEB$|L<6\T ,L\h,,lPathEB$|L<6\T"j\v<@j<,L\<,l AlertTableBh, HTMLDB1w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#4w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#0}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#59*\Rffff*9231222529w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#1|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#0w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#8*\Rffff*9131222529*\Rffff*9031222529w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#6w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#5|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#c|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#1}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#81*\Rffff*8f31222529|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#c`     ((* f( 4)$<(`%( h@ l),Xt x7D)K)Knv; w Converts a Microsoft Excel table to an HTML file. !0 R((26(45l >5\ H<6$hF66V:8H45l >5\ R6Z< \6l$x@ p0x 7~7 `7 7 P77@D7 47 v7r,2 7xf6P4r6tV45l >5\ d65 5T P 67 062 (6DL"f(1l L1VT p6x@ )x0 T.v 4h .4x ~*t1z i z&1h B4d0 L4`P 84\014 # zf( &1t d hH `L(`x( l44d T af(f(f(f(f(f(f(f(f(f(f(f(P@(T@4xl D & 0  4 & 0  $ & 0    0 & 0  0 0  X >000  t >00 >000 >00>00 >00>00 6>00>00>00 h >00 >00>00 | >00$   >00>00 H1$ME`p֞ $n6( H<0ZN@lRP~`^pitntD3`**= ,F=  > 2~D7V h0z@P + $0D8|"$>> LPhT.(,D<`<6 Hh@x" DDF,4 D P"T(hRJ20 (z@4h 0~  0~ j,,|0h0h","04,b8d$Hh2~$H0z,<@D"L`dhx|>" ""$L j,( ,|  4 b \ 0h` 0h  " $L     " ( >, "l p 4x  H  L $N $H &F 6nD $\| *\ $   " :   .   "  (  H8 "X  Lh &  $N &  $H $  &F&8 6nL  $\  *\"@0hL0hP"D \$ 2p(\`Hd"4$F$H*L(LH(Jp(L"F$F(Z :v4 8p 2X>"8<D L"XXl>4b<0h0h"  "$$L(LTX`d"h"Nl  n (4<LT \ `  lp 0t(     *     & ( 4  @ LD "F " &H" "> "`d"hlt(Z|D4T,xH\`&d> 6   ",0j4"",,, 0b .P,d,xD0b&L(:v, h tx|0j.H,f.H <"L `h ltx.H*d.H"&L(VPPR,, 2"  $  , @ X l p   2 L !<|!D!*XH!t!"x!|! !!! ! <!"!F"F$"2<"p">t"""X"$F""B#"@$#4fH# V|#@#2# # $$$$<$ @$L$`$x$"|$F$$.d$%(V%,% 0% <P% p%%.b%%(T%%&&h&,& 0&<&D& H&T& Bd& 2&& &L&H$'$Jl'"'F'J'J (Pl(N(N )>\)f)H*JL**"*:*H*D+H+ L+Ll+H+ ,: ,H\,,,, , ,,,",,,,,&h, - --$- (-4- >D- :`- -- ----.Z--N.P.2`. R.. B./ /(/,/Y  Y@(Y 4Y `YlPu=Public stPathSeparator As String * 1 'the path separator charYxYOn Error GoTo UnexpectedError$ Etf WizDefinitionWizard Definition `%^%A@*4t4UnexpectedError AlertTable$ $"A@JantkToaTo simplify the process and make the programmatic possible in this wizard, we create a array(1,7)1 = Range chosen2 (2 = Full Page (xlOn) or Template (xlOff)3 !3 = Title or Path of the template4 = Page's Header5 = Page's Description66 = Line before table (xlOn if TRUE or xlOff if FALSE)57 = Line after table (xlOn if TRUE or xlOff if FALSE)8 = Last Update9 9 = Name10 10 = Email/11 = Standard (xlOn) or simplified HTML (xlOff)1212 = Path to the new file13 = OS##9################### Dialog Box HTMLDB1 #################YY$t.HTMLDB2 `%j.HTMLDB4 `%j.HTMLDB5 `%j.*A@2 + +) z&FirstRun" initialize the dialog as follows:L Table: Examine selection. If single cell, then grab current region. Else D use address of selection. Use this as table bounds initial value.\( !\( !! !2! !f(f( ! %RangeEB %t(T`f( !f(f( %RangeEB %t(Tg`f( !f(f( %RangeEB %t(Tgz&'z&gdRedBlueGreen TextTitle TextHeader LineAbove LineUnder TextFooter$ '45ar StartHTMLText EndHTMLText$ '>5 45Localization Table `%^%(0 >5Localization Table `%^%(0A@5HTMLDB1A@7keE(|)RangeEB %t!T$2)$)!$)!#!EntireColumnSelected AlertTable$A@J  '!tg$$)!$)!#!EntireRowSelected AlertTable$A@J  't|)gA@1 HTMLDB1A@&8t##|)  '##t##k##8################### Dialog Box HTMLDB2 #################H$t.A@:8-HTMLDB2A@7oik1OhYYZ Choice1OB %N! ZRedBlueGreen TextTitle TextHeader LineAbove LineUnder TextFooter$ '45ex StartHTMLText EndHTMLText$ '>5`TMBlue StartHTMLText EndHTMLText$ '45RedGreen TextTitle TextHeader LineAbove LineUnder TextFooter$ '>5`g^ 45Localization Table `%^%(0 >5Localization Table `%^%(0k  Choice1OB %N! Z Z+)@ ` @ +)gMLHTMLDB2A@&8k##8################### Dialog Box HTMLDB3 #################Ytl !> HTMLDB3-1A@TitleEB TitleTextA@v7HeaderEB HeaderTextA@v7 DescriptionEBDescTextA@v7 LineBeforeCB LineDessusA@7 LineAfterCB LineDessousA@7 LastUpdateEBLastUpdateText LastUpdateA@v7A@NameEBNameTextNameA@v7EmailEB EmailTextEmailA@v7 HTMLDB3-1A@7g7k  7 !  7A@7tl ! '7gPk  7 TitleEBGPTitleEB TitleTextA@v7HeaderEBGPHeaderEB HeaderTextA@v7 DescriptionEBGPA@ DescriptionEBDescTextA@v7 LineBeforeCBGP LineBeforeCB LineDessusA@7 LineAfterCBGP LineAfterCB LineDessousA@7da LastUpdateEBGP LastUpdateEBLastUpdateText LastUpdateA@v7NaNameEBGPA@NameEBNameTextNameA@v7EmailEBGPEmailEB EmailTextEmailA@v7 jk` 7 %)! Z` 7Localization Table `%^%(0`` 7Localization Table `%^%(0g7k7Y 7$t 7'7 7 %t!T  7$  7 %t!T 4Localization Table `%^%(T` 4Localization Table `%^%(T Tgle`` 7 %t!T 4Localization Table `%^%(Tgtk! !> HTMLDB3-1tTitleEB %t!T+)HeaderEB %t!T+) DescriptionEB %t!T+)B LineBeforeCB %)!+) LineAfterCB %)!+) LastUpdateEB %t!T+)NameEB %t!T +)%EmailEB %t!T +)`TePathEB %t!T$`+)$)TemplateString AlertTable$$x/TemplateStringNotExisting AlertTable$A@J  'gDigog !> HTMLDB3-1E HTMLDB3-1A@&8f##k##8################### Dialog Box HTMLDB4 #################YxtY($t.$) ZLiBlue TextTitle TextHeader LineAbove LineUnder TextFooter$ '45RedGreen StartHTMLText EndHTMLText$ '>545`Blue StartHTMLText EndHTMLText$ '45RedGreen TextTitle TextHeader LineAbove LineUnder TextFooter$ '>5 g 45Localization Table `%^%(0 >5Localization Table `%^%(0A@6HTMLDB4A@7zakA@4 Choice1OB %N! ZA@5`tA@5gkdLocalization Table `%^hT 5  SalesPRText NorthText SouthTextSepTextOctText1366Text8487Text VersionText3051Text$ 7RT 5(5ldRegular9 9 9m 5(m` SalesPRText7Bold5(5( 5(m NorthText SouthText$ 7 5(5(mSepTextOctText$ 7xt 5(5(mxt 1366Text8487Text VersionText3051Text$ 7!( 6 VersionText7!(g m)kA@$t. Choice1OB %N! +)##HTMLDB4A@&8oxkTMA@5k##8################### Dialog Box HTMLDB5 #################`k+YCh'z&PathEB %t!T$` +)=Check if the user didn't choose the same name as the template$) @  $)$)HTMLIsTemplate AlertTable$A@J DontFinish'z&)tg Check if the file does not existabl8 $)v'FileAlreadyExist AlertTable$ "$J'11 1  DontFinish'z&abt$gg  $)$t*El8ftenl8 CantOpenHTML AlertTable$  $) WrongPath AlertTable$A@JML DontFinish'z&tkY4Y@on$) ZleA@* A@*�A@*���$�)������E���$�)�T $�@2�A@*�f���A@*A@*A@*$)E

$)$@2

A@*f$)E$)T $@2A@*f$) ZE
A@*f)`$)TemplateString AlertTable$$0A@ *A@*$tgdOgpuMarkettingStuff AlertTable$A@*"A@* StartOutput AlertTable$A@*"A@*--$).) $) Z 'T. `'T.'g* ) T.A@*--"A@*-- EndOutput AlertTable$A@*le"A@*--$) Z$) ZE
A@*fE$)E

LastUpdate$ $)$@2A@*f $)E

Name$  $)$@2A@*f $)E

Email$$@2  $)$@2A@*fA@*A@*`A@A@20*g20 *A@**A@01##k##,################### Common ###################LYl&Yxwi$&winleHTMLFilesForWin'.4 MyHTMLForWin'~*`leHTMLFilesForMac'.4 MyHTMLForMac'~*g !>HTMLDB5  ~*$& .4$0 SaveAsTitle$ % ')`.4  .4$0 OpenTitle$ %)')gE )E )PathEB %t(TfkTYYYYiaInitialization of HTMLDB2 Z Choice1OB %N(Initialization of HTMLDB3-1DB HTMLDB3-1 `%j. Z!>. Z!> Z!>$4TitleEB %t(T>`Z Z!> Z!>. $4TitleEB %t(T>g !>HeaderEB %t(Tsc DescriptionEB %t(T @ LineBeforeCB %)(ne @ LineAfterCB %)(ne ") General Datez LastUpdateEB %t(T !6)NameEB %t(TEmailEB %t(Tth+Set the separator depending on the platformwi$&winwi\'84Fo MyHTMLForWin'B4HTMLTempForWin'L4'`':'84Fo MyHTMLForMac'B4HTMLTempForMac'L4IngiaInitialization of HTMLDB3-2DB HTMLDB3-2 `%j.u u 84 L4$PathEB %t(TL4`u L4$PathEB %t(TgiaInitialization of HTMLDB4 Z Choice1OB %N(Initialization of HTMLDB5u u 84 B4$PathEB *%t(TB4`u B4$PathEB *%t(TgML HTMLCount Z%Z0!$' $'g   HTML _1'&1Z0 &1 Z%Z0!$$)%InInitialization of HTMLDB2HTML _ Z%Z0!$ Choice1OB %N( Choice1OB %N! @ E Z Choice2OB %N(f Choice1OB %N! ZInitialization of HTMLDB3-1DB HTMLDB3-1 `%j.HTML _ Z%Z0!$TitleEB %t(THTML _ Z%Z0!$HeaderEB %t(THTML _ Z%Z0!$ DescriptionEB %t(THTML _ Z%Z0!$ LineBeforeCB %)(HTML _ Z%Z0!$ LineAfterCB %)(n'7I don't want to use the date saved for the last update.Ed_dlg.EditBoxes("LastUpdateEB").Text = Evaluate(ActiveWorkbook.Names("HTML" & i & "_" & 8).Value)HTML _  Z%Z0!$NameEB %t(THTML _  Z%Z0!$EmailEB %t(TIn`iaInitialization of HTMLDB3-2HT$&HTML _  Z%Z0!$HTML _ Z%Z0!$PathEB %t(TgIngiaInitialization of HTMLDB4HTML _  Z%Z0!$ Choice1OB %N( Choice1OB %N! @ E Z Choice2OB %N(fInitialization of HTMLDB5$&HTML _  Z%Z0!$HTML _  Z%Z0!$PathEB *%t(Tgtg gkYY YML HTMLCount Z%Z0!$' $'g   HTML _1'&1Z0 &1 Z%Z0!$$)%E:1f '  ' '`'gun HTMLCount> 00 Z!Z0B@ ML:1HTML _>$)%00 Z!Z0B@  $ $)$StringHTML _ >=" $)"00 Z!Z0B@ ML`HTML _ > $)00 Z!Z0B@ Z0g k  $*v $,<B@DL$\$ YDiY esY==:========================================================== ! OUTPUT CLUSTER==:==========================================================88If IsMissing(sFilename) Then sFilename = OUTPUT_FILENAME{*{'* ~*T *'t**r'*'t*merlexg_sResult = g_sResult & sOutput * * *g_g_sResult = g_sResult & Chr(13) *Egk /RkY{'/'x/'/ ~*T /! /$/^ / /. Read line of data.Debug.Print InputData / /'x/'p/g*/ /A@* Close file.re./ FileNotFound AlertTable$A@JJcheesy but it worksrk'x/'  ''e44YT{'/'0'/ (0T /! /$/^ / /. Read line of data. / /'0p'g * /2Write InputDatatDra/ FileNotFound AlertTable$A@Jcheesy but it workst '0  'e'`Y` /$/^/ / /. Read line of data. * /.Write InputDatatD /A@*/r*eࡱ> | tPL T,,`hH,0,`jH,,,L" x44LPt,Tx"vnvtvvv^vbv`jhvRN,```^`,v`,^>Fld F$,P$,`,,8,L^>FHvH,PH.,,L^>F 
HvH,PH,, 40vxN4,,\,vpvtvvvx,vdvhvnvx,L^>F(lhF$,H($,tx46b4,dv``b^,b^,L$``p$tx"vnvtvvv^vbv`jhvRN,```^`,v`,^>Fld F$,P$ ,,^>F lhF$,P$,tx64b4,dv``b^,b^,$``pL$tx"^>^>^>Fv^vbv`jhvRN,```^`,v`n,^> $v$,P$,,vx,j,^>
$v$,P$,L `* ,0hdpx $(H4TD>F0,P0,,4^>. 0v0,P0,^>^>^$,,(l, P" BGCOLORjPLvL@xRLNP,(,lx (HxPH,, ,lx $HxPH,,vpvtvbvdvfvhvjvlvn$  ,4^>.DltF0,HD0,vbvdvfvhvjvlvn ,4^>.lp F0,P0,,4^>. 0v0,P0,^>^>^>^> ^>^>4^>. ,^> 0v0,P0,,L$$txp0DHLPl,,,T,T,T ,T$,T(,T,@^z,@^x,@^v,  l | \vT,,:(,vh,lh|X,,,h,h$T hlX,,b ,d^z,, dJ`Z!P`,,:d,vt,lt|P|dd@0 R ,0^z,,,lt|0,,<,0 AlertTable v  FileNotFound`v` |@P` @,0^z,d,< X t((` @ x ` , $dP,,b ,d^z,, dJ`Z!P`,,:P,vt,lt|P|dd@0 R ,0^z,,,,,<,0 AlertTable v  FileNotFound`v` |@P` @,0^z,d,< P t((` @$tx <@PSPpA``(,, ,LN4,, |l, , ,,L 4vX,,<,b , hJdZPd,h^z,<,h^z,<,<X d< ` l$` 0)%"1>|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#cw*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#6*\Rffff*8f31222529w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#3*\Rffff*9231222529 )(* /~* xt*( v * h* *XN / ,*$ (~* D/4x/6   /t(0 $/`0H P /t20Z v  /h4`x8((t*z XhD(x/z $Ttt(0z 20l 8`MEPl`4$f6 HH>0ZN@ i @\(d@B>  $ 4<@ DLP"T&X & "B   $(L(h    *v B  ( 08 <LP$`(  @^t,@^r,@^p,l,bd,bb,P, 0[6 T0 ,dvV`T^,`Vp@$ $  [h\N ,t\ hXN ,rtX nll| f0tXhrdv@ f6tXa`bp f6D| ,`Vd,lP P,,lP|vXv|<j|P|,tX|nlN|,tX|hdN|,tX|abN|,,D,tX|`"BtvtvVvPj|^>zvz4PtN|,D,tX|e"ItvtvVvPj|^>zvx4PtN|,R,tX|j"UtvtvVvPj| f^>zvv4PtN|, J,tX|i" STRIKEtvtvVvPj|^>zvt4PtN|,$F,tX|"SUPtvtvVvPj|^>zvr4PtN|,(F,tX|"SUBtvtvVvPj|^>zvp4PtN|,t\|"lPj|t0pPtpN|,vVt,,lP P,`z:T,lP P,`x:T,lP P,`v:T,lP P, `t:T,lP P,$`r:T,lP P,(`p:T,lP P,^>zvP,F,, |"j|p0l^>zlFt,ptN|,,L$"P\lX88lpt|04(&&`2G:H2v, t,ltn,dvl`n^hL,lplt|X`lTHDpPDNH,vlh,lpx,H8ptxDHH ,,bvz^j:,`zvXjXT`zPTNX,vzj, &&, <<, ©, ®,À,Á, Â,Ã, Ä, Å, Æ,Ç,È,É, Ê, Ë,Ì,Í, Î, Ï,Ñ,Ò,Ó, Ô,Õ, Ö,Ø,Ù,Ú, Û, Ü,Ý, Þ, ß,à,á, â,ã, ä, å, æ,ç,è,é, ê, ë,ì,í, î, ï, ð,ñ,ò,ó, ô,õ, ö,ø,ù,ú, û, ü,ý, þ,D Translations$pX 64^h,tX4,D$p46X,2$n4X$,D$$tt$hpN$,tp$"j$\N$^,tp$`np R4N$,4,,$D$tp$hpN$,,npvf @\nfp`:TR,$D$tp$hpN$,tp$"j$\N$,$D$tp$6XTtp4PT$4X,$D$tp$hpN$,^,,LpH tpT$4X", x,d AlertTableTvTAssertionFailuretvth< AlertTable,v, AssertLvLh AlertTablev| Plx 0,, \rl^,<,<hd>hdL,,d:,dh,,, ,,Ldh$,,0,4, hhxNh,X^,,40vx8,,X^,txh`"jhPNh,X^T,,X^,txh`2,00, 44,,,X^,txhe"jhPNh,X^T,,X^,txhe2,00, 44,,,X^ ,txhj"jhPNh,X^ f,,X^ ,txhjX fHNh2,00, 44,,,X^$,txHi"jHPNH,X^$^,,X^$,txHi<,00, 44,,,X^(,txH"jHPNH,X^(X,,X^(,txH6,0 0, 44,,,X^,,txH"jHPNH,X^,X,,X^,,txH6,0 0, 44,,,L04 xHhx,,,, hhxNh, h"jhhdvd8RdNh,Lx xdh,,l^, \n" Lh" ,,L@<L\,,T h R,lh|$l,h t hl 4Dl*x,t, P` R@  0 R6P ,x,, D,pN,bp<r0vHbp<r`vHbp<rv H lt=#f>jFDf>jFDf>j FDx ,,H x txDD @PWt40x,, P,h0XvX vHLjH |8(xXH( ,, x,,H Tx x(HX,,, l"jlPNl,\^,, l\ RLNl,\^, L\ RlNL,\^d,,\^, L" ALIGN="jL>JXD@"D@NL,,, L"jLPNL,\^p,,\^, L" VALIGN="@jL>JTD<"@D|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#c}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#5d}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#52|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#1}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#81w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#6w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#0*\Rffff*9231222529w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#2w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#1w*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\WINNT\System32\VBAEN32.OLB#Visual Basic For Applications*#5}*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#10*\Rffff*9131222529*\Rffff*8f31222529|*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\..\..\MSOffice\Excel\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#0  24  ^x+,  < t pX+h @  tn+ 邔 x+++@d+$"p $ +t r +pn+ , +60  + `t+ + +Hd" #, ,$+Z  .,d$,l$  8,pPX,~T  | +h d,f x, ,, Dn," + , $,4,x(,"  xdn+ t, , 邘, 邈, , x-$ -( -, $-0邨.-4x,xZ$ a xHN- hX- xh*d-n- LD-X* n+ , , ,  , - ,-$ <-( x-BlD St -z r -x p -v l -t d -r b ,-p  x-l -d| -b \ lX V T *Pn+ 0x+@+P-`+ p+ ,$  r.( t\- B^ *n 0+xl $-tj .-ph ,n f ,l d `,j b ,h -f -d -b - 8Lr. x*< ? +x|n +v h +t d <.pb ,n ` ,h^ ,d +b( x+` -^. (N+ l  2 ~ @ f z, #tT, jpd 2nL2 @22 d px n l<$@dDL x(\(,\4 (+xhd d (X+x  (d+x0 (+xtd  (+xH Dx H ($,x(.,t(.,t(.,t(.,t T X,l $4hLXx<(.x(@2x(.x(L2t(.x(L2t(.xx ,P@pL(L2t(L2th HXhtt  t <  MED nP$6t HU0Z`@lP~$H`TIpJ JR(P H P2 s@T2\@B 8ZV\F<   ,4DVH B &*  V$| B$:   ($b4 ,B   .@$T2X(V B*V"  $ b0  (ZF(  px  | (VB   0bLP@T.@B  "L( L  P X \ \` : B   B $ ,  0 <   @  , D @L B   &J T H 0d $ 4 " .T &, 0T< l &Zp   "  0Z    ,  $"(,4<D8T8"8  (0HL d l |            4HLP p x  $       (V4T2  ,DH L l t            , @TX\@`(@"  ( 80P T:`  "2:bL      @ 4<DXL$ .  " Dr T`x,|      *N *N< 0\T .T ,P ,P, (X 8 ( &",",",,(0P$.x$. JD48"<LT\dlt| >  ($ ( 0D(HB2p$J.&, F$*lP|*" 4 (,,@HD($ FF \ |NX^< \ H  @! $JX! $|! !!<\!T!4"  D" ,H"`"Fd" ," $" ""6n"$#  4# *8#L#P#.T#h#8l#"#n#$ $$$,$0$4$D8$D|$D$"%%%% %(%.8% L%.P%^%(%(%*&(4&,P&,p&*&,&*&*&* ',,',L',l'*'*',','*(*((,D(,d(,(*(,(*(,), ),@)*`)*),)*)*),),**<*,\**|*****,*,*,+*8+*X+,t+,+*+*+(+, ,,,,,L,*l,,,*,,,,,,-*(-*H-,d-*-Z-^.`. Jp.@.,. .$. ..,./8/,/@,/ l/ $R|/ ,////B//// //$@/ 0 $0,000Y@ ==:========================================================== + HTML ALIGNMENT UTILITIES====:==========================================================<Y\ .+ +G $+G .+GPT include centeracross here so we get the CENTER attribute-value generated correctly.atO Note that this center across is handled as a special case, so it won't ever beer@ encountered here without special case handling from the caller.center'D+ 8+G G D+GPleft' GPright'gnOde!XLHAlignCodeToHTMLAttribString: NoMatch AlertTable$ T A@N+'jL '+exY dd +G $+GP middle'p G 8+GP*top' *GPbottom'gnOde!XLVAlignCodeToHTMLAttribString: NoMatch AlertTable$ T A@N+'j 'X+eY+Y+Y +'+'+ n+!% + n+!$String ALIGN="left"'+="`gh ALIGN="right"'+.+ga n+!% .+a[ For center across, scan right for the first cell that either has alignment != centerAcrossn- or a non-blank value. + x+ '+  +   n+% 5$45% .+ + '+`LIqgLIm="nt ALIGN="center" COLSPAN= + T '+ma`al+ normal alignment: breathe a sigh of reliefn+ ALIGN=" n+!%$+"'+g +'d+eN=@ VALIGN=" n+!+$X+"'+e+' +!%$'++` +!% + [ with general alignment, actual alignment depends on the value datatype and thus we need toa  set as a per-cell basis%'+a +!% .+a S with center across handle the alignment on a per-cell basis. The per-cell handlerow @ knows how to collapse cell output records with COLSPAN attribs.''+`LI'++ ALIGN=" +!%$+"'gdlgve< handle vertical alignment attributes, no general case here. +!+$'+` '+N=  VALIGN=" +!+$X+"'g==k==:========================================================== ' HTML COLOR UTILITIES====:========================================================== , ,  , , 0$, ,'+` O ,'+gecemuU Object must support both the color and colorIndex properties (all Excel objects do).3 Handles color None and Automatic as no HTML color.$YD !  ! '$,` !D,'8, $  .,=# 8,$N,$+ 8,$N,$+ 8,$N,$+'$,==g==e==:========================================================== & HTML FONT UTILITIES==:==========================================================dYONY=" '+ +'X,e'x, !>$ !$ !$'x,,`'x, , $X,', ,',g,kDYh,',', +!.on1 check font face, size, and color for consistency +! , , ,A@n,k '(YL.-'$-'.- n+!.on1 check font face, size, and color for consistency',, ,.-  , $- .-A@n,Bog a Do Bold attribute', !%$',`%',$- !%' $-'$-' .-'.- DgItgic Do Italic attribute8-', !8-$',`8-',$- !8-' $-'$-' .-'.- DgUngrl Do Underline attribute', !$',`', !  $-'$-' .-'.- DgStgke Do Strikeout attribute'- !$'-`'- ! N P'!! NOTE NOTE NOTE: The tag isn't officially HTML 3.0, which designates t M' as the right tag, but the only strikethrough tag recognized by +' Mosaic, Netscape, and IE as of late 1995.E> $-'$- .-'.-gSugrs Do Superscript attribute'- !$'-`'-$- ! $-'$- .-'.-gSugcr Do Subscript attribute'- !$'-`'-$- ! $-'$- .-'.-g==g==k==:========================================================== ! OUTPUT DRIVERS==:========================================================== N- X- X-n- *< n->'*`* d- *'*N-gg X-'N-gk  LYlarYxbyYctYisYupYalYt Y YYY Y Y Y, , , , , - - -tp[ must output on a character by character basis. Setup initial output for the per-characterte attributes.j'- n'-rt'--'--'--'- c'-$2 cause immediate output of font tag, if applicable'-'-'*R now start looping over each character, testing selected attributes as appropriate n+!f!'  %  n+%f. !.ce  font face, size, and color, , !> - ! - ! -  *'*X,g * $X,'* !>'- !'- !'-gtt bold setting ,E - !% * BA@D-fse  italic setting ,E - !8- * IA@D-fne  underline setting ,E - !  * UA@D-f  strikeout setting -E - ! * STRIKEA@D-fri  Superscript setting -E - ! * SUPA@D-f  Subscript setting -E - ! * SUBA@D-f ! And finally the character itself * !T$@2'*" turn off any settings as required ,E *'*f , -E *'*f, , -E *'*f, , -E *'*f- - -E * '*f - -E *'*f - -E *'*f *A@*`C don't need any per-character output. Just splat out the cell textp n+!T$@2A@*gkYYYYYYYYY r.Y, r.th Do the cell background n+!BGCOLOR$$,'+ce Do cell alignment +x+ + n+ x+ + -$d+'+g+ ++ + n+$+'+gdl! handle uniform cell format codes   n+ , , , , , - - - $- .-A@, + $-A@*  n+ , , , , - - -A@x-TD .-A@*`le@handle the case where the user choose not to have any formattingA@A@* n+A@x-A@*\gk\\YYYYYYYYYYr. r.A@*ab`
A@*gB for each row, scan for funny alignment aspects like center across" Else spew each cell to the output + -!r. r. @ decide whether there's a consistent alignment across the entire ? region of cells, and if so then put alignment options into the  tag to avoid clutter + + + .A@+ H Decide whether there's consistent font face, size, and color formatting R across the entire row of cells, and if so then put font formatting options into a X row-wide tag to avoid clutter. Note that Bold, Italic, Underline, Strike, Superscript, V and Subscript formatting seem to be reset on a cell-by-cell basis in IE2.0, therefore A we don't even attempt to issue row-wide tags for these elements. + , , ,A@, ,A@* +!2!'+ x+ +'- x+ +% x+ + - + + , r.A@-M fairly bogus to mess with the loop counter, but it works with little code... x+ - 'x+, ,A@*` @handle the case where the user choose not to have any formatting ,A@*+ +!2!'+ x+ +'- x+ +% x+ + - r.A@-x+ x+ - 'x+TRA@*gTa
A@*k2************************************************** AssertionFailure AlertTable$ . ".Assert AlertTable$ AlertTable$J GPc GPj**k>**************************************************************=Code handling the characters not supported by the HTML format>**************************************************************(YHYXYhYt  $8 + 2' write one line for each exception caseX These are the core substitutions common to every code page, as defined by the HTML spec&&$+ 2<<$+ 2©$+ 2®$+ 2À$+ 2l;Á$+ 2c(Â$+ 2tiÃ$+ 2"Ä$+ 2Å$+ 2nsÆ$+ 2"Ç$+ 2")È$+ 2tiÉ$+ 2Ê$+ 2= Ë$+ 2Ì$+ 2y(Í$+ 2nsÎ$+ 2o;Ï$+ 2Ñ$+ 2nsÒ$+ 2"Ó$+ 2Ô$+ 2= Õ$+ 2ArÖ$+ 2Ø$+ 2= Ù$+ 2ArÚ$+ 2vTÛ$+ 2suÜ$+ 2Ý$+ 2vTÞ$+ 2miß$+ 2y(à$+ 2nsá$+ 2otâ$+ 2c(ã$+ 2nsä$+ 2å$+ 2c(æ$+ 2tiç$+ 2è$+ 2")é$+ 2tiê$+ 2ë$+ 2ì$+ 2nsí$+ 2stî$+ 2 2ï$+ 2ð$+ 2ñ$+ 2$ò$+ 2ó$+ 2ô$+ 2õ$+ 2ö$+ 2ø$+ 2$ù$+ 2$ú$+ 2û$+ 2ü$+ 2ý$+ 2$þ$+ 2S And handle code-page specific translations based on the entries on the translationW sheet data table. First, find the country that we're running under in the translation table.$ Translations `%^.# 62 %,2#' 2ti #%.j j!$4] j! 2p 2ggr j% .j 2 j$4e; j% .j: fill the translation array with entries for this language j!$4] j% ! j!+ 2 j% .jg 2kumYe;Y$Y 2 L2'ac    L2 $$ 2' '@2ee;dirPHSO|SummaryInformation( HDocumentSummaryInformation8$CompObjttxT+f w j cd (&( u(v8 |l1$D i\R ϸZ d^ OBd ovj `)nr M ~ Y | & (80 wb/6 >P0 ި' f" )F ʜ ,g" # a? 0 * asn  " z( %N6 < =v/L D z\ /< j ^.0x | " _ # $* e2~T' c& p2 p_) pb Ϙj Db . + F~$ \ V{&1* N\B$ ]($]0,wCH(0f4g &<J_^.^8Obn\6)@'oH(1mTzV1NfCpf~N0ip&Z,sҮ,j,*>tSNGX8`+%"v$R&U8n"du"rCo&.~  #O5 "\exB(>&8MWo0Oso'1s?c R/h)(|:t@RTBb+\`bb_C:7hT 2plv_T챒 ~լ/jxE]V<p12.5\%t_u"7Cam4"R&,j 9%,!L l&2T$T.pD>\"Jrd2ZjbОfg_rpΎ0 "NCʝ+Z_jrB #d,.,TizlXeX`"icK7,$ڐ)6$J d @\emy#dtD^BN!*,UJ# %"V޸51OX+,@C"94"e(142$?(* 4iB7n>%JR6x/-d, n2z5#*tn R%#ڍ62ȏ(,H#p6 hT)x.\ƨ*lv ]_]$ $V,/$l*`0:lH+ (J~#X1p%9`2MoQ'R6u G.b4)>sFaj)1% TPz>v`!\5cN7V. ]!)2l&,*0F<8HD)R.ZIfr E|%~`>@K!sf& \Tu6'ul-@)G&2".Z6~&F~r.LV4*R^jQF vC)m<b+pD$!X1]IQ~B~'d;Ko$K^8.ujR52(>BD NU8!!XW&Tb>yjX2pv. /~)T1j :[֔8`|0L$jlpnh'1.42#Mz3,! 8-80$7H8mf%6Zfj t2-~Wۜl7a.-?LՒfq4$[$f:QQ4(tz:5 St'#&O4~<YF*J<&RhN|(\*#bRpDx8$!~]"8<0/jH%W=1$x      !"#$%&'()*+,-./01345>789:;<=2?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~a] e*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#C:\WIN\SYSTEM\VBAEN.OLB#Visual Basic For ApplicationsF d*\G{00020813-0000-0000-C000-000000000046}#1.0#9#C:\XL5\XLEN50.OLB#Microsoft Excel 5.0 Object LibraryQ8 )%"1> 413034e440 8e31222529*Dj 14b1468318 8f31222529*D 34b1468bf0 9031222529*DH 3130c77b09 9231222529*D) 3830c89186 9131222529*D+)v !20,4B \ V T*t| 4 dhJN 4p " `.f !$*^ " p Htf+j ^)6 ~ <  * j>r Jj  r2f^1*` 4 %H~ @% x3z  *%, Jt  " TJ zLz@   ^*Z~ 6H@  J `t  @>t  nTt4>J "" !6j&,8+& 2Ü pb@h ~d!z"qr6#ل&F/`Di|lKz gsKJjî -Z fenH $ O ed +Xj8+lNin$OsӪדt*k" $9zr 2?_8z01H`NbzRL&. 6 +Ⱦc ( _X t @`[fT 1U" 0v@ fHfG~ f?0.f :u`N~\@4Vd*l_Tx |j_6 LXz6f "]t4۪7a9 fC~{,T0LX(, 6ԊD<f6H?=|V*(^xllM^vf'l@ dA {h*.,"e$ 6fN1j' $^ ,oFF'82JDV , Zg8d,20nU1x%  Y( t X$1bj#@BZ4?8v8,v7>&sL~ R