assume the variable fname holds the fully qualified path as returned by your
common dialog.
Workbooks.Open Filename:=fname
If you want special treatment of the text file, look at
Workbooks.OpenText Filename:=fname, . . . additional arguments - see help .
.. .
--
Regards,
Tom Ogilvy
"vikram " wrote in message
...
i have made an excel file wherein i hve a command button and when i
click that command button, a common dolog box opens and i select a text
file, now i have selected a text file, i want to import it into
excel,,how would i do that
i have attached the file...
please let me know thanks
Attachment filename: vikrama.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=543522
---
Message posted from http://www.ExcelForum.com/