View Single Post
Old June 28th, 2007, 09:48 AM
stealthdevil stealthdevil is offline
Friend of Wrox
Join Date: May 2006
Location: Jonesboro, AR, USA.
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Default importing text file into excel

  I'm hoping someone can point me in the right direction on this. I've done it a few times in access, but its a little different in excel.
  There's a text file on the network that is updated daily via the mainframe. I need to automate an excel workbook to import this text file. I've been trying to use the GetObject function to bring in the text file and store it in a variable for manipulation, but it seems to be a little different than with access.
  What is the best way to go about doing this?