ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print CSV File With Correct Column Width (https://www.excelbanter.com/excel-programming/420859-print-csv-file-correct-column-width.html)

todtown

Print CSV File With Correct Column Width
 
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

Dave Peterson

Print CSV File With Correct Column Width
 
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.





todtown wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com