1) I want to take a basic “&-delimited” text
file into Excel. At this point, I have
three colums of data. I have to manually
manuever the column widths and assign
the Text Fonts to the Column Headings.
2) This “&-delimited” text file will always
have the same column headings, the same
column widths, and the same Fonts, etc.
Question:
Can I slurp up this “&-delimted” text file (yes I can, no problem) and then hit some kind of Excel macro thing that will automatically zap my file into the formats that I do manually?
In other words, after I get this basic file into Excel, is there some easy way to automatically put it into the column widths, etc that I have somehow previously specified?
