Extracting filename of workbook in addition to cell values extracted from that workbook

[patdools]

Hello,

I have code that extracts information present in particular cells in the target worksheet of Excel workbooks present in a OneDrive folder. I can successfully extract out the desired information from the target worksheet and I would also like to write out the filename of the Excel workbook that those values came from. I have the code below, but it is pulling the name of the Excel workbook that the data is written to - and I need to pll the name of the Excel workbook that the data is being extracted from. What adjustments do I need to make? The current version of code below.

Please Login or Register  to view this content.

[bakerman2]

Isn't cell.value the filename your extracting the values from ?

[patdools]

Hi Bakerman2 - What the cell.Value writes out is the value present in A14 in the source workbook (11 columns to the right of the 1 column in the target workbook/worksheet) & the value present in B14 in the source workbook (12 columns to the right of the 1 column in the target workbook/worksheet). What else do I need to also write out the Excel filename of the source workbook as well?

[bakerman2]

Please Login or Register  to view this content.

The name between square brackets is the name of the source workbook you're pulling information from.

So as I read you're code that's the name you're after.

Changing this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

will give you the name of the Source workbook.

[patdools]

This adjustment worked great - I didn't understand exactly what cell.Value was holding. Thank you for pointing that out - much appreciated!

[bakerman2]

Glad to help and thanks for rep+.