Macro to pull fixed length data from text file to Excel

[sesgiri]

Hello Guys,

Can any one of you please help me in writing a macro which pulls the fixed length data from .txt file to excel.Please find the sample .txt file for your ref.

thanks.

 

[Luke M]

Would one of these work?
http://www.rondebruin.nl/win/s3/win022.htm
http://www.rondebruin.nl/win/s3/win021.htm

 

[sesgiri]

Thanks Luke ..but they are not really helpful...anyways thanks for looking..

 

[Marc L]

Wild cross post on excelforum.com …
​