Excel: Import file into a new sheet (instead of new workbook)

[Hermanator]

Hello all,

I'm trying to make a VBA macro which imports several text files, and places them into seperate worksheets of the active workbook.
This can be done manually very easily by File Open and running the options of the Text Import Wizard. Consequently, the sheet can be moved to the original workbook. This is the process that I would like to automate.
It's no problem to make a function that imports several text files with the options that I want. But every file is imported in another workbook, while I want each file to be imported into a separate sheet of the active workbook.

I just know that there must be some way to do this. However, I have no clue how...

 

[SkipVought]

Hi,

Use Data/Get External Data/Import Text File....

on a new sheet

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]