We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Bacth macro reading multiple input file

sneha_bhiwagade1
8 - Asteroid

Hi All,

 

I am having a batch macro which reads multiple excel files.

 

but when there is space in sheet name the batch macro fails.

 

Many Thanks

 

 

4 REPLIES 4
binuacs
21 - Polaris

@sneha_bhiwagade1 what error is it showing?

sneha_bhiwagade1
8 - Asteroid

@binuacs the error is does not match a sheet name or named range or the file is corrupted.

 

If I remove the space from the sheet batch macro reads that particular input file.

 

Many Thanks :)

caltang
17 - Castor
17 - Castor

Yeah, it doesn't work well with spaces within a Sheet Name. Glad you found the Macro and pre-steps useful!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
sneha_bhiwagade1
8 - Asteroid

Resolved by adding $ symbol at the end in sheet name formula. 

 

refer the attached screenshot

 

Thank You :)

Labels
Top Solution Authors