Working with a combined workbook macro and need to add filename from each source book to C

Excel Ver. 2010

I have built a WB that combines the data from 50 or so WBs with a list of the files in Tab "List" and the data from each WB into Tab "Data"

I need to import the file name and write it into Column A of the Data tab. I know I will need to move the copy to column 2 and can do that. My problem is that the only code I see is how to fill data that is already in the source sheet such in the code below. My file name is not in the data sheets I am combining, so the code below does not work for that.

I am using a list of the files from the Tab "List"

Code from Live Lessons: Excel VBA and Macros with Mr Excel:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks!
-SS

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)