Forum Discussion

Cowman738's avatar
Cowman738
Copper Contributor
Jun 05, 2022

Create and print a list of worksheet names

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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

     

Resources