Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

Open the Excel 2010 file you want to save as a comma delimited file. Once the spreadsheet opens, click the specific spreadsheet that you want to save from the list of worksheets at the bottom of ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...