Shared Macro on Shared Folder Error

Hello there,

I have a macro saved to a shared drive. Both my colleague and I have access to the shared drive location.

However, whenever my colleague tries to run the workflow, she gets the below error. I decided to click insert macro and add the macro to the workflow on her computer, and then the workflow worked for her. However, I get this error after fixing it on her end. I thought if the macro is saved to a shared location, everybody with access to the shared drive location could use it. What am I doing wrong?

Error Message

Macros

Accepted answers

danilang

Hi @Kristie_Pires

The way that the directory reference is stored in the main workflow depends on you insert the macro into it. If you have the drive letter in the Open File dialog then the drive letter path will be stored in the main workflow. Any one that doesn't have the same drive mapping will get an error opening the workflow

If you change the directory specifier in the Open File dialog to include the UNC information, i.e. \\Server\Share\Work\Dan\Alteryx\Solutions\Creating a 4 quadrant matrix, that is what will be saved in the main workflow and anyone with access to that UNC path will be able to run the workflow.

Alternatively you can open the main workflow in a text editor like notepad and find the <EngineSettings Macro=... line and change the path there

Dan

All comments

BS_THE_ANALYST

Maybe a silly question, although it's a shared drive, will the file path be the same for you both? I.e. will it be: M:\ ........ , could this change for the other person?

Kristie_Pires

I am unsure why it shows up like that - I saved it with the whole path.

Kristie_Pires

Thank you @BS_THE_ANALYST for pointing out what might be the issue and thanks @danilang for further explaining. The problem is solved

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703