Now click the icon showing the dog-eared page with the Excel logo on it. The code & [File] should appear. Now click OK. The file name will appear in the header when you print the file.

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...

For each sheet, the code uses the Name property to enter that name in column A, beginning at A1, in Sheet1. Listing A Sub ListSheetNames () ‘List all sheet names in column A of Sheet1.