I wouldn't bother with a macro.

I'd import the data
Select all the cells
(click on that grey box to the left of the column headers and above the row
headers)
and then adjust all the columns at once by double clicking on any of those
column separator lines.

Ctrl-A (a few times, depending on your version of excel) is another way to
select all the cells.





cornelius1729 wrote:

I'm currently working with a lot of comma separated value (.CSV) files.
Whenever these files are opened in Excel (2000), since all size
information is not present, each cell is given the same tiny size.

What I need is either
1. An option that says "automatically fit cell sizes to contents upon
file opening", or

2. A method of fitting cell sizes to contents that is quicker and less
tedious than double-clicking at the top of each column (since there are
40 or so columns in each spreadsheet).

Before you ask, no I can't just save the files in .XLS format, they
need to stay as .CSV files for compatibility with other software.

Do either of my options exist?

Thanks in advance for your response,
Richie.

--
cornelius1729
------------------------------------------------------------------------
cornelius1729's Profile: http://www.excelforum.com/member.php...o&userid=36749
View this thread: http://www.excelforum.com/showthread...hreadid=564690

--

Dave Peterson