[Macpartners] Automate opening of fixed width files?

[Karen M Johnson]

Hello,

I have just found this using filemaker:

http://filemakertoday.com/com/showthread.php/15658-Importing-a-fixed-width-document

Currently I am trying the 'create auto enter calcs on the result fields so it happens automatically when each record is created.'

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.

Thanks,
karen



On Sep 2, 2011, at 8:20 AM, Karen M Johnson wrote:

Hello,

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.

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.

This is on the web but we are on macs:

http://blogs.technet.com/b/heyscriptingguy/archive/2005/11/17/how-can-i-import-a-fixed-width-file-into-microsoft-excel.aspx

I can google and attempt things till the cows come home but I have not found a solution yet.

Thanks in advance for any help.

karen



_______________________________________________
Macpartners mailing list
Macpartners at mit.edu
http://mailman.mit.edu/mailman/listinfo/macpartners

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/macpartners/attachments/20110902/98fcad25/attachment.htm