using a macro I created, on a colleagues computer

0

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?

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login