This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can avert the schema issue you are having with the list of sheet names by going to the interface designer, and then the settings pane and set this too 'auto config by name rather than error if different.
This is an issue I have faced in the past when trying to create a similar macro.
Thanks a lot for the solution.This is exactly what i wanted.
A quick ques though.
I will only be needing till the First macro output as the intention is to get the filename sheet name combination.
If I remove the formula tool after the first macro Output,I am not getting the list but if i keep it (the formula tool after the first macro Tool:Formula 7)the Macro out and Formula out will both have the same output (List of filenames and sheet names).