You could record a macro, storing it in your personal macro workbook.
http://www.officearticles.com/excel/...soft_excel.htm
Try to select entire rows and columns while recording so your steps will
work on any number of rows.
************
Anne Troy
www.OfficeArticles.com
"Alberto" wrote in message
...
I have an application that exports data in CSV fromat to my Desktop or
wherever I want. When I open it, I want it to be formatted already
(columns,
rows, etc.). I will be doing this almost daily or every-other day.
The Data Connection Wizard doesn't seem to apply, and it's not XML or SQL
so
I'm not sure what I can do.