Simple question

[yakerdude7]

Im new to using excel macros and need some help. I need to be able to have an open file dialog to take a txt file and put it into an excel spreadsheet. I have looked through a VB book I have, but could not find it and am running out of time. I need it to have the dialog box, creating a new worksheet with the same name as the txt filename, and then copy the "delimited" data to the sheet so that spaces put data into different cells. If anyone can help me or point me in the right direction, I would really appreciate it! Thanks.

[ChristianH]

yakerdude7 wrote:

> Im new to using excel macros and need some help. I need to be able to
> have an open file dialog to take a txt file and put it into an excel
> spreadsheet. I have looked through a VB book I have, but could not find
> it and am running out of time. I need it to have the dialog box,
> creating a new worksheet with the same name as the txt filename, and
> then copy the "delimited" data to the sheet so that spaces put data
> into different cells. If anyone can help me or point me in the right
> direction, I would really appreciate it! Thanks.
>
>
> --
> yakerdude7
> ------------------------------------------------------------------------
> yakerdude7's Profile: http://www.excelforum.com/member.php...o&userid=35273
> View this thread: http://www.excelforum.com/showthread...hreadid=550497


Hi

Why dont you use the Import External Data function in the Data menu?.
With that you can import txt files and choose the delimiters and then
you name the
sheet with the same name.