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


--
OnlineWealth
------------------------------------------------------------------------
OnlineWealth's Profile: http://www.excelforum.com/member.php...o&userid=30017
View this thread: http://www.excelforum.com/showthread...hreadid=497075

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

Please refer to the Help file for details. Regards.

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

--
OnlineWealt
-----------------------------------------------------------------------
OnlineWealth's Profile: http://www.excelforum.com/member.php...fo&userid=3001
View this thread: http://www.excelforum.com/showthread.php?threadid=49707

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

--
OnlineWealt
-----------------------------------------------------------------------
OnlineWealth's Profile: http://www.excelforum.com/member.php...fo&userid=3001
View this thread: http://www.excelforum.com/showthread.php?threadid=49707

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

search for Filename.

OnlineWealth wrote:
>
> 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,
>
> Mike
>
> --
> OnlineWealth
> ------------------------------------------------------------------------
> OnlineWealth's Profile: http://www.excelforum.com/member.php...o&userid=30017
> View this thread: http://www.excelforum.com/showthread...hreadid=497075

--

Dave Peterson

Got it. That was easy, Thanks Dave.

Mike


--
OnlineWealth
------------------------------------------------------------------------
OnlineWealth's Profile: http://www.excelforum.com/member.php...o&userid=30017
View this thread: http://www.excelforum.com/showthread...hreadid=497075