Code not recognising "myfilepath" workbook as Source

Field staff submit Excel sheets monthly that have to be added together in same cells in Master File.

Code below allows User to select a "Field Staff" file from File Manager, defined as "myfilepath" (works perfectly).

Selected file has data in Col B that has to be added to current value in matching cell in Master File.

But code throws an "Invalid qualifier" when I tell it to find the "myfilepath" file and get the matching value

Please Login or Register  to view this content.

Suggestions, solutions and improvements accepted gratefully as ever

Ochimus

Norie,

Many thanks for pointer,

I set the workbook reference as "SourceFile", which got past that hurdle, but when I try to copy the cell from it, it stops with a "RunTime Error 438 (Object doesn't sjupport this property or method)"

Please Login or Register  to view this content.

Ochimus

You have to specify sheet in Sourcefile.

Please Login or Register  to view this content.

bakerman,

Many thanks for correction.

Code now runs, and "steps through" the cells in the Master File, but is not adding the values!

The problem must be my defining "Source File".

When I select the file from File Manager, I define that "Active Workbook" as "SourceFile"

Presumably when I then select the Master File, it becomes the "Source File" because it's the active workbook?

This should be straightforward, and it's annoying that I can't see the obvious.

Ochimus

Ochimus

Please Login or Register  to view this content.

Too many Select - Activate to my taste, but if this works for you.