Importing CSV data into a template or?

Alberto · External Since: Jul 12, 2004 Posts: 10

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 · External Since: Jun 19, 2005 Posts: 3716

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

"Alberto" <Alberto.DeleteThis@discussions.microsoft.com> wrote in message
news:4778B5A6-D925-4055-855D-B1B021CDE2DC@microsoft.com...
>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.

Alberto · External Since: Jul 12, 2004 Posts: 10

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/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
>
> "Alberto" <Alberto DeleteThis @discussions.microsoft.com> wrote in message
> news:4778B5A6-D925-4055-855D-B1B021CDE2DC@microsoft.com...
> >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 · External Since: Jun 19, 2005 Posts: 3716

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

"Alberto" <Alberto DeleteThis @discussions.microsoft.com> wrote in message
news:B3350FC4-BB8D-4638-AB13-1D99FE345269@microsoft.com...
> 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/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
>>
>> "Alberto" <Alberto DeleteThis @discussions.microsoft.com> wrote in message
>> news:4778B5A6-D925-4055-855D-B1B021CDE2DC@microsoft.com...
>> >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.
>>
>>
>>