Format CSV file based on data and convert to .xls

I have CSV files generated with unknown number of rows, anywhere from 1 to the maximum. The columns will be constant, likely B2 - AO2. I have recorded a macro to do what I want, however, when recording, I can select the existing cells containing data. What I want to do with the raw CSV file:

1. Select all columns and resize to fit
2. Starting at B2, select all cells to Rn, Cn, where 'n' is the final row & column containing data (will only be 0 or 1)
3. Select only the cells with 1 in them, and highlight
4. Optionally prompt to save as filename.xls

I'm not a programmer, but can muddle through ok, and identify basic structure. I can share an example if needed, but it's pretty simple and straightforward data.

Thanks,
Mark

I normally do not respond to posts that don't have a sample file attached since it's too much work (normally) to recreate the issue or requirement. In other words, if you attach a sample file, it is more likely that someone will respond.

Having said that, I just happened to have a CSV file laying around so I went forth and VBA'ed.

The odd thing about this spreadsheet is that it is merely a container for the VB code and except for some parameters you supply, doesn't get involved in the program at all.

Cell B1 contains the path name to where the CSV file exists.
Cell B2 contains the name of the CSV file.
Cell B3 contains the name of the output file.

If cell B3 is blank, then the program creates a name based on the CSV file name. So XYZ.csv gets written to XYZ.xls.

Some of this programming (autofit and conditional formatting) was done by recording macros and modifying them.

In answer to one of your questions, note the computation of LRowC and LColC. These are "standard" formulas for getting the last row in a column and the last column on a row.