<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hello,<div><br></div><div>I have just found this using filemaker:</div><div><br></div><div><a href="http://filemakertoday.com/com/showthread.php/15658-Importing-a-fixed-width-document">http://filemakertoday.com/com/showthread.php/15658-Importing-a-fixed-width-document</a></div><div><br></div><div>Currently I am trying the '<span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; ">create auto enter calcs on the result fields so it happens automatically when each record is created.'</span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; "><br></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; ">It seems to be working! Have not gone that far yet but it is working. The several fields I have done so far have the correct data.</span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; "><br></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; ">Thanks,</span></div><div><font class="Apple-style-span" color="#333333" face="Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif"><span class="Apple-style-span" style="font-size: 13px;">karen</span></font></div><div><br></div><div><br></div><div><br><div><div>On Sep 2, 2011, at 8:20 AM, Karen M Johnson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hello,<br><br>I need to find a way to automate opening of fixed width files. The file is not delimited and I am a basic excel user. Other staff will be using this solution to open these files all year long.<br><br>I did try recording a macro/template while using the excel interface to designate each field boundary and did create a template. Now I cannot figure out how to open all other files using that template. Why should that be difficult? Maybe I do not see what it is I should do.<br><br>This is on the web but we are on macs:<br><br><a href="http://blogs.technet.com/b/heyscriptingguy/archive/2005/11/17/how-can-i-import-a-fixed-width-file-into-microsoft-excel.aspx">http://blogs.technet.com/b/heyscriptingguy/archive/2005/11/17/how-can-i-import-a-fixed-width-file-into-microsoft-excel.aspx</a><br><br>I can google and attempt things till the cows come home but I have not found a solution yet.<br><br>Thanks in advance for any help.<br><br>karen<br><br><br><br>_______________________________________________<br>Macpartners mailing list<br>Macpartners@mit.edu<br>http://mailman.mit.edu/mailman/listinfo/macpartners<br></div></blockquote></div><br></div></body></html>