Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
11 - Bolide

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.