add filename as a column

[mm900]

can someone share how may i add the filename of workbook1 as a column to another workbook2's spreadsheet while i also bring the other columns of the workbook1' only spreadsheet? thank you?

 

[Stevie]

Hi mm900,
your query is a bit vague and hard to understand. Please provide an example of the first and second workbooks, and the the layout of the desired output. Please also provide any code you have written so far.
Doing this will increase your chances of getting a solution to your problem from this forum.
Stevie