Macro: directory 50-70 files -> open first file with notepad -> copy all to excel -> next file in next row

[Fientje]

Hi,
I am new to this forum and I have the following question.
I can write a makro to open notepad, open a file, and than have it copied to excel.

Sub notepad()
'
' notepad Macro
'
' Sneltoets: CTRL+n
'
ActiveSheet.Paste
Range("A11").Select
ActiveSheet.Paste
End Sub

But what I need is to have a makro that makes sure that all the files within a directory will be copied to excel.
So from the directory named: 'today', open file n, copy all to excel A1, close file n, open file n+1, copy all to row n+1 in excel, etcetera untill all files are copied.

Does this require the files in the directory 'today' to be named in a certain namecode?

Thanks very much in advance!
Fientje

 

[Fientje]

Sorry, I tried to change the text but was out of the 10 minutes limit. The makro in the above only copy pastes, so I obviously also do not know that part : how to open notepad, open a file and copy all to excel and close notepad.

 

[Fientje]

Maybe I do not need notepad at all; but use import from external sources and change there to all files in the VBA / makro...