How to import text file into excel file using VB

[annsmjarm]

Hi,
How do I create a form with import button in excel file? The impor
button can perform the function of import the text file into
worksheet. Please give me some ideas of doing it.
I have attached a text file for your reference.

Thanks !
Ann :

Attachment filename: rdata.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=66226

 

[Dave Peterson]

How about recording a macro when you do it manually the first time.

Post back with followup questions.