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.

VB6 sends the data from the form to a new Excel spreadsheet using the file name you entered in the code. Launch Microsoft Excel and open the new spreadsheet created by the VB6 application.

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.

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 ...

Also known as a Comma Separated Value file, a comma delimited file is a standard file type that a number of different data-manipulation programs can read and understand, including Microsoft Excel.