Broken Macro

[moshood]

I have a macro which is designed to pull data file names from a input directory tool and from there it will pull the relevant data in the alteryx flow. This was working perfectly until the file path of where the data was being stored changed. I have tried to change the file path to the new paths but it runs when in a separate tab and within the macro but when i run the macro it provides an error message "file not found".

Can anyone explain what is causing the issue and how it can be fixed?

[binuacs]

@moshood Can you un-check the replace specific string  (highlighted in yellow below )and try?

[moshood · Accepted solution]

Hi there, 

Thanks for getting back to me but this has not worked. 

i have attached the error messages

[grazitti_sapna]

Hi @moshood, could you please try this updated macro in your workflow and try to run it again and let us know if it works?

Also, you need to pass full path along with the sheet name in your field outside the macro which you are trying to replace inside the macro.

Thanks!

[binuacs]

@moshood the replace specific string in your macro only replacing the path up to the folder 'COMBINED schedules 2020'

'\\emea.cbre.net\data\Shares\UK\GP\NEW S Drive\RESIDENTIAL\BtR Data and Analytics\BtR Data final\Mosh Tenancy schedules\BtR combined data -Do not move\COMBINED schedules 2020'

you need to make sure that in your formula tool has the folder \2020 Quarter 2\ along with the full path or update the replace string inside the macro with the full path

'\\emea.cbre.net\data\Shares\UK\GP\NEW S Drive\RESIDENTIAL\BtR Data and Analytics\BtR Data final\Mosh Tenancy schedules\BtR combined data -Do not move\COMBINED schedules 2020\2020 Quarter 2\'

[moshood]

Hi there @grazitti_sapna 

thanks for helping unfortunately it has not worked. 

The error message says " no sheet specified, you must specify a sheet" 

[moshood]

This now matches but is only running one line of data from thousands. i have attached the error message.

[grazitti_sapna]

Hi @moshood, could you please give us a screenshot of the workflow outside the macro, or if you could share the workflow?

You can try this as well

1. Try using the directory tool to read the file path. Follow the configuration.

2. Pass this in control parameter.

Edit: After running the macro I can see all the records. Please refer to the screenshot.

Thanks!

[moshood]

Hi @grazitti_sapna 

This is exactly how i have the macro and directory tool set up. 

i am happy to jump on a quick zoom/teams call to show you?

Best, 

[grazitti_sapna]

@moshood, in file specification, can you please try to pass *.xlsx 

Thanks!