| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fixed Width - Opening Certain Fixed Width Files
I receive weekly data files from the USPS in a fixed
width format. Each file will have the exact same 23 fields defined when opened (position 1, 9, 16, 32, etc.). Is there a way to create a macro that will automatically parse the file at the correct 23 columns so this doesn't have to be done manually each time I receive a new data file? Thanks, Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed Column Width Export | Excel Discussion (Misc queries) | |||
| Column fixed width | Excel Discussion (Misc queries) | |||
| Fixed width fonts | Excel Discussion (Misc queries) | |||
| Software to download Fixed Width Files | Excel Discussion (Misc queries) | |||
| How do I create a "fixed-width" datafile? | Excel Discussion (Misc queries) | |||
![Jan[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
