Simple question
 

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

Simple question
 

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.