Fixed-Length .dat file Automatically Parsing

[technochik]

I have a fixed length .dat external file with no column headings. I know I can import the file into Excel manually via the Text Import Wizard (where I manually specify the field widths of each column...using a printed file layout as reference). I want to automate this though. Is there a way to import the file automatically parsing into standard file layout?

Basically I don't want to have to reformat these files for an end-user every week (the Text Import Wizard is too advanced for them). I am hoping to setup a template, macro or hidden VB script that will reformat this file into the pre-defined columns and add headings. Can this be done?

 

[technochik]

I created a "delete button" macro which works fine. But when I create the "create button" macro, it doesn't capture the text title or assign the macro that I do during the macro recording. Here's the code that's generated:
Application.CommandBars("Standard").Controls.Add Type:=msoControlButton, ID _
:=2950, Before:=22

Can I add code to change the button from a smiley face to a text title? Can I add code to assign the FormatCRC macro to the button?

 

[technochik]

Or, did I record the macro wrong?

 

[technochik]

I just created a "form" button and assigned the macro there. That should do that trick. Thanks again for your help! I'm eternally grateful.