Sheet name after importing CSV File

  • Sorry to bother again guys,
    Normally I like to have my answers by my self but this time I found the same answer everywhere but it does not work on me.
    I'am importing a CVS file named (Test) and when it comes to my current Workbook the "sheet name" does not take the "File Name" amd it keeps giving the sheets the normal name.. Sheet1, Sheet 2, Sheet 3 etc etc.
    Does any of you can take a look to my Code...
    I will appreciate.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!