ࡱ> z yxu~Tahoma ( pExport AlllEuTahoma(DeleteEuTahoma ( vOverwritellEuTahoma(LLoadEuTahoma(eStoreaEuTahoma ( Stored tables 5Tahoma`?5Tahomamnp/( @cmdBrowsemee~@/,<CommandButton2/, ;8cmdCancelttojJ/( XtxtResulttto( 2Label1$ HcmdCopy /$ DcmdSave/( # OptionsFrame5( ,cmdSelectionI\ &;D )ApplyButtonnjJuApply these options and refresh the table, -;@ cmdExportAlljJ1, +;8 cmdDe Excel2LaTeXq4N@.gq4N@.gq4N@.g 0BCon&vert Table to LaTeXConversion.LaTeX 0B#Convert A&ll Stored Tables to LaTeXConversion.LaTeXAllToFilesk(   T8\pChel Ba= ThisWorkbook=h/:8X@"1Arial1Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_->_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_-"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.0050_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-#,##0\ "DM";\-#,##0\ "DM"##,##0\ "DM";[Red]\-#,##0\ "DM"$#,##0.00\ "DM";\-#,##0.00\ "DM")$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM">9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_->9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-FA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-FA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-0.0 0.0% #,##0.0\ "DM" #,##0.0 #,##0\ "DM" 0.000                                                                      ff + ) , *     P  P        `            a>  ||>hD}-} ##0.00\ }-} ##0.00\ }-} ##0.00\ }-} ##0.00\ }A} ##0.00\ ef _D_M_-;}A} ##0.00\ ef _D_M_-;}A} ##0.00\ L _D_M_-;}A} ##0.00\ L _D_M_-;}-} ##0.00\ }A} ##0.00\ L _D_M_-;}A} ##0.00\ L _D_M_-;}A} ##0.00\ L _D_M_-;}A} ##0.00\ 23 _D_M_-;}A} ##0.00\ 23 _D_M_-;}-} ##0.00\ }-} ##0.00\ }A}  ##0.00\ 23 _D_M_-;}-}! ##0.00\ }A}" ##0.00\  _D_M_-;}A}# ##0.00\  _D_M_-;}A}$ ##0.00\  _D_M_-;}A}% ##0.00\  _D_M_-;}A}& ##0.00\  _D_M_-;}A}' ##0.00\  _D_M_-;}A}( ##0.00\  _D_M_-;}}) }##0.00\  _D_M_-;-;_-?\ _ @_-@ }}* ##0.00\  _D_M_-;???-;_-????\ _ ???@_-@ ???}-}/ ##0.00\ }A}0 a##0.00\  _D_M_-;}A}1 ##0.00\  _D_M_-;}A}2 ##0.00\ ? _D_M_-;}A}3 ##0.00\ 23 _D_M_-;}-}4 ##0.00\ }}5 ??v##0.00\ ̙ _D_M_-;-;_-?\ _ @_-@ }A}6 }##0.00\  _D_M_-;}A}7 e##0.00\  _D_M_-;}x}8##0.00\  _D-; ?\ @_}}9 ???##0.00\  _D???-; ????\  ???@_-@ ???}(}; ##0.00\ }U}< ##0.00\  _D-; }-}= ##0.00\  20% - Accent1A 20% - Accent1 % 20% - Accent2A" 20% - Accent2 % 20% - Accent3A& 20% - Accent3 % 20% - Accent4A* 20% - Accent4 % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3A' 40% - Accent3 % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3A( 60% - Accent3 % 60% - Accent4A, 60% - Accent4 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6A4 60% - Accent6 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title,Title I} <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`/0Working" TabelleA;" TabelleB;%" TabelleC;)8" TabelleD;<Ka|ccB~-z4nA_)k:~yw T8 A1  dMbP?_*+%&?'?(?)?"~-z??&U>@$ 7 WorkingggD dirTest IView 0STools  6xME PSS S<&<*<.<2<6N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5}0 %*'PH%ph%x%%,!8 %) "%,!:h`%) 0% :)<=%,!@h@8%)` % @)B%,!F@%)8 % F)H% L%"(@H",hh"0"4h@@h $vY -   ( B0 8H BP Xh" p x  B "   B "  (8 "@HX@hpx]@]@@]@h]@ 4.8m0  ,.:m <.,x 4B@>4m` (.@8m@h B.( (/Dm 0.Fm@ H.0: H (/Jm   P (B@N R (B@NxophQAttribute VB_Name = "CController" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |@GlobalSpacFalse dCreatablPredeclaIdC@ExposeTemplateDerivCus tomiz EOp tion 0licit I&ements 6I P/3 mView A Model  Storage (pEv{8*N-< Property (Get Q_()B.E S ]mD End :D=A?P7M*B (ByVal p9QB) Em=7.RaiseBChanged;|D;;A:C: E::99?.g?`M r R-MIdT&VQ Wed)DG1U SubjRun( #If Win32 Or64 Then .Show DvbBJessC#E %alEl IfO@   `hp x "   B  B0" 8@ H Xp   B"    B(08" @H` hx B"  B"8@Hhp Bx"   B D%xR%m xME(  $SS S<.()\row%i j J % ,h )L!%i   `* S,N )L(0%i  Vh% X%," )j%i  ,XCC)jx%ili i i n%`p`r`t `v x% z%PPP Hiphirit i ~x )j(0%)nPX%i  Z I I i  ,`X11)x%i i Yi ` ``` , )%Yi ,HYdh)%Yi PP,@Y`i , ii i ,`i)%i  %,(iH)hp%i @ , )%i  ``` %, )%i ,`)%i ,|0 )%i  ,p)%i ```` ,X)x%$%) $%,8 )%i  ,x)%%) %%"V( HbZP b\P b`x "fH0@ x (  X   ( @Px P `x`x@ ( H x 31   8\ $vY  0HPX  ((PX\` ,".0`p &x     .0`x @4 8 HP     8(` x& . $ 8 @ H  4X   "        B   ( 0 $8 ` Bh  p  "      B    $ @ "H P @X  "  @  B     ( 0 H BP X h       B         " ( 8 H ` B h  p  B    "     08 @X `x  B     (8 @ `px >(L `>p <    (0 @FH 0     B (08H`h B p x    B    (&H p( & B  B  08Hh px   (    0@ *Hx "     (8&@$h  0" , 08 2@x   <  " (0 8 H 6P  "  B &(P B X`$h$ B     &0 X h x   : 8 (0 8@H b`    ,(X `p x   B   0HPh B px  4 Jh Bpx B  (  >0 p(  0 P  p  B       , ,!  &H! p!!!,!!! B ! "!" " "  8"X"`" h" "2" "0" "6# 8#@# B H#P#X# `#h# x## (#(# # V# &P$x$$$$$ B $$$ B $$% B % %@% B H%P%X%`%h% p%% %%  >% .&@& H& X&x& &&&& & J& ,'B 0'8'H'@P' FX' B'B ''( ( ((8(@(@H( HP( F(B ( (())x] ]( "Characters per Cell in output file]P ]P]x ]x]] ]@ .Vo` IModel implementation` 4.nm  \G p t'pj ^G p v'pj `G p x'pjm@]$p'| z t ~'\ z v ~'^ z x ~'` |$p 4B@k8m0 b'm( b G{j 'b 4B@m Z'm Z G{j 'Z 4B@mH d'mh] ' $ $\*   $ 'k 'dm  d?:\* d\\*\* d'd%1\%2  d$'km f$'mh $.f 4B@m8@]]]]0]H.V f% Error: No range selected.A@k b$-% Table generated by Excel2LaTeX from sheet ' f!! ' A@ ` b$\begin{table}[htbp] A@ b 'b b$ \centering A@ b$\caption{Add caption} A@ b 'bk b$\begin{tabular}{ A@ f$A@}A@Start checking top border f%.  b$A@Table contents:  f!!' for each row  f%. !. b$A@ b 'b]` $' G\rowcolor[rgb]{%1} $$A@j  ! for each cell in row r  %.     !!! ! $  '  cells in row Struts and end of line%1\\ $$A@ b 'b Check for Border lines % b  f!!$A@  row Tabellenende b$\end{tabular}% A@ ` b 'b b$\label{tab:addlabel}% A@ b 'b b$ \end{table}% A@k V%'- Save to registry after successful conversionA@i`x'b'Z v t x'pA@ .f 'do f (empty range)'{k%1: %2 ! !$'m f.mx %.f 4B@m@ Class implementation $!!' Gzj %$!!'ix  Excel2LaTeXMainDefaultSettings %A@o` P Excel2LaTeXMainDefaultSettings $ B@o f.'zk f!!!'iX Gzj Gzj ! !.dX .k@i8 ](   !' f!!'%1.tex $'i@  VB@ G  VB@jo  !%$'ihH !!E No struts in booktabs mode ^Gzj] ] $"' %$"'    \bigstrut'd \bigstrut[t]'kdx  \bigstrut[b]'kPkHi@ ]  ]8]P f!. %.( $ ($,'*k  ! & (..(  & $.(`]h8get horizontal alignment using the last row of the table !! %$!.'. !! %!2$0 4 !! %!6 f!8 *p{ ? f$>$ <$ :em}'*dH *p{ ? !@$ <$ :em}'*kd . BKT *l '* DKT *c '* FKT * !! %!2$0 4lr$H '*Sh *r '* Default alignment is rightn0k( ( * ($, '*k  *'i ] J  > J!@ '> i (return nothing, | or ||] L$N PKT||'* RKT|'*S '*n *',i  T'N]P]p L!! L%.V N B V$%\!^$Z'N V!` fd V%b%.X N h X$%\!^$Z'Nk( i  j$'"i  j!!E] j!  j%.nk ] ]8]P]h]] x j! n x!` j!`  n%.zk x$|'td x z$~'v v T'tk p r t x!` j!`  A@ p r j!! A@] ^ \toprule' e \bottomrule'd \midrule'k d \hline'k ^ \cmidrule\cline$H' ^\morecmidrules$H') Straight line? => revert to old behavior p1-%1 j!!$&return nothing, \hline or \hline\hline j n$~'v v PKT l$   l$   ' RKT l$   'SX'nH pe'd( {%1} p;}  { $$'ki t r 'r%1%3%2 p  p;$H$'pkpdh r %1-%2 p  $'p'rk ko  j$%\!^'~ nGzj ~  n$%\!^$Z'~ix T'Z  R  RG R'Zj  P  PG P'Zji@]]]0  $' ]H $'Check for multicolumns !8 @multicolumn cell !5!'5!'qp  4 Add contents only for first row of a multi-row cell $|\multirow{%1}[%3]{*}{%2}   $$' d' kk    \multicolumn{%1}{%2}{%3}  !  !!!$ $' k0d single cell''k A@  Z  Z   $A@k &A@k Z  A@d`  b$A@k@ 'i0` !d'   !2$$'  $'  $'k   $'i] $!!' $!!'  d'd(\textcolor[rgb]{%1}{%2} $ d$'k  G\cellcolor[rgb]{%1} $$ 'ji( %1, %2, %3 $$ < $$ < $$ <$'i '8Check for special characters - always convert if numeric \  \\textbackslash{}$' $\$$' _\_$' ^\^$'k %\%$' &\&$' #\#$'   \newline{}$ 'ih ] $!. 'Check for Font Styles !G \textbf{%1} $'j !G \textit{%1} $'j Typeset math in bold if required ! \e $ e\boldmath{}%1\unboldmath{} $'k(i  Requires "rotating" package '] $!' Check for orientation  KT Do nothing KT \begin{sideways}%1\end{sideways} $' KT\begin{turn}{-90}%1\end{turn} $'S\begin{turn}{%2}%1\end{turn}  !$'ni]0]H]` $']x  f%.   !!!$'   !!!$' !2$P if the cell is empty, ignore alignment changes and only change the vline format if a vline was added or removed  'dh  'kPiH !` f!`  'i  ! f!  'i ! !!'|i0]]]] $'  !!! '     f%$"'7 First and last horizontal lines account for one strut,( the others account for two struts each:   '        'kpkh`iX C under Excel 2010+, RangeOrDisplayFormat() returns a DisplayFormat,% so we can see conditional formatting !.i @ VBA7 isn't supported in Excel 2011 and 2016 for Mac, so need to< actually check against Application.Version on that platform !$,@ !.d .kiA under Excel 2007 and earlier, DisplayFormat is not supported, so? RangeOrDisplayFormat() just gives back the range it was passed8 .iaAttribute VB_Name = "CMo@del" Bast0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse dCre atablPr@edeclaIdCExposeTemplateDeriv%Customiz EOption 0licit  I&emen0ts I Dim sb As SngBuil der  CellWidthInteger 'Characters p  in output fil convertD ol"Boolean/book s Float Ind@0#ysFF2RangeToU7@B=P@T@V mpEvBDNewF Sub Class_Initialize() ACSetP = LQEnd K' iaahBub@i Pro@Sty G@h_"()B!0NonqEF.%+H,p2)#H+FO8c%Y.RaiseG@ydA[If_\(i##\f $0BAt5$ AiAϤ DAD= VExitf !|& F zf!P ! Q""#i"V$ Ed\ gxC]hCsQDirv= Worksheet`t f UCЏ(i) LikeT) & "\*" q0F Mid$W@, Len(+ 2 8WxAbso~l@4G "?: ]\\*/eb= ~EQ 1oentf("%1\%2",:,GO)O42Addrevsy)_IToU@`_n &HF Then LPrintPf("\zc2[rgb]{%1} ", ;ToRGB(1)0FiA1 To rcc iny r_c.Item(i,c,i +T(c, 5+ c.MergeArea;lumn >D,) - 1?Ndi 'A's'GG' Struts and eof li neGQ%1\\MdC(r)), Tru M}-E}A= Check¥BorderPHorizontal (r.Of0fsetmC:=1!C, Bottom:=jn#bIj 'F (theB:* 'TabxenO8DJ@q"\{tabular}%HEs 4c VIs NothmW>H `"(emp` 2r)" QExitF)J$. e@%1: %2@kM\e.dr E, %!@M e! #!BA2 c- -(ByVal pBa.dbb .s(1mpEvIs.Raise N d  ' Clas`mple'a24!E31!Fvg Long#eEOrDisplayrma"Y).In 1@B#6ow.P ize(iS:=1).OffsetT:=-$ ɕ" p$ 7)kqHHk'rBelow<=!BooXleadr'(>, 0) <> "c F R g@# spaces IntegerλTo ˸b7 JDebug.Ass ;`1s S8rAbove;*l* q*)=d)08>)Qsw l5OpenFromb!!qb޲, K5a`5o*pG+>^0D(9D -+ A9Yt IsMi  bbOpenLine = Falseh E hPborderStylResolveHorizontal(rBelowColumn, rAbove)( Y<> xlNone0End If@ ApdToRangeSet s Def, fFrom, .bq.O - ] + 15Next; 9.s2unt 2-Dim HLCmd$, CaMoreIf booktabs Then  Top  -"\topru8le" }BottombB Pmid w*hlED*ID4IIfC, "\cRmZs"@" 6' Straight ? => revert to old behavior T@Printf("1-%1)_'return nothing, \D orD^=S,$v  Select CaseNf "xlDpoubl(aDŽB Space(2ss)`f=+ pvbLf <CinuousGߟL RT "h Z%# l@"";P$E J&a+ "{%1}`KRepNl,b:";"}" , ")D>kFunctio P:ic Sub (ByRef AsAdOTCLo!XB0yValgBo0oleaclCurrentPos *)@ p<= 0l8= g@w%1%x3%2)Χ, "/a;f-a -b>i e%w1(Q10 -x1 p!rivate " [ "ϡNb), "T / PDOrDisp.yFo0rmatT).!Gs(xlp).t2 YIs NU" Exitv (?0, B x 1 9B231j2 `nx"&1b7U Orn2}q%X,b 43࠳ 'AddCell&$EbFirstFbLa)Ror&)1KHtxtASt}ggnåKlϑ,A (rQ#bRequiresDiffeRV0A $=pneu5 'Check fmulticw5.Merges1/) ' c0 JWith RAreaf= l20qø& n> 1Oe ' p( cЈ`ks o(nlyf' row of a =-  Is*pOfM1!A1#E`\2 р[%3]{*0}{%2 , , Get,uts4kUُ)(f`)!,!7A({%3_{, ;/&,Qb D,(k')O    'sГ!6= !sU)T n bLastCell Then " If Width > 0 xAddText PadSpace(nColumns * (3 +) - 3Len(txt))End IfT" &" !G<;lse[v@bLf & IndentH5)= n Functio Private Forma(ByVal r!As Ra nge, Rowor&) String: =.)ӊ#ConvertSpecialChars(, isnu@meric(+.q.ue2 kFxontJy Ori^aQIdP, W@"la[$, cAmD$imnt&, IntTornAKvOrD@isplay7(). . {Ef'Mw,NEJi/`n@tf("\t`color[rgb]{%1}{%2}", b ToRGB5d$), A dE=j( <>:Beme&)+ =_# 䜩* ))@_ |/|!0%%1, %2`3$(R@ound(( BA`&HFF / 255, 3)O( w00&`H100 40) mn`$;%sANumberBooleanp* ='Check@ for sà Rcactsalways c# if D`DDollar Or dRe|, "\`>gbackslash{}"$c: $ $ Fb`_b_odoi^b^e> skP %%// &"&/f _5\#"#//e$3 1,w.Merg`eArearunths`!8/If IsEmpty.Value2) Then' if the c: is e, ignore alment chs and on lyvline f -a Dwadder removedRequiresDifferVAH(Len( f) <> C- )WEls8?{@Hg.y #`MacvBisn't support iin E1b* 6(,anepto ' actualpeck again@-Applicpon.Vers@b,q tq?c _`(Objec! al(n) >= 14#"_P/_Kt $p0orBa (07rearl0ier,&qnoO!1 at +j ugs ba pB r it pass)Q)llYzS=(TxME(6 << <H `@x /Opens the main dialog for converting into LaTeXl 14 ` -Converts all configured selections into LaTeXe formal 148%$vY$*\Rffff*0J597e2161 > @ XH ^ Z "`  \   ^ :x  V L ,h  "     "   8 Excel2LaTeX: The Excel add-in for creating LaTeX tablesR Converts the selected cells to a LaTeX table, that can be included in a .tex fileW via \input{"table.tex"} or that can be copied to the clipboard. Most of the formattingjT is converted too. You can put additional LaTeX code in the cells, which will remainz t untouched by the converter.'^V Copyright (c) 19962016 Chelsea Hughes, Kirill Mller, Andrew Hawryluk, Germn Riao, and Joachim Marder.W This work is distributed under the LaTeX Project Public License, version 1.3 or later,3 available at http://www.latex-project.org/lppl.txtP Chelsea Hughes currently maintains this project (comprising Excel2LaTeX.xla andF README.md) and will receive error reports at the project GitHub page,& https://github.com/krlmlr/Excel2LaTeX`  = = =JC@qo A@o۳Attribute VB_Name = "Conversion" ' Excel2LaTeX: The@ add-in for creating H tablestzts trselect(ed l$o a 3,$at can be in0clud,ea .tex fileTvia \input{"mH"} thAcHopi?to|clipboard. Most of`mat_,0is cRtoo. YouH6Iyital[c odT/ells, which will remain+untouchFby2 r.Copyright (c) 19962016 Chelsea Hugh"e/Kir-Mller, Andrew Hawryluk, Germn Riao,,and Joachim M~e9Thv work disd under)tProjm Public License,B D 1.3^l at$vailA chttp:@//www.Ax-p.org/lppl.txt@ K; curr@ently RtS@+Jomprisȩ.xl a >README.md)Afceive errrepor@*GitHub pageR1s2github.com/krlmlr/H X Opp@Ki16 SR(), ݂.De0scri @OpX`= dialogÍ;i@mcDataInvoke_FuncAl\nT14@ W NewutroJ aSet .ViL=A!M`l@ Def0ault"St %$<'8d0 6> %'8k 8  4B@@ 4$B .B@@.4i  =COUNT(%1) D$ (Fo !F !F $'<iP08 J!L Excel2LaTeX7. N! H5@. Excel2LaTeX ( R (Pkqi..T]`$.0 0Gzj] 0%.V]] X  X> V%' Gyj X  B@@  TB@@i]0$.0]P 0%.Z]p] X  X\ Z%'8 8 X' zki]$.0]  0%.V]@]X X  X> V%'8 8 X'^z@k80i(p$^leteAlljJ, ,;@ cmdOverwritejJ (*;8cmdLoadjJD();<cmdStorejJ(/2@Label7re6,.4lvwStoredTables5  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmCo x M xME$  SS S<2<<.P:For Each bIn Ms% Okrr`ResuNex l = -1CP$( GoTo 0'P Q Be# Debug.AsH>$H@mress"`A DTo@+mulaL c9c, N.Cells(1, e xj g%? bG5Ɇ &x- 6.RaiseChhd%SubGRemoved$}Ods1cY+ 1$ #Dele@UpC;Item@ak`J~)E@*mcpɎ WorkscD;Ju/S1KImot0hing*qit %K] EJ_O RROcQ $Yg7JD:qM9P S ng, s7QA"q`Pl!= 2 0G~3 r= Di AppЇay.&.CountA() "stDtor[cc o$ 1 B\Up\WQDLR( ! =T"N= @NToP2N!";:=e|/O Oa1. !p")glw=2+To"z(X 14#8S! y8o]TdvddTst-,z 3rAe-tB.'ntf("=COUNT(%x1)"40Q Seh CS0heet rU~| WrU (` (` (` (` (!` nLW xME(SPSSS0{AEFF9717-4436-42D1-8F26-6A3475DA6005}{4F95B388-7E4E-4DFC-AB4F-CB641E4EF16E} x@ |% %@@$vY  " " 2(`0P h xxA@zo`@ Excel2LaTeX v $ 3.5.0 ~(! Copyright $  1996 $ 2016 Chelsea Hughes, Kirill M$ ller, Andrew Hawryluk, Germ$ n Ria$ o, and Joachim Marder (MThe development repository and the bug tracker for this package are hosted at - https://github.com/krlmlr/Excel2LaTeX  cThis work is distributed under the LaTeX Project Public License, version 1.3 or later, available at - http://www.latex-project.org/lppl.txt  dChelsea Hughes currently maintains this project (comprising Excel2LaTeX.xla and README.md) and will =receive error reports at the project GitHub page (see above). (d ( (oxAttribute VB_Name = "frmAbout"  Bas|0{AEFF9717-4436-42D1-8F26-6A3475DA6005}{4F95B388-7E4E-4DFC-AB4F-CB641$F16E} dGlobalSpacoFalse CreatablPredeclaIdTru BExpo se0TemplateDerivCustomizDOption 0licit` P"& Sub cmdCl=_Ck() HidOEnd UserForm_Initialize Label02.Ca9ExcLaTeX v" & ChrW$(8202)"3.5.0 1ICopyright 169B 1996I11201 6@e@ia Hughes,_A6"KirilHl M25C'ller,vbLf+Andrew HawryluBkGerm25(n RiaB4-o, a\Joachim M arderDFTextBox1.The development re@itor ytbug tracker for this kage @ hostata"vbCr8TI"Mhttps://github.com/krlmlr/zJTA& work @(disdd un@ eKHProje@ct Pub`U License, versA\1.,3 er)va|ilBa_J www.A x-p.org/lpp0l.tx&^ChAQ curr6ly maint`s3$(*pri0singwFh.xla_V CsRxV CsR @.F MEL(D4@0,8<@SPSSS"*"&"6"."j"2"`00 h11r<$26" (o0 ]p !'  0B@h ,  0B@@  (o  ! 0!% /o ! 0B@ho 0A@oH vB@No H (do` L (do@0 'H !G  ,(ZjoH  ,(  ,! ,!'ko 'L !G  ,(bjox ! ,/h ,! !(o8T This is regenerated every time the form is activated in the IDE. Just keep it here.oHA@oQAttribute VB_Name = "frmConvert"D Bas0{F619EEBA-AF4B-4B76-A9E6-C8494C107D04}{07952267-DC33-45C5-9511-2765BD3E1A5F} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDO@ption 0licit I&ements@ IView P ,0 troller A z.VarH elpIDn-1 &WithEv4. QmModel,BS!  StorageBJGJ XActW@kSheetA$WorksJ 7bIgnore/Boolean!' ' iEaBProbpy G&_ǖ()O SP@LhI E8nd e Q(ByVal p ~)h HR#=i .-:#?"''"&!#5_$E! d D$gA9LoadedTpsLis`G"Subhow`r6FormS17staDMe. - AT"Q' yTFun hSafeRange@c` %%_$V""O rror Resu@Nex Q J.G CIUnOf"AndIts? '#Dim p&= Q"p /If Is Nothing TheA!!v=cERwf= u( ,) 'If;(AutoApplyBox_2Ctk(Sutton.En!-{ 9.pF~ R Ss + chkWkІFslueUpd}ss4Dar?s 1?Float" 1EQc.CellWidthp&txtSizP8Ind$lvwqM_ChCe6bSelect`8Gs= (.aRx >= 0'cmdTx'62%Dte/ed&Owri_a s_DblC1CuCanccMSVs.Return$ *M D!//"KeyDownZCM+Integer, ShifBt s CŤA46 ' pet"P u AFw t mE# TxargЏ5[ eGoTo errfxail G0pVisip9Exit33A Drs(:(c,Rd0s(43^) ?]0CSi V :Ƴ_|el4d4pI2k=y.8C ?=׌InitFrocX`apt.m "P.ؽ&ubQ0m߽08{#qlt @spuQ oq#\dTablesList End Sub Privatep SetResult(ByVal s4 As String)  #If Ma@c Then"txr.Locked = False^If 0Text.k #"fTru eConvertSelection(ffmbIgnoretrolEventso Exit| mModel.Get+s( pFocus ublicaInit&pISWith 0G.Ce llWid = a(Me. SizeOp=~sZ-EAI|nd@> FileNameC@n%A_*;8FroO 0c## N!02af-U|pd%%]D=H*MwBrowse_C k bs ~`KAppaAAaSaveA ($Absolute, "`TeX dš;s (*.tex), "6HG `2"[3m+AxiCancelHidpvc-Qopy[!|V BA7 A$Win32| Not _+0pBoard( t)"yx#EօaObjq.New xDat~W$.b6/PutInb#uL#!0ǂToԄS`qV,)m1WUW[Alx*sunt - 1O1Owrit1 l`LongSS 4= sd exsF Remotve+Ol,Dl _ W Ñr\et m`Pler.ә=n.l( <4 #D z #ExportAlZ= A)@$:d s tCommandButton2frmAbout.Showspn1_rU9~./ $ ntS On Err aI1) 5(#)@NAuto1ayBoxY`""Z qCnP\ D8Q}M p/0.#a ec//"Elt nֹ?icC}VAY刾9YUser@m'ois regener`d eWy tiP(the form!aA1d in IDE. Just k_eep it here. End Sub Privatep UserForm_Initialize()  lvwStoredTables_Change9ЁNӍ49x9ЁNӍ49,f:B1+cMEPSS S"6"."*" 26"N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5},!phH@ %)h  %,!h %) % Hh $)<@%,!h(%) !%  h,)B%,!Jhh`0%) A@% Jh4)H% `8`8%pH %(88@< h$vY$*\Rffff*0P597e2175$*\Rffff*0Q597e2175$*\Rffff*0S597e2175$*\Rffff*0U597e2175$*\Rffff*0T597e21754 B  B (0" 8 @H BP X`" h px B "   " xm`pmHm0Hmm mhmPo80eAttribute VB_Name = "IController" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |@GlobalSpacFalse dCreatablPredeclaIdC@ExposeTemplateDerivCus tomiz EOp tion 0licit Pub Property Get Events(`) As  ' End"Model">S>ByVpal pC)>View?B B'StorageD?D !!Sub Run( @   D, cOX!h*=h8+3qqEAh~ f“Nh [>2xqEAh~ , cOX!hME(SS S6"N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} X >`%@ %@@H $vY$*\Rffff*0P597e2175<  " 0xtP@uXoXP Attribute VB_Name = "IControllerEvents" " Bas0{FCFB3D2A-A0FA-1068-A738-08002B33 71B5} |GlobalSpacIFalse dCreatablPredecl2aIdCExposeTemplateDerivCustomiz EOption 0licit Pub  ModelChanged()Sub Raise   End    D-ᐷ|0>OB}8\*=h8+3qilj F{ɗ0I<2`C9xilj F{ɗ-ᐷ|0>OB}8\ME2l0s None&H0  teT/Envir@onmenth&H1Book s 2onvertMathChar4 EndDKPropy Get Ev1s() As  'E D7CI;ELEByVal D"G)"Ind32nteger!DC!Dg CellWidth1!!"FileAC"SngdCF"*KAbsol Lv&gFDRangeAddresTQ;ibfFunc"|`Cls}Resultr+fSub InitDefa1 kDescr~i|8&#? S rb(%p%>%) %,!zh ` %ThisWorkbook_VBA_PROJECTCSheetStorage|StringBuilder4(SS S6"N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} Z `%@ %@@H $vY$*\Rffff*0R597e2175<  " 0xtP@uZoXPAttribute VB_Name = "IModelEvents" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacFalse dCreatablPredeclaIdCExposeTemplate DerivCu@stomiz EO@ption 0licit (Pub  Changed() Sub Raitse  End  tC<8i <=;\ FG@j*=h8+3qY8?>pI Go-xY8?>pI Go-=;\ FG@jME PSS S"".06"<N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5}x,!phH@ %)h  %,@ ` )<%I @i h``$i#,`(%) %%p ressh%@@, $vY$*\Rffff*0V597e2175$*\Rffff*0Q* b % <@I5g=*=h8+3q!@22d ?x!@22d ?@I5g=RRME PSS SHr"j0h6"<N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5}(r ,!h`X%) %,!zh ` %) a % Az`h8$)zX` %,!bh(i Ab h,ib,!Zh`0i AZh4iZ,!@h 8i Ah<i,!(h@i ,!`h@Di 0 AhHi ,,  `Li  r` `P,!hTi @,!h0hX%)( % hhp\) %%j~CjxCjv@CjtC@@``  0`%0@`"h$vY$*\Rffff*0R597e2175*\R1*#278$*\Rffff*0Q597e2175(*\Rffff*0Q597e2175\04 F   (0 B8 @H BP X`" h px B "   B "   B "  B   B( 08" @ HP BX `h "p x B  B "  x '~'x'v'tHm0mm`mhmP m8m m@mmm`mi ox`m`mH0m0(\Attribute VB_Name = "IMo@del" Bast0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse dCre atablPr@edeclaIdCExposeTemplateDeriv%Customiz EOption 0licit Pub Enum x597e2175*\R0*#1d$*\Rffff*0U597e21754 B  B  08 " @ HP BX `hxxm`pi@ o(ifAttribute VB_Name = "IStorage"  Bas|0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacAFalse dCreatablPredeclaIdCExposeTemplateDerivCustomiz EOption 0licit Pub Property Get Events() A s ' 0 End!Func/Add(ByVal pModel#, @ lIndex -16Long1(1Sub Remove0*=) &@7Item6Colle,  DbYE˚*=h8+3qMm6;FR6q]SiMA xMm6;FR6q]SbYE˚ME(SS S6"N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} Z `%@ %@@H $vY$*\Rffff*0V597e2175<  " 0xtP@uZoXPAttribute VB_Name = "IStorageEve@nts" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse dCre atablPr@edeclaIdCExposeTemplateDerivCustomiz EOption 0licit Pub  Changed() Sub Raise  End  d8 <q+G!P#8ɷ*=h8+3qx.LZxx1xx.LZxx1q+G!P#8ɷME PSS S"&"206"<N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5},!DphH@ %)h  % Dh ) %,!JHh $%)@ % Jh()H% N`,)`%@%pH%`h@0H$vY$*\Rffff*0T597e2175$*\Rffff*0U597e2175*\R0*#25$*\Rffff*0S597e21754 B "  (0 B8 @H" P X` " h pxxm`pmHm0HmoTAttribute VB_Name = "IVi ew" Basp0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |Global!SpacFalse CreatablPre declaIdCExposeTemplat@eDeriv%Customiz EOption 0licit  Pub Property Get Controller() As I '` End S ByVal p!())KStorageI$HD#"!Sub@ Show(M od4@FForm@7stantsG rU~|   9rU $`P4` ,`IStorageEventsWin32Clipboard CVolatileStorage"!{IControllerEvents$+ KAttribute VB_Name = "Memento" Option Explicit Pub, FunclModelPropertys() As Sng()  Const NAMES8RangeAdd ress|ns|CellWidt h|Ind|File[MsJSt(b, "|"yEndToCollef(ByVal p{0TIhiS8et  CNe w Dim sc,VarianhFor EachIn, ";. CallB(`,', VbGet)#Nex>sXGC989V[& Printf("%1=%x2;";]BD@SdubqTo, F~xGFEFO@rrRes~u2E?IJFFVbLet, p&(BRF GoTo 0E"ai&$.S}$ksgtings!$#aCFA}F ~;O~!-l1A LonggsKey@ue-r= 0 @!UBound(h&@ &(l1n0b#!9zg9 =D9s 7QATo ] 6㣃 f5& D& B TE +P qqMa<PE ;U-To+ +If pCIs Nothh The xitaJ& E'%1'!%2` .Worksheet.i0e1yT To s1 B 7# Vu"onARpca.(/ES `SaveЋversVltToe! S%^uc s=D=.Absol0" CSOp K@Output1c3B #1PR . ` ;Clos>e7+_pAllStoredI0tems!agTI8OYm cq AS@5Q 3SZ1Z.C[$1DZ%+p`H)h%+`iv% :X ` )<8%`d  ` ) 8` 4!`! 4I`A 0q`! ,`a0`a, ` , ` n597e2175$ xME (SS S)"C7)  HFuncKAppend(s}AS—CIf >+(s) > 2 *2) Then I7MC9&E9 s)DAE2() P\IfF/B-0 *Mid,F81,9)Rs34~=LBZCSiX@MӁ^QcTo^CucC % Left$ + rU 0a  i a i 9 a /4 a PROJECT@!0f<oACompObj Eale|teO,>GoTo 0 r \qByVal pAs IWDim lIndex Long > =.Add(DefaultModel()"ebug.Assert'= 1%CpB IBCSet D=AsICC.CellxWidc%+G4242C42<>42C#$Q.RemoveDCGetItems.Count!G \(1)JLnO6|Md, 2_E:7ω3d0m(I],&L[5/3?{?Hm,qH?N(N5-$XQ$.3d 6cB_Append|Tob` ^ CasLine`S%a laO From_$m , J, TrueH@1A Fals /, -? "$ >? D./t/"4969, ;4o _en?UT0? Q-1/&/%t6o 6ɠ_"11-5 .s)Builder .sbg+7tt  Len(sb.To?| ԇp("This ")("atof "the. Z 'ncrementalYexpansѣV "ability.I" yp a  ` i7 vbNullC"o \t o o e>ro o  "> "Now I'm adding a very$ l sP tBothat$ correctly handles4s arPp & _3L1" mon do0uble`enfgcubuffer. Godspeed,! Lm iplpsit'_@t, ns! etur0ipiscqe#.6@ndi h0e(rerlus ligula, sodar_DELETED_NAME_56")_DELETED_NAME_57"0_DELETED_NAME_58"_DELETED_NAME_59"honcpnunc "portti vitae. Integer0mmodo st@lum suppit. @Donec r4ict@ac$ tidco0 0umO.p$q;O.DC$5$/ ###SL`#r####;##pTY#r #"#ad#a#t##?D####ll##bgd-T`z%fDbigDSݱtringBuilder up-front. Will it choke? " @& _ "Lorem ipsum dolor s`amet, consectetur ad ipisc eliSuspendisse hQrer8l/us ligula,qsodales rhonc+nunc porttit~vitae. Integcommodo vestibulsupDonec ulc(tell(sac tincPiduno[mentum. Etiam vol`utpat\, a?neque temT QVIaucurV nislhrd!_et muada fs Oaxprimis inuczs.").ToS!() =Th (st ofldka big sB to ߿a "aEE End Sub h0H "PX `pZZVHV ((  r CommandBar, too ls Popup, new.Control8Set= ATppHa(.s("AHshe B "("=qBs(6 % Find&(Tag:=J, Recurs|:=r@If NotJ9Ishing Then.Deletu,K!/,.Add(Typ@e:=mso%B uttonrefDor@3, orary 'H.2π3\IOnCY= T@tipTextO{%R=eSZ_a#q`.Mac+ )' jcel 2016 , we can'`Kanipuv mih/aa d( NVe= 158Exitne#ApIfn "4&vert TBto LaTeX",B s@.e8bAll w Dim lUBound LongsResulYvElemenVarianVTex Na(sFirstCharSPosQCurrCdWIf IsMissing(xpThen[= -1 Else7*)If' Handle all tokens:CBD%~Szt(r, "%"G 9@ry of is tZunti!he fAQ oHccuDce %Start from secoO@)D" lm= L() + 1 To :Mneft$ (), 1D2 Select Case@E|"1""9 i' ipeter: L@ookup @X inserġ va= CL@G,) - yE "A@Q   #<WI9CM>;0YF#DRJ}PJ˒D}x#DRJ}PJ˒D}WI9CM>;0YME8 [LSS(L(L(L>"LLLL<<<N0{00020819-0000-0000-C000-000000000046} @`|k8 @` k<i ii. p  % l*% h8% `:UA & Mid>2';%:Deb0ug.ASFamBSpec i`BcJ: %% (or % ees)$]a }a'*@signo@)njuA !#)ih#/A' Silt=othex$k ?bw!=rCN#' Combine< r'C@Joinc} %ԁ֐Sub Keueǵ, ByRef s@K{lC}@VBA.In(1, b =KA|!{0,z="}A's`Qk7LdB@cB4 #Aeqpg?@vaЅ Test_S(C*7"%1"abc")"f("Thg a %2%1.tq(not)o simple) .Let's`ke how it h^les out-of-rangPPAasRpfAA%y,bevenTB`CC gdqO '%%%!%1h+6$4dq+梓S @ =cd0`4'j0abOt 2Scd=ef074do/H cey1&k  0Php .     @( 8 $@  htr(GlobalFree(hGlobalMemory))(k$ Open the Clipboard to copy data to.$+Could not open the Clipboard. Copy aborted.A@$z8k0 Clear the Clipboard.A@ Copy the data to the Clipboard.  A@($Could not close Clipboard.A@$k'.ixphAttribute VB_Name = "Win32Clipboard" Option Explicit ' this code adapted from Stack Overflow: "Excel 2013 64-bitA:  API doesn't workp' http://sMoL.com/q/18668928/(214 8changto use CF_UNICODETEXT, and RtlMKMemory instead of ls trcpy$#IbfO7 A Then PrivaDeclare PtrSafe FuncGlobalAlloc Lib "kernel32" (ByVal wFlags As Long, dwByte +)& s _Vuec a.A abor.@0'Debug.?nt "{retud0 & C2(| xME(6 << <@+`@77?i`  `*`` .`% 0*``` p8`i9i.i8` x` ```88x0%x$vY$*\Rffff*0Y597e2175k B  (08@H P `p x    B  0Php .     @( 8 $@  h x  0 *    *  Ppx   "   (@H "P X`x$ "   0P` x x]]]]]]8]P]h$$'d 'xkp Handle all tokens: %$`'< First entry of aText is text until the first occurence of % H Start from second entry:    $$ ' 19LT ( Positional parameter: Lookup and insert@ X  '  o La $'sid9 Default: E.g., keep %3 if only two parameters are passed% 'k  $$  +%KTEKT * Special case: %% (or % at end of string): $ keep single % and ignore next token% $ +  'S $ Silently ignore all other %x tokens% $ +n Combine result: $'iH]  = %'  ''8d   $ '   $ '8ko8%1abc$abcEThis is a %2%1.test(not too simple) $ This is a (not too simple) test.EcLet's see how it handles out-of-range parameters %3 and occurences of %% and %y, and even at end: %$bLet's see how it handles out-of-range parameters %3 and occurences of % and %y, and even at end: %E %1%%%2%%%$%1%%2%%Es a o x]]ab=cd  8A@p abE 8cdE ab=cd=ef  8A@p a ver abEto 8cd=efEuilderabc  8A@pin abcE 8EubleoH@nAttribute VB_Name = "Tools" Option Explicit Pub,   GoTo OutOfHerec E0gIfajK[c`O da\to)*m(0&)@/&opp  !Ex (" C`A&( l% Sk=*f:7Ky(o8 c| U!_S`T\rua;#U8p8   i `p` "i  i @i˜BBʘBxo#(ipf{o%'PCompObjprU~|   krU ,ypay(1 p(@p( `p(p(p$p$Ip, p(8p0`p  ( `0n *@p6G #xtH X4v  GlobalAlloc4GlobalFreeT GlobalLockt@GlobalSize`GlobalUnlockOpenClipboardCloseClipboardlEmptyClipboard$ SetClipboardDataLGetClipboardDatat8RtlMoveMemory xME`(> << <+p@  i`i+ p   iory +@@p @  i+`p`  i Loo+p  i+`p@  i++p +p +`p   i@theri+8p8   i `p` "i  i @i˜BBʘBx+.` ))i``` `"˜B˜`@Bʘ B``@`%x $vY$*\Rffff*0Z597e2175D b 2p J H H H H  H (H 0H8H@H HH P( X  ` p    B  \ 0 (@ h: : . H h: L08 *@p6  &  08$Hpxx[ this code adapted from Stack Overflow: "Excel 2013 64-bit VBA: Clipboard API doesn't work", http://stackoverflow.com/q/18668928/2146688tokensD changed to use CF_UNICODETEXT, and RtlMoveMemory instead of lstrcpy  @``]D]D@]D  `]$ ]$V32-bit code by Microsoft: http://msdn.microsoft.com/en-us/library/office/ff192913.aspx]8P]h! Allocate moveable global memory.   $' GCould not allocate memory.A@$Fzj4 Lock the block to get a far pointer to this memory. $'' Copy the string to this global memory.  $& A@ Unlock the memory. $  /Could not unlock memory location. Copy aborted.A@$EDebug.Print "GlobalFree returned: " & CSME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0$vY xpAttribute VB_Name = "Working" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 O@ption 0licit ߶0* pHd Excel2LaTeX8@ = t  $vY( J< rstdole>stdole h%^*\  Tools0Y597e2175 Tools Win32Clipboard0Z597e2175Win32Clipboard Working0F597e2161+Working M0x8 `hXF,8`,J$U#T&לC},+҆MӏShG7?p!`CCU%WuJGAgK>]Hm+KgM/*m{ eDo`ZCzzV8@A~ωu4/m\G&{ a6G۫U"?L!(^x'I3[= ģErIgG糎O'ģZ[L@gFDpEUjш8EBHWǵHهE}LWUVB J"և{[FtFބf P] ۆYJШ8ACqUN],-@|Appenda ImplementsNameText Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# Excel2LaTeXgstdole`OfficeuMSFormsCVBIDEA CController8c _Evaluate IControllertmViewO IViewmModel IModelmStorage IStorageYmpEvents, IControllerEventsIController_EventsPIController_ModelQ`pModelaRaiseModelChangedn~IController_ViewpView: Controller&IController_Storage0|pStoragepStorageIController_RunGShow vbModelessZ vbModalt CModel:sb_ StringBuilderUi CellWidthĵ convertDollarYbooktabs tableFloat&lIndentC sFileName RangeToUseRange  IModelEvents"Class_Initializen IModel_Events'IModel_Optionso ( x2lOptionsY  x2lConvertMathCharsk  x2lBooktabs  x2lCreateTableEnvironmentv]Options oldOptionsy  x2lNonen RaiseChangedK IModel_IndentiIndentjIModel_CellWidth  iCellWidthIModel_FileName iFileNameFsBaseDir`# WorksheetDirfUCase5 IModel_AbsoluteFileName9(PrintfIModel_RangeAddress%E(RangeToAddressiRange(AddressToRange֎IModel_GetConversionResultrirc^cZFileNameji`japosAddTextQleavetSpace  WorksheetGetColumnsFormat)LRowsUHorizontalBorderTop5Count0vCellsRowColor GetRowColor- ColorToRGBY9ItemzAddCell_/ MergeAreaColumnsp9 GetStrutsOffset RowOffset&BottomH{theend0ToStringSaveToa  *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{0B79C153-4108-41F6-AF3E-52F5EB1DB996}#2.0#0#C:\Users\Chel\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M f*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 $vY   CController01597e2161#CController  CModel02597e2161U CModel mConversion0J597e2161Conversion 0 CSheetStorage04597e2161CSheetStorage HS CVolatileStorage05597e2161a CVolatileStorage ` Factory0N597e2175nFactory  x frmAbout07597e2161wfrmAbout ]frmConvert0W597e2175ufrmConvert P8 5IController0T597e2175'IController P  "IControllerEvents0P597e21757"IControllerEvents  IModel0Q597e2175/ IModel +IModelEvents0R597e2175kIModelEvents IStorage0U597e21753IStorage 8 oIStorageEvents0V597e2175IStorageEvents 8 IView0S597e2175+ IView  PMemento0X597e2175\Memento  hStringBuilder0A597e2161YStringBuilder Test0B597e2161Test 'ThisWorkbook0G597e2161ThisWorkbookRegistry۹IModel_InitDefaultInitFromRegistry~GetDefaultRangeGetDefaultFileNameIModel_Description^H IModel_RangeĹpRangeAreasKRowRangeOrDisplayFormat8/Interior;Color2F (StringToModel GetSetting SaveSetting (ModelToStringParentPATH2 SelectionZ CurrentRegion|sNamed ActiveSheet%NtxtLineFeedvbLfT%PadSpacene Application*WorksheetFunction&MaxȲrRowd bHasTopBorderbHasBottomBorder;HasHorizontalBorder bSkipFirstylStepwcn\stgVerticalBorderHorizontalAlignmentS@VarTypepValue2vbString`eWrapText} MergeCellsکLTrimbStrSumColumnWidthsU ColumnWidthxlLeft9xlCenter xlGeneralbIIfzcolH pRightRange VerticalBorderStyleJ~xlDoubleE xlContinuous[xlNone pRightRow|pLeftRow5b ResolveLineBordersC" LineStylewColumniResize@4 ColumnSizeu ColumnOffsetʚxlRighte rBelowRangevspaces rAboveRange)X sRangeDefQT lLineOpenFrom? bOpenLine borderStyleS rBelowColumn' rAboveColumn^IsFirstRowOfMultiRowCellResolveHorizontalLine8AppendToRangeSetFvHLineCmdpCLineCmdm MoreCLineCmdReplacef lCurrentPosxlTopxlBottom?line1line2rCellh bFirstCell' bLastCellAnColumns#nRowso FormatCell*bRequiresDifferentVlineFormat[RequiresDifferentVlineFormat0GetMultiRowStruts0>ConvertSpecialCharsw% isnumeric$*FormatCellFonthFormatCellOrientation:FormatCellColorF cell FontColor{h InteriorColorlFontURoundsTextNumber-pFontBoldItalic! Orientationw xlHorizontalxlUpward  xlDownward  sColumnFormatc sCellFormatlRelativeColumnGetRelativeColumnOrColumnIsEmpty GetRelativeRow lStartRowlEndRowlRowbBorder  DisplayFormat4 ValVersion ConversionM(LaTeXg (NewController[ViewI(NewViewBnModel9(NewDefaultModelأ (NewStorage}Run_(LaTeXAllToFiles<(SaveAllStoredItems CSheetStorageo IStorageEvents5MAX_DIMNIStorage_Eventsu{ IStorage_Addp"lIndexlFreeRowGetFreeRowIndexGetStorageSheet|FInsertr xlShiftDownccColumns?, CollectionW GetColumnListo<cValues(ModelToCollectionsKeyh lColumnIndexe(ModelPropertyNames> CreateColumnAddressToFormula1IStorage_Remove$Deletex xlShiftUpIStorage_GetItems. pStorageSheetcKeys cRowlColumnxLsValue$CountA38FormulaToAddress ColumnIndexPAddr(CollectionToNewModelsAddressFormulaqYbCreateActiveWorkbook WorksheetsErroVisible xlSheetHidden4 cNameList pFirstRowl1^ pFirstColumn,_RowIndex6dGetFreeColumnIndexb CVolatileStorage4 mCollectionBeforeAfterXRemoveϱsModel(StringToNewModelyN Factory](NewModel InitDefault frmConvertL frmAboutcmdClose_Click!PHide9zUserForm_Initialize5cLabel2,CaptionxChrWLabel1,TextBox1SvbCrLfSelStartZ SelLength mControllernmControllerEventsן mModelEvents{mStorageEventsmActiveWkSheet&mbIgnoreControlEventsgIView_Controller pControllerEvents4 IView_Storage}LoadStoredTablesList IView_Show,ModalFormShowConstants}SafeRangePrecedentsg PrecedentsUnionOfRangeAndItsPrecedents pPrecedentsuUnionAutoApplyBox_Click ApplyButtonEnabled۪ AutoApplyBoxValueKApplyButton_Click6chkBooktabs_Click͛ UpdateOptionsR|chkConvertDollar_ClickchkTableFloat_Clickϱ txtCellSizeG txtIndent'lvwStoredTables_Change. bSelectedlvwStoredTables ListIndexQcmdLoad cmdDeleteV cmdOverwritelvwStoredTables_DblClickbCancel ReturnBooleane cmdLoad_ClickLlvwStoredTables_KeyDownKeyCode ReturnIntegerShiftcmdDelete_ClickmActiveWkSheet_ChangeVTargetFerrfail Intersect1ConvertSelectionA{mControllerEvents_ModelChangedm InitFromModelmModelEvents_ChangedL SetResultaGetConversionResultRwmStorageEvents_ChangedsResult  txtResultY)Locked SetFocus InitModelV GetOptions1 txtFilenamed SetOptions4 cmdSelection+ RangeAddressClearGetItemsyAddItem  Description  chkBooktabsxchkConvertDollar chkTableFloath cmdBrowse_ClicklGetSaveAsFilenameAbsoluteFileNameLcmdCancel_Click\ cmdCopy_ClickP(Win32_SetClipBoard#dataObjj DataObjectSetTextPutInClipboard cmdSave_Click(SaveConversionResultToFileqcmdStore_Clickʑ ListCount6cmdOverwrite_ClickXcmdExportAll_ClickACommandButton2_ClickspnCellWidth_Change9B spnCellWidthPspnIndent_Change spnIndentEtxtCellSize_ChangetxtFilename_Change1txtIndent_ChangeficmdSelection_Clicky+UserForm_Click ModelChangedChanged MementoNAMESοSplit) CallByNameyVbGet(CollectionToModel pCollectionLVbLetA sSettings aSettings/ (SplitKeyValue  pSettings,Address sRangeAddressEcItems1 INITIAL_SIZE[|m_bufnm_lenRLengthYsj Test4Test_VolatileStorage4 Test_Storage9Test_SheetStoragepSheets lIndex2kTest_Model_AppendToRangeSet6WsLineDefR]Test_StringBuilder- vbNullString ThisWorkbook| Workbook_OpenCreateMenuItems$CreateMenuItemActionRFaceIDi myMenubar҇ CommandBar toolsMenu`wCommandBarPopup  newMenuItemCommandBarControlP CommandBars ControlsK FindControl mTag& Recursive msoControlButtonn TemporaryOnAction TooltipTextb?FindCommandBara Tools6sFormatüValues lValuesUBoundj<vElementlTextaText sFirstCharY lValuePosN sCurrentValue IsMissingJoinM& sKeyValuelPos Test_PrintfTest_SplitKeyValue[ Win32Clipboard( GlobalAllocjwFlags܋dwBytes֐kernel32_ GlobalFreemYhMemʏ GlobalLockP GlobalSize6 GlobalUnlockƅ OpenClipboardhwnd/user32*CloseClipboardbyEmptyClipboardZSetClipboardData0/wFormat5tGetClipboardData/ (CopyMemory&DestPtrSrcPtr}sz._ GMEM_MOVEABLE GMEM_ZEROINIT5GHND(CF_UNICODETEXT (CB_MAXSIZE!MyString hGlobalMemoryVlpGlobalMemoryR hClipMemory XoMsgBoxRStrPtr6 OutOfHere/O WorkingzWorkbookkUserFormNcmdClosejClass cmdBrowsexCommandButton2} cmdCancelcmdCopycmdSave OptionsFrameLabel3,Label4,Label5,Label6,cmdStoreL cmdExportAllZLabel7,Label8,ClickChangeDblClickKeyDown.a InitializeN\ U5Yk   +7a& 4#'+o0,3 /3 &u-7 1w2]*+./ 6#:@@@ @ @@@CompObjC)aVBFrame)_DELETED_NAME_42"[_DELETED_NAME_43"; WG{00020430-;C 0046}#2.0#0#C:\Windows\Sys@WOW64\e2.tlb#OLE Automat8ion0EOfficEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE15\MSO.DLL#P 15.0 Object Lib0raryNMSForms>SFrms3D452EE1-E08"F1A-8-02608C4D0BB4TFM20L'B @a&/;"1lrAr00}#0r# 50 BB79C153 -4108F6-AF3E-52F5EB1DB99IUsers\Chel\AppData\Local\Temp\VBEb6.exdc;@!.E . `M VBIDE> VBIDEuH2@7Eл5.3ûVBA@6A676EXT.OLBHVisual Basic for #lic"fs Extensibilit\y @DCControll erGCCPn`}rl}r2H1‹"," "U"(+C@ModelGCMd|lA 2m=!v MG v r sin B'26 ! SheetStorageGU@ 2Se@tt@rag SI2\/S$HVol MleF )VltiFS@Hoq2e/r)#IFac)yGF@cDy@%v2o J8 "frmAboutG&f !mAb$ui2ro]@-*0-3y-t/--t_5#_=5IF~IF@FFek!? 1 0hEventsGE@]Qs`2%T RIRIRR_+P __Vs>2o r4IHQFINR656=o>q=_226_`uIViewGnI[idw,a2___RemP5oWMmm04oPMW F tStrin@gBuildQ+hrinPsBu"jAAw*t/lρ@ Y_Ra`>TesY1)Taq2,u9'?=7ThisWorkbookG7T iWhrkhop^=:oky`!&ToolVgTߑT'J q532ClipboardG2 W32`glpaPdd(_8_|S a/ *s1i)3A2Worki ng"H(1M$P, "0+  rU~~~y   CaptionActionFaceIDName /Opens the main dialog for converting into LaTeXl 14 -Converts SetClipboardData 1 GlobalUnlock GlobalUnlock 1  OpenClipboard user32 OpenClipboard q@CloseClipboard CloseClipboard qY`EmptyClipboard EmptyClipboard q!SetClipboardData qGetClipboardData GetClipboardData q CopyMemory RtlMoveMemory 1yWin32_SetClipBoard8y i  Excel2LaTeX CControllerCModel Conversion CSheetStorageCVolatileStorageFactoryfrmAbout frmConvert IControllerIControllerEvents all configured selections into LaTeX qpModel pCollection sSettings pSettings (pRange sRangeAddresspStoragesFormatValues sKeyValuesKeysValuewFlagsdwByteshMemhwndwFormatDestPtrSrcPtrszMyStringy)\Microsoft Office\Office15\EXCEL.(H  @ }3!R KQ_DELETED_NAME_44"-g_DELETED_NAME_45"i_DELETED_NAME_46"/pa_DELETED_NAME_47"r+nvert Caption = "Excel2LaTeX" ClientHeight = 7440 ClientLeft = 45 ClientTop = 330 ClientWidth = 12075 StartUpPosition = 1 'CenterOwner TypeInfoVer = 109 End CControllerCControllerCModelCModelConversionConversionCSheetStorageCSheetStorageCVolatileStorageCVolatileStorageFactoryFactoryfrmAboutfrmAboutfrmConvertfrmConDBTahomao(2DLabel2$(EDIT CAPTION IN CODE$NuTahomag$(EDIT CAPTION IN CODE#OuTahomag(OKhouTahomag!HU1S5Tahomagkbook (2DLabel1O(?4cmdClose+$8TextBox1q TeX Conversion.LaT Microsoft Forms 2.0 FormEmbedded Object9qversion.LaTeXAllVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmAbout Caption = "About Excel2LaTeX" ClientHeight = 4890 ClientLeft = 45 ClientTop = 330 ClientWidth = 7410 StartUpPosition = 1 'CenterOwner TypeInfoVer = 13 End (H  1@m}3SC3R KQK* rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 9썊QEV#v   !AiAY! 9ay i  Excel2LaTeX CControllerCModel Conversion CSheetStorageCVolatileStorageFactoryfrmAbout frmConvert IControllerIControllerEventsIModel IModelEventsIStorageIStorageEventsIViewMemento StringBuilderTest ThisWorkbookToolsWin32ClipboardWorkingF.E .`M 1C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA  y`F:C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXEExcel  p0FC:\Windows\SysWOW64\stdole2.tlbstdole !iL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\MSO.DLLOffice C:\Windows\SysWOW64\FM20.DLLMSForms  QSy AA>R 0C:\Users\Chel\AppData\Local\Temp\VBE\MSForms.exd QWFIC:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLBVBIDE  y FWI9CM>;0YF#DRJ}PJ˒D}DFWorkbook Workbook_OpenCreateMenuItemCreateMenuItemsFindCommandBar @ .Con&vert Table to LaTeX Conversion.LaTeX FConvert All Stored Tab&les to LaTeX 4Conversion.LaTeXAllToFilesF Excel2LaTeX F FVBE7.DLL AE ` $Worksheet Menu Bar F  F F FaceIDLaTeXLaTeXAllToFiles  NewControllerNewModelNewDefaultModelNewView NewStorageModelPropertyNamesModelToCollectiongĤIx8< ModelToStringCollectionToModel StringToModelCollectionToNewModelStringToNewModelRangeToAddressFFAddressToRangeSaveConversionResultToFileSaveAllStoredItemsPrintf SplitKeyValue Test_PrintfTest_SplitKeyValue GlobalAlloc kernel32 GlobalAlloc 1Y GlobalFree GlobalFree 1 GlobalLock GlobalLock 1 GlobalSize GlobalSizevertIControllerIControllerIControllerEventsIControllerEventsIModelIModelIModelEventsIModelEventsIStorageIStorageIStorageEventsIStorageEventsIViewIViewMementoMementoStringBuilderStringBuilderTestTestThisWorkbookThisWorkbookToolsToolsWin32ClipboardWin32ClipboardWorkingWorkingWWDBTahoma8KEFҋB `EF`b( 4txtFilenameea$H,I{5Tahomag ( RBrowse .... uTahomag(AAboutag uTahomag(CloseagEuTahomag4#@HD3+*Generating table...5 Courier Newt(]XThis is the selected range converted to LaTeX. CID="{F8AAC96C-0796-40AC-BC20-2789D5697FDB}" Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} Class=CController Class=CModel Module=Conversion Class=CSheetStorage Class=CVolatileStorage Module=Factory BaseClass=frmAbout BaseClass=frmConvert Class=IController Class=IControllerEvents Class=IModel Class=IModelEvents Class=IStorage Class=IStorageEvents Class=IView Module=Memento Class=StringBuilder Module=Test Document=ThisWorkbook/&H00000000 Module=Tools Module=Win32Clipboard Document=Worki_DELETED_NAME_48"W_DELETED_NAME_49"2w_DELETED_NAME_50"zp_DELETED_NAME_51" n``W~10]2<=^e_`adgtqhrs{v|}_DELETED_NAME_52"_DELETED_NAME_53"6P_DELETED_NAME_54"p_DELETED_NAME_55"awx v !"#$opqrstuwfRoot Entry Fpv@+Workbook<1XCB>y_VBA_PROJECT_CUR"pvlick the button to use the current selection.N5Tahomag((CCopy to Clipboard. uTahomag$( SSave to File: uTahomag Nu n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q$(WMin cell width5TahomasH,"{uTahomas$(BBooktabs package5Tahomas(F@V2xt5Tahoma(F@B2xt5Tahoma ( DExtra indent5TahomaH,"{uTahoma(F@T2xt5Tahoma,(TCreate table environment 5Tahoma$(VConvert $ ^ _ \e 5Tahoma((UAuto-apply optionson: 5Tahoma(F@U1xt5Tahoma8H 1}OptionsR KQDBTahoma0 2DRLabel2oMinimum number of characters to reserve for each table cell, to aid with alignment 4RtxtCellSize Minimum number of characters to reserve for each table cell, to aid with alignmentl $2D >Label5"When checked, booktabs commands will be used instead of \hlinep H=chkConvertDollarWhen checked, special characters will be escaped in the tablee 2RspnCellWidthMinimum number of characters to reserve for each table cell, to aid with alignmentl H>chkBooktabsh"When checked, booktabs commands will be used instead of \hlineT 2@(Label3 Number of spaces to prepend to each lineT 4(txtIndentbsh Number of spaces to prepend to each lineX 2(spnIndentbsho Number of spaces to prepend to each line| HLchkTableFloatlar When checked, the tabular environment will be wrapped in a table environmentx #2L LLabel4 When checked, the tabular environment will be wrapped in a table environmentl %2D =Label6When checked, special characters will be escaped in the tableed 02H 7Label8When checked, changing an option will refresh the tabled 1H 7AutoApplyBoxWhen checked, changing an option will refresh the table Tahoma ,AApplyaEw @ng/&H00000000 Name="Excel2LaTeX" HelpContextID="0" VersionCompatible32="393222000" CMG="0E0C05781B888E8C8E8C8E8C8E8C" DPB="7D7F76E58A558B558B55" GC="ECEEE79639043A043AFB" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] CController=0, 0, 0, 0, C CModel=0, 0, 0, 0, C Conversion=0, 0, 0, 0, C CSheetStorage=0, 0, 0, 0, C CVolatileStorage=0, 0, 0, 0, C Factory=0, 0, 0, 0, C frmAbout=88, 88, 1071, 555, Z, 22, 22, 1600, 713, frmConvert=0, 0, 0, 0, C, 44, 44, 1622, 735, C IController=0, 0, 0, 0, C IControllerEvents=0, 0, 0, 0, C IModel=0, 0, 0, 0, C IModelEvents=0, 0, 0, 0, C IStorage=0, 0, 0, 0, C IStorageEvents=0, 0, 0, 0, C IView=0, 0, 0, 0, C Memento=0, 0, 0, 0, C StringBuilder=0, 0, 0, 0, C Test=0, 0, 0, 0, C ThisWorkbook=0, 0, 0, 0, C Tools=0, 0, 0, 0, C Win32Clipboard=0, 0, 0, 0, C Working=0, 0, 0, 0, C "EFSummaryInformation(=DocumentSummaryInformation8CompObjkOh+'0HPd|  Excel2LaTeXChelsea HughesChelMicrosoft Excel@ )@O՜.+,0 PXd lt|  Working  Worksheets FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q0 H Excel2LaTeX8@ = t  `]Y "< rstdole>stdole h^*\G{00020430- C 46}#2.0#0#C:\Windows\SysWOW64\e2.tlb#OLE AutomationQAEOfficEODficEE2DF8D04C-5BFA-101B-BDE5EAAC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE15\MSO.DLL#P 15.0 Object L@ibrarycMSForms>SFrm3D452EE1-E08F1A-8-02608C@4D0BB4TFM20L'B &/;1rr}#0#5(0EB79C153-4108F6-AF3E-52F5E@B1DB99IUsers\Chel\AppData\Local\Temp\VBEbB.exd;,.E .`M VBIDE> BIDEȻ@7ۻ5.3QVBA676EXT.OLBHVisual Basic for" #lic"fs Extensibility #"CControllerG on`}rb}}r2 H1&" +B{CModelGB{CGoe 2 :vI$Gਡ vs,26! SheetSto`rageG@  SU`e t tbfagO2\<E,"a VolFle " V9a i:Mq2||r!Fac yG"jFc y2 l4frm@AboutGbfQBAb u j2r|R NM# iNs)=I\@PO=X@S@\@\\UEventsnGBEQsp 2 ל IIJIJJ|||+<1/IB1/I\=s15s1<<<<<\\\r\\| | p 1IViewG9INiw2Ӕem o3OM@m o4O3O GoTo< 0r \qnBy Val p"As IWDim @lIndexLXong =.Add(BDefaultModel()"ebug.A      !"#$%&'()*+,-./12345789:;<=>?@ABCDEFGHIKLMNOPQRTUVXYZ[\]^_`abcdefhiklmnopqrstuvwxz{|}~ssert1pB B!BCSetE=9ICC.CellWindc%+G42424C2<>3RemoveP GetItems.CountG \ A(1)JLnO6G , 2\Qd0/3tB\G59X$.3r  L"_AppendTob`% HgsLine@,^SńaO Fxrom*m ,K, TrueH;@1 Fals c -< < ,>< < *4  ;4,,,,,U0,,,,,|06<<3-5P.l|q)Builder .sbg+tG Len(sb.To|7pC("Th`is ")aMtP of "the tZ 'ncreme nt@hexpa nsѣability.I2! a  `  7 vbNullD"l l l l l l l l <!Now I'`m addv ery lPN s to3that correctly hanPdles4sarP & _"mon d0oubl`enfg0pcu `b@uffer.d@speed,!cX iplysi'\Q@t, ns etur0ipiscAe.6@ndi@ hrerlus ligula, sodarhoncp0nunc porttim vitae. Integbmmodo)st@l supp1Donec ~ricPtЁ!@ac tidqq0 diaumL.$$$$$$.,####################### #######b?bb%`z% bi) SӱtringBuilder up-front. Will it choke? " @& _ "Lorem ipsum dolor s`amet, consectetur ad ipisc eliSuspendisse hQrer8l/us ligula,qsodales rhonc+nunc porttit~vitae. Integcommodo vestibulsupDonec ulc(tell(:ac tincPiduno[mentum. Etiam volputpa`\, a?neque0mTQVIa:curV nislhrdet muada fis Oaprimis in uc0s.").ToS() r=4Th (sPt ofldka@ big sB to  End.b OAttribute VB_Name = "IVi ew" Basp0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |Global!SpacFalse JCreatablPre declaId#ExposeTemplate Deriv%Cu@stomiz EO@ption 0licit Pub Property Get Controller() As I ' End S ByVal p ())KStorageI$HD# !Sub ShowMod@aForm3s`tantsG մAttribute VB_Name = "Tools" Option Explicit Pub, FunclPrintf(ByVal sFormat As Sng, ParamArray Bues(D))> Dim lUBoHund Lo s`ResulYv@ElemenV`arianVTex Na(sFirstChDarSPosQCxurrCIf IsMiss (ThenC= -1 Else*) If @' Handle all tokens:CBDSzt(r, "%"G 9ry of is tuntBihe f oHccuDce %Start froMeco@)D"m= LC5) + 1 To:GDneft $(), 1 Select pCase"1""9C0-ipeter:okup @X inserġl= CL@) - yK@<= D >=CKgDefa@o: E.g., keep %3 if on@ly twog s aressed%" &/W : & Mid>2;%:Debug.A9SFa!BSp(eci`Bc: %% (`Y% e@`sB)$]*@sHgno@)n`u!#)LO?ih/A@ilo-=o}x$<7!=rcNCombine< r'C` Join> %ԁHSubKeue)ByRe 5@"Î"AnBA.In(1,' =KA|{0,z](fiQk7h @ɧB4!#LeBubg@vaЅ!Test_)7"%1"abc"#Thg a %2%1.tq(no3o5mple)  )Plst.Let's`ke how it hus out-of-rangPQR%y,revenTB`CC O|zl+%%%?ht_+614x40A =cd0Ph0 / 2cd=ef,+c1@9Attribute VB_Name = "IMo@del" Bast0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse %Cre atablPr@edeclaId#ExposeTemplat@eDeriv%Customiz EOption 0licit  Pub En@um x2ls Nonq&H0  teT/Environment1PBooks 2onvertMathChar4 EndDKPropy G et Ev1s(`) As  'E D7CI; MLHByValEK)"Ind.2nteger۵Attribute VB_Name = "CMo@del" Bast0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse %Cre atablPr@edeclaId#ExposeTemplat@eDeriv%Customiz EOption 0licit  I&ements I Dim sb As S)ngBuilder CellWidthInt eger 'Characters p  in output fil@ convertDol"Booleanbooks AFloat Ind@0#0FF2RangeToU@B=P@T@V mpEvBD8NewF Sub Class_Initiali@ze() ACS4etP=LQEnd' ia&ahBub@i Pro@Sty G@ _"()B< ' @!4x2lCIf rpThenL O rCMathG( AbE'j!weTaEnviron1%%L%ByVal *'dCAPoldR?#LK0= ( 0-) <>Non@^!F.%+H,p2)6?`O8c%Y.RaisewdA5If\\K\#$ie0AA$ A~i.8F VExit b !| i  g=翜!!G !G" H#  EdedVf=gLkhCsQDibsv= WorksheetSUC()` LikeT) & "\*" 7 = Mid$W,` n+ 2 8 Apbsol`|yfH "?: ]"\\*, ?r bllantf("%1\%2",:,GL)LJ2Addresy)L]TUG`*+2*cI= TToR(cl:l: FuncD ns@Resul$]I3r3r, rc8iRSj\Sм|oLJ-IШoth@+Text "% @Error:p BrBsele d".@(Tru+GoTo v-(;=(f=b} gener@~d byYcel2LaTeX fro@J. '" .60.B'J |l b \begin{}[htbp]sJcng <;a{ }xu}{0b1lumnsFormat+?# 'Start checka'topr)+!gXRows(1:EHorizow΀1(P op:='&@:tA:S 6= 1P RangeToUse.Rows.Count ' for each row Set r =Q (j) FcHr@.Cells2AddText Space(Indxent88+ 2"Dim pColor&#;Get (r c ]f&<> &HF ThenLPrintf("\zc[rgb]{%1} ", ToRGB(%)0F,iAp1 Toc in rc.Item(i,,iT1(c,5+ c.MergeArea;lumn>D,) - 1/NA>i 'A's'GG' Struts and eof linexQ%1\.\MdC(K, Tru M}-E}  CheckRBo0rderPHorizontal (r.OffsetmC:=1!,ttom:<=jCNbIj 'G theB":(TabPenO8Rk"\{tabular}>%HECleFloatLl':addOL| ! leL E DIfleave:Model_`CConversionResulsb.To`Fing(/`P@ tlegist@ry aftAsuccessful c c!v aFunct" Publi c SubInitDefa "0pWidtJh@5*Op sIx2@Pok"s OrCtMathCharvteGleEnvironm A FromdgV$sFileNam #"1!riv`@xop y%Descri() As 4VIs NxothmWN `"P(emp` r)"ExiC/JC : %2QMe.Xr E%!`= ! #!-?A2  (ByVal pC % R?.s(1!mpEvIs.`RaiseN@d#/Vlas`mple'a2D E3Jvg Lo%!hEOrDisplayrma"Y).InTB A Pxur#FlI  {V+!si",,= A-l(Go} 3d.tex00 9T[t𒹖 , ӁpL0FeedFaDApp1V!7vbL4<9Pad3SsZb `2.Max(0, nόĿr cKDebug.AssPiYP.qNo O!PbmJ6V4&,W(bHasTop tLES= L@ɑoZ̓ !~der Then GetStruts = @"\bigs4"!Else![t] jnd If If bHasBottomBorr)[bc F@unctioQ Private,ColumnsFormat(ByVal RangeToUse As, OpbSkip FirstJFajlStep Long1)dingTDim rc2ni* stg.QSet1=j.z=@ .It`em(1)hNot; h= Verticalp(cneC@Z/@C ToCount-JLG&@ ncH+$hF:O n ErrResume Next rc(i +(JGo%0VHorizontalAlignHmenH'ghF a us( the laM@row oft8ablHkOrDisplay!KellsRowsO,@).)qVarTypeV.@Vue2) dvbH A7WrapT,v MMergePGH+ "p{" & LTrim$($(0.5 * SumVWi dths( ))) "em}聳 R [ Select Ca@4xlLef l $C@ er|csGeneralIIf6(HH,!r"(nf4ar" 'Defaultkis righ%2.h Is}E)SU  ~ic ̃ щ@B6P ize(%S:=0POf0fsetT:=-$  L''k:=rBelow'Boole.a/(<r(, 0) <>4   ,spacesEaI sger̻l P3ebug.As>s0Q 8 rAbove[ *l|*־(8d)<)Wrw l!%OpenFrb!!. K T9Io*pzЈ-5F-=B+6Q< xlNone0End If  ApFdToRangeSet s Def, fFrom,q. -  + 15Next;9.sunt2Dim H!Cmd$, CMore Ifoktabs Then Top -"\toprul e"}BotttombB P m revert to old behaviori@Printf("1-%1 )_'return noth ing, D orDC %v Select Case "xlDoub9 fB"Space(ss)`f=+ vbLf<C inuousN 0ZO ",Z%Zl@"";X bJZ+ "{%1}`KReplB";Z}" ")D>kFunctio P:ic Sub0(ByRAsAdTCLoValBooleaclCurrentPos? <= 0= w%1%3%2),k>!"0e-m>-x1, 0  ! r!rivate"FFFtGG?T ,#1M1OrDisp.yForHmat)M).C2s(xlp).qxKYIs NUb Exit80s<38 (W x  9`142  #&Rb7U Or|XLb 4?eAddCell&L&FFirstFXbLaR"or&)uHtxt'Ogn| lS! R #jybRequiresDiffe=VQh Q,Check fmul8tic5.MergeB$,,g  cHWithAreaLf= l20q rN\eY> 1Xӡp( c0 s onlyf' row of a- Is*pOfM !#E`\2 р[%3]{*}{%2 ,`, Get,uts4blُ,c(f`)!!?!K(#{%3_l 8"/&,QbD |L LI 'sDQ!-T,$ddT 19! ObLastCell Then " If Width > 0 xAddText PadSpace(nColumns * (3 +) - 3Len(txt))EndkT" &" !<;lsevbLf & IndentH5$= n Fu nctio> Private @ Forma(ByVal r!As RangeD, Row)or&) String: <.\o L)#ConvertSpecialChars, isnumeric(Cq(ue2 kF8ontJ Ori^aLIdP},Wl[$F,BmDim@nt, IntTF19!+_  ))l \JAJ FF%1,h %2`3$(Round((#A&HFF / 255, 3)' w00`&H1000~0 nd$o%sBF%eoNumbes Boole|an)N * I'Check f@sC c`ac?s`always c if QDDollar8 OrehRe uϰ, "\`>gbackslash{}" z$ $l_}b_lla^b^e> %%L,$z&"&,,,,#"#,,$$<4Anewlinecl4l4kx443#lpQqcSetdffC{j?i6 88ylePT6B.Bold<^fbf]kusItalic  it   `Typesh` in b CrequiredNoT u,EDIn(a=y \ {}%1\un((())))' 3rs "rong" kagdLC&-(C;-- 7,o,3lect Case!BQxlH%Pzal' Do nothdUpwar%l* gegin{0sidemen>d(^Do 1,w.MergeArearunths08/If I@sEmpty(.Value2) 0Then' if the cA is e, ignore alment chs and` onlyvline f_ -awadder removed RequiresDifferV H(Len( f) <> CR)?Els?{@I= 14#'\\\Lt  lrL(007rear`lier,qn>o!1<%+jug`Rs ba %Br҉itpass̥?\UZe@roIfNu@qv,g NIs 0,umeric CLng` DDlt ?!DC!g CellWidth1!!"FileAC"Sng$"FqAbsolg|RangeAddresߤLib Func"|`lsResulDMGhSub8itDefa Describ`&#B%S%p%$Attribute VB_Name = "Factory" Option Explicit Pub, FunclNewController() As I Set' N C PEndUhModelc ^Y TDefault- 1.InitC@View_l -)Sa|geh * LS0heet óAttribute VB_Name = "Memento" Option Explicit Pub, FunclModelPropertys() As Sng()  Const NAMES8RangeAdd ress|ns|CellWidt h|Ind|File[MsJSt(b, "|"yEndToColle(ByVal p{ TIhBSet CNewDim s'Varian For EachI;.@ CallB(`,', VbGet)#Nex>sXGC99& Ptf("%1=%2;";]B@SubqTo@, H/|FHFO@rr Resu 2E?*?Let, *("Q GoTo 0M%"$$2|$d$jsgtsF#aF}F ~;~kml1ALoRKeyU@u2)C2= 0 @!UBound(h&@ l1nbG|9z9 D9 77 })] 9 6HZG;c# jTEtPLqMPJ\0U-To,_IfEIs NoDthaThei>t(+ E'%`1'!%2` .Worksheet.Bd\t NTo} V@"lKy= Ap>arr3 ,MSaveЋvers:ltTo|Np/HEu=.Absola Hughhes,_C"Kirill M 25C'llerB,vbLfAndrew Ha@wrylukGHerm25nP Ria4-o, a\Joachim MarderDFTextB0ox1.FThe development reA@itorytbug tracker foris kage @ hostɀat8Cr83"https://github.com/krlpmlr/zJTAA&work dis$Zd un@ HProjec t Pub`U License, vers!F1.3 er)vailBa\Q www".A x-p.org/lppl.README.md)Bfceive err-repoA*<GitHub page51s2github.@/krlmlr/H OVp#p@Ki6 S() +Descri @OpX#=falogÍ;=DoC@mcDataInvoke_Funcl\n14@ BW NewutroJSet .ViL=A!M`lDef0ault"Stn#lvwM_Chq'e6bSelectP"Gs= (.aRx >= 0cmdTx'6Dt X,)Owri\VDbl3SGCanccMSVs.Return$'L DL0,,s_KeyDownC, Inte ger, sShifBtnp 46 ' !Hu F| w E# Targ39VeGoTo errfain$G0pVisi!xExipgHrs (c,Td0)<]8]CSTV :|s_rcd4p8k:.8h#InitFroca!zl0\R.ؽ,& %0ܽ4|# l& sp?LH ldTablesList End Sub Privatep SetResult(ByVal s4 As String)  #If Ma@c Then"txr.Locked = Falsfe^If 0Txext.k #"fT ru eConvertSelec`tion(f2mbIgnoretrolEvents; Exit& mMod@el.Get+s( aUFocus LublicKInit&p ISWith .CellHWid = (Me.< SizeOp=s -EAInd@> FilepNameCn9*;FroO 0# N!02^Upd@LD,AT wBrowse_C@k bs ~@ Appa~ SaveA a($Absolute, "TeX da*.tex), "G "( rCancelHid\Ropy[!|VBA7Win32| Not_+pBoard(t)x~VP!aObjq.New DQg$_b6, Pu_b @_ ̂tTo)TWUW._lx!Cou o- 1 Op writLlLon>g4 L Removeu+LE,Dt\ 7X r\eDxler.n=nn.Q( \FD`|L#ExportAlZ=C)@Sr F mmandButton2frmAbou@howspn6_a, e O0Hrr ;`U?_ @([Auto1ayBoxY`\ X ]\ hadLViewB 'StorageDD  !Sub Run( @ Attribute VB_Name = "IModelEvents" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacFalse %CreatablPredeclaId#@ExposeTemplateDerivCus tomiz EOp tion 0licit Pub  Changed() Sub Rais:e  End Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C#46} |GlobalSpacFalse %CreatablPredeclaId#Tru "ExposeTemplate`DerivBustomizD#Option /licit P"& Sub _Open(0) geMenuItems End (ByVal CBa8As SNnHg,  Ac F ID LongADim my-bar CommandBar, `tools Popup, new$ContrDolSet= ApHa(. s("AHshe B"("=Bs(6 % Find (Tag:=J, Recurs|:=rAIf NoKI shT Then.DeletS!/,.Add(Typmso!DButtA$Befor@3, orary 'I2U3OOnăPtipTextO%RHZ_a#`.Mac'+#' jce@l 2016!, we can'A`Kanipuv m h ^( NVe= 158ExiNtcB!Ifs "4&vert TBto LaTpeX",B  .e8bAllt$ૃH@mress"`DTo@+mula9c,N.Cells(1,e)i bG5yȆqer- 6.RaiseC:hd%Sub' Removed$}Oss1$ #Dele|Up;ItemuN@mp Works ;roj@*KImothingS2ExitMH%\O\ORORJ$JgLMkOSng, s0&&P"= 2 0G~74(Ot(7bApчa A .&.CountA(q;KCor[Rl$FF\Up\[DDLR( NNN0N+(s) > 2 *2) Th7 I7&E9 s)DAEo- >,IfF/0Mid,!1,(sDW+CSiX M@^QcTo^CucC % Left$ E'      "#$%&'()*,-./123456789:;=>?@BCDFHIJKMNOPQRSTUVWYZ[\]^_`abcdefghjklmnopqrstuvwxyz|}~Attribute VB_Name = "IStorageEve@nts" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse %Cre atablPr@edeclaId#ExposeTemplat@eDerivCustomiz EOption 0licit P Pub  Changed() Sub Raise  End մAttribute VB_Name = "Win32Clipboard" Option Explicit ' this code adapted from Stack Overflow: "Excel 2013 64-bitA:  API doesn't workp' http://sMoL.com/q/18668928/(214 8changto use CF_UNICODETEXT, and RtlMKMemory instead of ls trcpy$#IbfO7 A Then PrivaDeclare PtrSafe FuncGlobalAlloc Lib "kernel32" (ByVal wFlags As Long, dwBylte +)&\Puc .cabor.@'Debug.@;nt B"{retuGd0 & C` ( GoTo OutOfHerecE0gIfajWG`0c dTto*m(0&)&,)o rd ( !`A&l% ckaO,{5f:Kysc1e\S= Trua#UwAttribute VB_Name = "CVolatileStorage"  Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacAIFalse %CreatablPredecla Id#ExposeTemp@eDerivCustomiz EOption 0licit  I&ements I P.2 mCollecAs New  pEv"& Property Get_()  S@6 EndFIFun/Add(ByVal pModelsBB, Hl Index-1&Long#I!E.Count + 1D f (< 0) Or ( =The@U  A(ToSQyng(.) Ew+0, Before:=D.AAfter:="fIfl.RaiseChangedCoEjIoSubZRemovend2 i;d FUItem$T`SE1-faDim sOVarian@rAFor EachIn '222lTo@($$N ex -Attribute VB_Name = "IControllerEvents" " Bas0{FCFB3D2A-A0FA-1068-A738-08002B33 71B5} |GlobalSpacIFalse %CreatablPredeclaId#ExposeTemplateDerivCustomiz EOption 0licit Pub  ModelChanged()Sub Raise   End ID="{F8AAC96C-0796-40AC-BC20-2789D5697FDB}" Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} Class=CController Class=CModel Module=Conversion Class=CSheetStorage Class=CVolatileStorage Module=Factory BaseClass=frmAbout BaseClass=frmConvert Class=IController Class=IControllerEvents Class=IModel Class=IModelEvents Class=IStorage Class=IStorageEvents Class=IView Module=Memento Class=StringBuilder Module=Test Document=ThisWorkbook/&H00000000 Module=Tools Module=Win32Clipboard Document=Working/&H00000000 Name="Excel2LaTeX" HelpContextID="0" VersionCompatible32="393222000" CMG="080A031107110711071107" DPB="10121B1C1C1C1C1C" GC="181A1324142414DB" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 (H  @ }3!R KQDBTahomao(2DLabel2(2DLabel1O(?4cmdClose+$8TextBox1q $(EDIT CAPTION IN CODE$NuTahomag$(EDIT CAPTION IN CODE#OuTahomag(OKhouTahomag!HU1S5Tahomag Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmAbout Caption = "About Excel2LaTeX" ClientHeight = 4890 ClientLeft = 45 ClientTop = 330 ClientWidth = 7410 StartUpPosition = 1 'CenterOwner TypeInfoVer = 13 End CControllerCControllerCModelCModelConversionConversionCSheetStorageCSheetStorageCVolatileStorageCVolatileStorageFactoryFactoryfrmAboutfrmAboutfrmConvertfrmConvertIControllerIControllerIControllerEventsIControllerEventsIModelIModelIModelEventsIModelEventsIStorageIStorageIStorageEventsIStorageEventsIViewIViewMementoMementoStringBuilderStringBuilderTestTestThisWorkbookThisWorkbookToolsToolsWin32ClipboardWin32ClipboardWorkingWorking(H  1@m}3SC3R KQDBTahoma8KEFҋB `EF`b( 4txtFilenameea$/( @cmdBrowsemee~@/,<CommandButton2/, ;8cmdCancelttojJ/( XtxtResulttto( 2Label1$ HcmdCopy /$ DcmdSave/( # OptionsFrame5( ,cmdSelectionI\ &;D )ApplyButtonnjJuApply these options and refresh the table, -;@ cmdExportAlljJ1, +;8 cmdDeleteAlljJ, ,;@ cmdOverwritejJ (*;8cmdLoadjJD();<cmdStorejJ(/2@Label7re6,.4lvwStoredTables5 H,I{5Tahomag ( RBrowse .... uTahomag(AAboutag uTahomag(CloseagEuTahomag4#@HD3+*Generating table...5 Courier Newt(]XThis is the selected range converted to LaTeX. Click the button to use the current selection.N5Tahomag((CCopy to Clipboard. uTahomag$( SSave to File: uTahomag NuTahoma ,AApplyaEw @Tahoma ( pExport AlllEuTahoma(DeleteEuTahoma ( vOverwritellEuTahoma(LLoadEuTahoma(eStoreaEuTahoma ( Stored tables 5Tahoma`?5Tahoma8H 1}OptionsR KQDBTahoma0 2DRLabel2oMinimum number of characters to reserve for each table cell, to aid with alignment 4RtxtCellSize Minimum number of characters to reserve for each table cell, to aid with alignmentl $2D >Label5"When checked, booktabs commands will be used instead of \hlinep H=chkConvertDollarWhen checked, special characters will be escaped in the tablee 2RspnCellWidthMinimum number of characters to reserve for each table cell, to aid with alignmentl H>chkBooktabsh"When checked, booktabs commands will be used instead of \hlineT 2@(Label3 Number of spaces to prepend to each lineT 4(txtIndentbsh Number of spaces to prepend to each lineX 2(spnIndentbsho Number of spaces to prepend to each line| HLchkTableFloatlar When checked, the tabular environment will be wrapped in a table environmentx #2L LLabel4 When checked, the tabular environment will be wrapped in a table environmentl %2D =Label6When checked, special characters will be escaped in the tableed 02H 7Label8When checked, changing an option will refresh the tabled 1H 7AutoApplyBoxWhen checked, changing an option will refresh the table $(WMin cell width5TahomasH,"{uTahomas$(BBooktabs package5Tahomas(F@V2xt5Tahoma(F@B2xt5Tahoma ( DExtra indent5TahomaH,"{uTahoma(F@T2xt5Tahoma,(TCreate table environment 5Tahoma$(VConvert $ ^ _ \e 5Tahoma((UAuto-apply optionson: 5Tahoma(F@U1xt5Tahoma n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmConvert Caption = "Excel2LaTeX" ClientHeight = 7440 ClientLeft = 45 ClientTop = 330 ClientWidth = 12075 StartUpPosition = 1 'CenterOwner TypeInfoVer = 109 End VBA 2