technochik
New Member
- Joined
- Dec 2, 2005
- Messages
- 15
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?
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?