Importing CSV data into a template or?

[Guest]

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.

 

[Anne Troy]

You could record a macro, storing it in your personal macro workbook.
http://www.officearticles.com/excel/record_a_macro_in_microsoft_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

 

[Guest]

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]

See this article, Alberto:
http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=18
************
Anne Troy
www.OfficeArticles.com