Macro File Locator shortcut

Hi,

I have created a macro, which includes an input data tool within the macro. I am having issues with inserting a generic file address for this input data, as once I pass over the alteryx package, I do not want the user to have to open the macro, and change the address of the input data tool within the macro. Assuming the file address is of the input excel is "C:\Users\a\b\c\d\e\f\g.xlsx". When I change it to ".\f\g.xlsx", i get an error stating that the file cannot be located.

Does anyone know a solution to this?

Thanks,
Daniel

Macros

Accepted answers

Drussek

The file indicated in the macro will always be replaced with the one indicated in flow. The template used in the macro will only be used when editing the macro, but I assume users will not do so, and even if they then select their own file.

Good luck danielmaguire.

All comments

Drussek

If you use file browse from interface, then user will have to select file before running flow.

danielmaguire

Thanks Drussek, on the configuration panel, can I then have the file path populated with the shortcut to the input file, or will the user have to select the file themselves?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703