Bacth macro reading multiple input file

[sneha_bhiwagade1]

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

[binuacs]

@sneha_bhiwagade1 what error is it showing?

[sneha_bhiwagade1]

@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]

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

[sneha_bhiwagade1 · Accepted solution]

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

refer the attached screenshot

Thank You :)