open and run macro file on different computers

Status
Not open for further replies.

andymalan

Board Regular
Joined
Feb 22, 2017
Messages
78
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?
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,111
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,109,489
Messages
5,529,168
Members
409,853
Latest member
Amy Gassett
Top