summing values for all items across multiple workbooks

Hi,

with at least an attachment of two source files and a data filled attachment for the expected result workbook according to both sources files,
all the necessary informations (where must be located the VBA procedure, 'same folder' is always the same or may change, …)
anyway all important to know which will move your guessing thread to the thread expected whatever the forum …

hi
the directory should be "C:\Users\OSE\Desktop\asd"
and I added two files

For the files uploaded.

Please Login or Register  to view this content.

@Jindon thanks but it shows this error "invalid use of null" in this line

HTML Code: 

what means?

So apparently you are testing with the different files...

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If this change does not work, need to see you file(s).

@Jindon no theses are the same files , I've found my mistake because the file sum.xlsm also is existed in the same folder when I put in another place your code works excellently
many thanks professional

@Jindon after you if it's possible to mod the code each file contains multiple sheets so when summing across multiple workbooks then should summing the items for each sheet
would you see the files and the result in file sum ?

Try change to

Please Login or Register  to view this content.

it's very impressive ! thanks so much