Fixed Width Text to Excel with fixed break lines.

[jameel30]

Hello all,
I have a text file that open with Excel 2007 on daily basis. I usually use Fixed Width to add break lines and delete the ones I don’t need.
Is there a way I can use an Excel Macro that will:

1- Ask me and allow me to browse for the text file (Test.txt) to be loaded into Excel.
2- Automatically use Fixed Width.
3- Remove/Clear all Break Lines.
4- Place only these break lines in these locations:
9,16, 41, 49, 90, 106, 136, 166, 196, 226, 256 (Column 41 – 49 AS TEXTS) and the rest as General.
5- Sort the sheet: Column D Then A ascending.


Thanks so much in advance.
Jameel

[Cutter]

Hello jameel30.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.