Print CSV File With Correct Column Width

  • Thread starter Thread starter todtown
  • Start date Start date
T

todtown

Hi All,

I want to be able to print CSV files directly to the printer so that
the data appears in columnar format. I know I can open them in Excel
and adjust the column width. However, this has to work without opening
the file. Any suggestions?

tod
 
The point of using CSV files is that each field is separated by a comma. So the
data isn't in columns.

Maybe you could create a macro that would open the CSV file, autofit the
columns, print the worksheet, and close (without saving) the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Maintaining Column Widths in CSV Format File 1
Changing a csv file opened as hidden workbook 13
Column Width 3
Opening CSV File 1
Data in columns 1
listbox - code to adjust column widths 4
Using ADO to insert values into CSV file 1

Back
Top