<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>A few years back, we had an application that required
attributes. We used the SYLK format. It imported directly into Excel (97 at
the time) and the ensuing macro did all the rest of the work including the
creation of a pie chart. <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:10.0pt;color:#1F497D'>Ted B<br>
aka tedb@ci.borger.tx.us<br>
806-273-0956 Office<br>
806-273-0983 FAX<br>
806-231-8167 Cell </span><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 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
filepro-list-bounces+tedb=ci.borger.tx.us@lists.celestial.com
[mailto:filepro-list-bounces+tedb=ci.borger.tx.us@lists.celestial.com] <b>On
Behalf Of </b>Richard Hane<br>
<b>Sent:</b> Thursday, July 16, 2009 11:12 AM<br>
<b>To:</b> filepro-list@lists.celestial.com<br>
<b>Subject:</b> exporting attributes<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>I was playing around this morning with some of the Excel
spreadsheets we create from filePro. These are done as dif files.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>The data is fine the column headings and extra blank lines
come over correctly as well.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>My question....<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Has anyone found a way to set the cell attributes during the
export process? Things like the column width or height, data position
center or right, bold or underline, etc.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>If this could be done I know it would save me a lot of time
each week instead of having to do this manually and resave as an xls file.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thank you in advance<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Rick Hane<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Controller<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Deluxe Stitcher Company Inc<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><a href="http://www.deluxestitcher.com">www.deluxestitcher.com</a><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Checked by
AVG - www.avg.com<br>
Version: 8.5.375 / Virus Database: 270.13.14/2238 - Release Date: 07/16/09
05:58:00</span><o:p></o:p></p>
</div>
</body>
</html>