open and run macro file on different computers

[andymalan]

hello anyone?
I have a macro enabled wb (ConfigureData) that depends on data from a non-macro wb (DrawingData). ConfigureData has a formula to get data from DrawingData, and place the data into sheet1 of ConfigureData.
Both wbs are in a folder named "ExcalDataConfig".

When I run the macro on my computer, (the computer that I wrote the macro on), everything works fine.
When I try to run the macro on a different computer, (I copied the ExcalDataConfig folder to a colleague's computer), the macro does NOT run, as it cannot find the wb DrawingData, even though both wbs are in the same folder.
Can you please tell me how to to this?

 

[steve the fish]

If it cant find the workbook then the workbook isnt in the folder given by the supplied path. You can check the path of each file by right clicking it, then clicking properties. It will show Location of the file.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...cros-created-computer-1-use-computer-2-a.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).