fixing column width

[John P]

We create on a regular basis from Excel space delimited files for import to
other programs that require the width of the columns to be fixed. Problem
has come up that depending on which computer we are looking at the same file
a column width may be the required 4 characters wide but on the next
computer it show as 3.87 characters wide. How do we get the column width to
stay fixed at 4 no matter what computer is viewing the file? If it was only
one column this would be easy but we are talking about many columns that all
are okay on one computer but not on the other computer.

 

[scoobz]

One workaround would be to create the following macro and save it in
your workbook:

Sub auto_open()
'
Sheets("Sheet1").Select
Cells.Select
Selection.ColumnWidth = 4
Range("A1").Select
'
End Sub