Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

File path error under "events"

vj28
8 - Asteroid

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. 

 

2 REPLIES 2
niklas_greilinger
10 - Fireball

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.

vj28
8 - Asteroid

I wasn't, everything's local.