Thread: Simple question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yakerdude7 yakerdude7 is offline
external usenet poster
 
Posts: 1
Default 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