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