Archive for the ‘UI File Operations’ Category.
CSV, or comma-separated-values, files are native Excel file formats. That is, Excel can open and read them without any special converters. To create a CSV file, change the "Save as type" box in the Save As dialog box. Take a spreadsheet like this
From the File menu, choose Save As and change the type to CSV.
Excel will give you a warning message that some features cannot be saved. Since CSV is a text-only format, you don’t get anything fancy when you save under this method, just the raw data. Here’s what the file looks like in Notepad after it’s been saved.
When you try to close the newly saved CSV file from Excel, it will warn you that the workbook hasn’t been saved even though you know you just did it. I think Excel does this with all text-based formats and you can just ignore the warnings.
When you select New from the File menu, the New dialog box is displayed. Usually, the New dialog will have some tabs that organize the templates that are available. This example has the General, Spreadsheet Solutions, and Office 97 Templates tabs.
You can add your own tabs to this dialog by adding subfolders to the Templates folder. One way to find your templates folder is to type ?Application.TemplatesPath in the Immediate Window of the VBE.
If you have more than one version of Excel on your computer, Excel will show the contents all your Templates folders in the New dialog, even those from previous versions. Note that in my Templates folder that there is no Spreadsheet Solutions folder. It does exist, however, in the Templates folder of my Excel97 installation.
I’ve added a new folder called Dicks Templates. This folder will show up as a tab on the New dialog, but only if there is at least one Excel template in it. Once I put a template in it, the New dialog looks like this:
