Importing CSV data into a template or?
 

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.

Importing CSV data into a template or?
 

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.

Importing CSV data into a template or?
 

Thanks, that seems to do what I need. Next question: I worked it out on my
workstation. How can I take the macro to another person's workstation so I
don't have to do it all over again?

"Anne Troy" wrote:

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.

Importing CSV data into a template or?
 

See this article, Alberto:
http://www.vbaexpress.com/forum/arti...ticle&artid=18
************
Anne Troy
www.OfficeArticles.com

"Alberto" wrote in message
...
Thanks, that seems to do what I need. Next question: I worked it out on my
workstation. How can I take the macro to another person's workstation so I
don't have to do it all over again?

"Anne Troy" wrote:

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.