Insert imported filename from text file

[orkula]

I have some copied code which imports a text file (nice and simple) but what I would like is for it to return the filename thats been imported either at the top or in the next column. The filename will always be different and I need to do other things with the file afterwards so need a record of it for other macros to pick up the file and move it about or delete it.
I tried using the GetFile in a cell value but then it opens up the dialog box again in order to return the value.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[jindon]

1) Add in Dim Statemant,

Please Login or Register  to view this content.

2) Add one line and change

Please Login or Register  to view this content.

3) add one line

Please Login or Register  to view this content.

[orkula]

Brilliant thank you!