importing data from txt file
 

I know the basics for Excel, but as far as this is concerned, I'm a
little lost. I have a set of data coming to me via a tab deliniated
txt document, and I know how to import it in and set it up so that
every time the user opens the excel file it asks the user for the txt
file to input and removes some of the unnecessary columns. I've got
that working fine.

However, I need to be able to dynamically reformat what comes in,
respacing some of the rows, removing the txt file's header, and
fiddling around with small things like that. I have no idea how to do
this. If I do any fiddling with it on the test file I'm using, save it
and then open it again, it no longer asks me for the new txt file to
open, or allow for a forced refresh of the imported data, and importing
data again just takes me through the wizard.

Any ideas? Is something like this even possible through just Excel
without any additional programs? Thanks for any help!

~ Owen


--
onelson
------------------------------------------------------------------------
onelson's Profile: http://www.excelforum.com/member.php...o&userid=25815
View this thread: http://www.excelforum.com/showthread...hreadid=392131