View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default csv, how to set excel to auto load

have them send you REAL .csv files. CSV stands for "Comma Separated Values".

Gina_Marano wrote:

I want to double click on a .csv file and have it automatically load
in to excel 2007.

Currently it opens it and puts all the data in column A. If I close it
and use data import all is fine.

Ridiculous for people to send me .csv files. I have to save first them
data import. Another way? Add-in?

~Gina_M~