Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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.