Need VB-code for excel macro of importing .txt-files

[Jonasmj]

I have a macro that imports a txt file to a worksheet. I names the sheet with the same name that the file imported has.

I wish to add a few things.
1. When the macro is run, create a new sheet and put the imported data on that (rahter than overwriting the current sheet)

2. When the macro is run a msgbox should pop up and prompt for the filename of the file one wishes to import.

3. If a file alreade has been imported a warning before proceeding with that should appear.

Cheers for help! (I need the code as ready as possible as I am no programer.)

 

[zacemmel]

1. Use sheets.add
2. Use the inputbox function
3. Not sure what you mean exactly

Questions?

http://www.excelquestions.com