| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print out is not correct,page width differrant | Excel Discussion (Misc queries) | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| Create a macro which takes a column name and width and sets the column width to what it should be | Excel Programming | |||
| ActiveWindow.VisibleRange.Width - Is this the correct code | Excel Programming | |||
Linear Mode
