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-p/902250/highlight/true#M218319)
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.