my macro in filename "ConfigureData.xlsm" uses a formula to get data from filename "DrawingData", and runs perfectly on my computer. here is a snippet of code:
Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=[DrawingData.xlsx]Page1!R1C4"
Range("A1").Select
When I run the macro on colleagues' computer it fails because the formula refers to my computer name and username. what can I do to run the macro on other computers without having to select "DrawingData" from menu-list?