<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Palatino Linotype";
panose-1:2 4 5 2 5 5 5 3 3 4;}
@font-face
{font-family:Palatino;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
{mso-style-priority:99;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:18.0pt;
margin-bottom:.0001pt;
text-indent:-18.0pt;
page-break-after:avoid;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
p.BlankLine, li.BlankLine, div.BlankLine
{mso-style-name:"BlankLine\,Bl";
mso-style-priority:99;
margin-top:0cm;
margin-right:0cm;
margin-bottom:13.0pt;
margin-left:0cm;
line-height:13.0pt;
mso-line-height-rule:exactly;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;
color:#035922;}
p.Body, li.Body, div.Body
{mso-style-name:Body;
mso-style-priority:99;
margin-top:0cm;
margin-right:0cm;
margin-bottom:13.0pt;
margin-left:0cm;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
p.BodyKeep, li.BodyKeep, div.BodyKeep
{mso-style-name:BodyKeep;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
p.ListBulletLast, li.ListBulletLast, div.ListBulletLast
{mso-style-name:"List Bullet Last";
mso-style-priority:99;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:18.0pt;
margin-left:0cm;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
p.List1, li.List1, div.List1
{mso-style-name:List1;
mso-style-priority:99;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:10.0pt;
font-family:Palatino;}
p.List1Bullet, li.List1Bullet, div.List1Bullet
{mso-style-name:List1Bullet;
mso-style-priority:99;
margin-top:0cm;
margin-right:0cm;
margin-bottom:5.0pt;
margin-left:0cm;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
p.List1BulletLast, li.List1BulletLast, div.List1BulletLast
{mso-style-name:List1BulletLast;
mso-style-priority:99;
margin-top:0cm;
margin-right:0cm;
margin-bottom:18.0pt;
margin-left:0cm;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
p.List1Continue, li.List1Continue, div.List1Continue
{mso-style-name:List1Continue;
mso-style-priority:99;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:18.0pt;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Palatino;}
p.List1Last, li.List1Last, div.List1Last
{mso-style-name:List1Last;
mso-style-priority:99;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:18.0pt;
margin-left:18.0pt;
text-indent:-18.0pt;
punctuation-wrap:simple;
text-autospace:none;
font-size:10.0pt;
font-family:Palatino;}
span.bodyChar
{mso-style-name:"body Char";
mso-style-priority:99;
mso-style-link:body;
font-family:"Palatino Linotype","serif";}
p.body0, li.body0, div.body0
{mso-style-name:body;
mso-style-priority:99;
mso-style-link:"body Char";
margin-top:0cm;
margin-right:0cm;
margin-bottom:13.0pt;
margin-left:0cm;
punctuation-wrap:simple;
text-autospace:none;
font-size:11.0pt;
font-family:"Palatino Linotype","serif";}
span.EmailStyle34
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle35
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;}
span.Acro
{mso-style-name:Acro;
mso-style-priority:1;
text-transform:uppercase;}
span.Acronym
{mso-style-name:Acronym;
font-family:"Palatino Linotype","serif";}
span.Numerals
{mso-style-name:Numerals;
mso-style-priority:1;}
span.acronym0
{mso-style-name:acronym;}
span.EmailStyle40
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:-119;
mso-list-type:simple;
mso-list-template-ids:477281526;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-style-link:"List Bullet";
mso-level-text:\F0B7;
mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:631325114;
mso-list-type:hybrid;
mso-list-template-ids:408295076 67698693 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Whit,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>One of my colleagues, Chris Greaves has worked with me in the past on client’s VBA projects and provided VBA training for my clients with success. I’m sure he’ll find a solution that will help. <o:p></o:p></span></p><p class=MsoNormal><br>Thanks Veronica, for this and for thinking of me.<br>I have attached 3 PDF files, which may overwhelm your client, or may serve to convince him that whatever the problem, a solution can be found.<br><br><br>Below is Chris’ contact information.<br><br><o:p></o:p></p><pre>====================================================================<o:p></o:p></pre><pre>Chris Greaves B.Sc. Dip.Comp.; 416-621-9348<o:p></o:p></pre><pre>4340 Bloor Street West; Suite 401; Toronto; Ontario; CANADA M9C 2A6<o:p></o:p></pre><pre>Web Site <a href="http://www.ChrisGreaves.com">www.ChrisGreaves.com</a><o:p></o:p></pre><pre>LinkedIn: <a href="http://www.linkedin.com/in/chrisgreaves">www.linkedin.com/in/chrisgreaves</a><o:p></o:p></pre><pre>Twitter: <a href="http://twitter.com/#!/ChrisRewards">http://twitter.com/#!/ChrisRewards</a><o:p></o:p></pre><pre>Newsletter: Subscribe at <a href="http://www.ChrisGreaves.com">www.ChrisGreaves.com</a><o:p></o:p></pre><pre>WORD Macros: <a href="http://macrosinminutes.blogspot.com">http://macrosinminutes.blogspot.com</a><o:p></o:p></pre><pre>=====================================================================<o:p></o:p></pre><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>HTH,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Sincerely,<br><br>Veronica Kütt<br>President<br>Front Runner Training, a Div. of Front Runner Publishing Solutions Inc.<br>416-515-0155<br>Call Toll free: 1-877-999-0155<br></span><a href="mailto:veronica@front-runner.com"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:blue'>veronica@front-runner.com</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-family:"Tahoma","sans-serif"'> framers-bounces@lists.frameusers.com [mailto:framers-bounces@lists.frameusers.com] <b>On Behalf Of </b>Whit Broach<br><b>Sent:</b> August-10-11 5:15 PM<br><b>To:</b> Frame Users<br><b>Subject:</b> Managing Word styles with macros / VBA<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=body0><span lang=EN-US>A quick search of list archives back to </span><span class=Acronym><span lang=EN-US style='font-size:9.5pt'>2007</span></span><span lang=EN-US> doesn’t quite address this.<o:p></o:p></span></p><p class=body0><span lang=EN-US>Where does one find, for a reasonable license fee, a set of Word macros / </span><span class=Acronym><span lang=EN-US style='font-size:9.5pt'>VBA</span></span><span lang=EN-US> code, for managing (especially cleaning and applying) Word styles, perhaps in the manner of Silicon Prairie Software’s:<o:p></o:p></span></p><p class=body0 style='margin-left:18.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo3'><![if !supportLists]><span lang=EN-US style='font-family:Wingdings'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Paragraph Tools<o:p></o:p></span></p><p class=body0 style='margin-left:18.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo3'><![if !supportLists]><span lang=EN-US style='font-family:Wingdings'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Character Tools<o:p></o:p></span></p><p class=body0 style='margin-left:18.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo3'><![if !supportLists]><span lang=EN-US style='font-family:Wingdings'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Table Tools ?<o:p></o:p></span></p><p class=body0><span lang=EN-US>We cut our teeth on Frame and love it, but we’re making peace with Word after completing an </span><span class=Acronym><span lang=EN-US style='font-size:9.5pt'>FAA</span></span><span lang=EN-US> project earlier this year. Just looking to automate work that’s tedious and content-free so we have more time to focus on the client.<o:p></o:p></span></p><p class=body0><span lang=EN-US>We’re coming up to speed on QuickBasic after working in a C dialect for years on unrelated work, so a sidestep to </span><span class=Acronym><span lang=EN-US style='font-size:9.5pt'>VBA</span></span><span lang=EN-US> won’t kill us. But we’d rather drive a production car than a jalopy if we can pay the sticker price.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Palatino Linotype","serif"'>Best regards,<br><i><span style='color:blue'>Whit</span></i><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Palatino Linotype","serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana","sans-serif"'>Whit Broach<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana","sans-serif"'>Whitney@BroachServices.com<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana","sans-serif"'>+1.303.377.9448 (office)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana","sans-serif"'>+1.303.748.9448 (cell)</span><span lang=EN-US style='font-family:"Courier New"'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Courier New"'><o:p> </o:p></span></p></div></body></html>