command to import a file into excel

[vikram]

i have made an excel file wherein i hve a command button and when
click that command button, a common dolog box opens and i select a tex
file, now i have selected a text file, i want to import it int
excel,,how would i do that

i have attached the file...


please let me know thank

Attachment filename: vikrama.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54333

 

[Dave Peterson]

Lots of people won't open attachments.

Try recording a macro when you do it once and you can modify that code (if you
have to).