Macro to name sheet with imported .CSV file name

Use InsStrRev().

Of course you will need to iterate the sheet names to see if it exists. You would also need to verify that the filename is a valid sheet name.

Please Login or Register  to view this content.

Thank you very much
this has helped, and this is the code i ended up with:

Please Login or Register  to view this content.

(now i just need to make sure that the filenames are no longer than 31 caracters and don't contain / \ etc.)

Again many thanks.
Michiel