vba open a text file into excel

Hi,
    I have a text data file with fields separated by fixed widths. How do I use Workbooks.opentext to open it as Excel having all fields copied over ? Let's say the widths are 5 8 8 5. Thanks for helping.
azcalv408Asked:
Who is Participating?
 
Raynard7Connect With a Mentor Commented:
Unfortunatley it is not very easy; I would reccomend that you read it in a line at a time and dump the contents into the workbook yourself

however

http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1117.mspx

Contains all the details on what is expected to do it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.