Create and print a list of worksheet names

Occasional Visitor

I need to to print and save the worksheet names in a particular folder is there a way to do this

1 Reply

@Cowman738 The easiest would be to connect to a folder via PowerQuery. That will give you a view of all files in that folder. Normally, you would filter the files you want to transform/combine or whatever. But you can stop at this first step and load that table with filenames back to Excel. It will give you the Name, Extension, Dates accessed, modified and created and the full folder Path.

Riny_van_Eekelen_0-1654501494486.png