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
Resolved by adding $ symbol at the end in sheet name formula.
refer the attached screenshot
Thank You
@sneha_bhiwagade1 what error is it showing?
@binu_acs 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.
Yeah, it doesn't work well with spaces within a Sheet Name. Glad you found the Macro and pre-steps useful!
