Add filename in a new column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OnlineWealth - 30 Dec 2005 23:46 GMT

Is it possible to add the actual name of the file in a new column when I
open each file with Excel.

I have multiple files that I need to have the file name included with
each row within the file.

So, I'd like to be able to just open each file and it automatically
inserts a new column and includes the file name in each cell for every
row.

Is this possible?

Thanks,

Mike

Signature

OnlineWealth

Reply to this Message

tkt_tang@hotmail.com - 31 Dec 2005 13:46 GMT

Say, =Cell("Filename",A1) to be placed in worksheet cell A1.

Please refer to the Help file for details. Regards.

Reply to this Message

OnlineWealth - 31 Dec 2005 16:02 GMT

Thanks that helps, although it also includes the path of the file i.e.
C:\Folder\Filename.

Would you happen to know how to exclude that in the code?

Thanks,

Mik

Reply to this Message

OnlineWealth - 31 Dec 2005 16:02 GMT

Thanks that helps, although it also includes the path of the file i.e.
C:\Folder\Filename.

Would you happen to know how to exclude that in the code?

Thanks,

Mik

Reply to this Message

Dave Peterson - 31 Dec 2005 16:22 GMT

Chip Pearson has a bunch of variations at:
http://www.cpearson.com/excel/excelF.htm

search for Filename.

> Thanks that helps, although it also includes the path of the file i.e.,
> C:\Folder\Filename.
[quoted text clipped - 10 lines]
> OnlineWealth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30017
> View this thread: http://www.excelforum.com/showthread.php?threadid=497075

Signature

Dave Peterson

Reply to this Message

OnlineWealth - 31 Dec 2005 16:43 GMT

Got it. That was easy, Thanks Dave.

Mike

Signature

OnlineWealth

Reply to this Message