Getting file name using vba and outputting it in excel

[wolfdemon710]

Hi,

The code is to get the file name from a specific folder and output it in a specific cell. However, the output of the file name is "Test.xls", I just the output to look like "Test". I dont want the .xls to be included. Any suggestions?

Please Login or Register  to view this content.

[LJMetzger]

Hi wolf,

Try the following (untested):

Please Login or Register  to view this content.

Lewis