I'm trying to run an excel macro file through Alteryx using "events" under workflow-configuration.
Under command arguments, I put the path to said file, which goes something like :
C:\Users\username\Desktop\process name\process_files\excel_macro_file.xlsm
I get two errors thrown saying :
Couldn't find "C:\Users\username\Desktop\process.xlsx" (why does this say xlsx anyway?)
Couldn't find "name\process_files\excel_macro_file.xlsm"
I understand that the problem is because I have a space in one of the folder names. What would be the proper synatx to use?
Based on an answer I found here :(https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-file-path-is-corrupted/m...
I tried writing the path as : C:\Users\username\Desktop\`process name$`\process_files\excel_macro_file.xlsm
but that didn't make a difference.
I'm new, so any help would be cool.
Are you trying t0 run the macro on server? Then your server needs to have access to the paths you provide or you have to upload the files with the macro.
I wasn't, everything's local.