I am fairly new to VBA and just getting the hang of things. One thing is puzzling me though. I have a large workbook (Hockey Data.xlsx) that has data stored in it and would like to copy data from it into a master workbook (Hockey Master.xlsm) without having to open the large workbook. The workbooks will be used on different computers, so using the path to call the workbooks can't be explicit.

One workbook is called Hockey Data.xlsx (this contains all of the data)
The often used active workbook is called Hockey Master.xlsm (this is where the data will be transferred to)

These workbooks will always be in the same folder, but in different directories for different users (this will be used on multiple computers, not networked). There does not have to be a link between changes from different users (ie Each user can manipulate Hockey Master.xlsm independently on their own computer)
I'm referring to this because I don't think (C:\User\MyDocuments\Folder\) will be universal for each user. Is there a way to set the parent directory equal to the folder that houses these two workbooks?

I need a way to call the data from Hockey Data.xlsx without opening it (once again it is large) and pasting it to Hockey Master.xlsm.

If anyone could help me on this subject I would GREATLY appreciate it! I have been struggling with it for a week or so now with little to no help. Thanks again!