Find last row in closed workbook using file path name

I'm trying to define a variable as the last row in a closed file. I understand how to make the value of a cell equal to a value in a closed workbook, but I can't figure out why it's not similar when defining a variable as the last row of a sheet in a closed workbook. I'm trying to get all of the data in the closed worksheet into the open worksheet but the number of lines of data that the closed sheet can have varies. Here's what I have right now:

Please Login or Register  to view this content.

And this is the part that throws up an error:

Please Login or Register  to view this content.

I know there's a way to do it by opening the Closed Workbook, but there's got to be an easier way, right? Any help is much appreciated!

so you want to get into a locked room, measure it without opening the door

Nevermind. I figured it out. For anyone else's reference here's my modified code:

Please Login or Register  to view this content.