Autmating CSV Import???
 

Can someone help me determine what the general process involved in
accomplishing the following task would be? I am trying to automate a system
in which data from a CSV file is used to automatically populate various
tables in an Excel worksheet. I then want those tables to be linked to a
Word document.

So basically, I have a program that generates a CSV output with all of the
data that I need for my charts and tables and some of the text in my final
Word report. I am clearly not a programmer, and not what I would call an
advanced Excel user, but I need to accomplish this automation. Can someone
tell me where to begin to look to find out how to do this? Am I going to be
programming macros, or is their some proprietary piece of software that I
will need. Thanks a lot.

Autmating CSV Import???
 

Can you manually put the links into the word document? Then every time the
CSV file gets read the link will automatically get updated.

To put the links into work, go to excel and copy a range - then paste
special clicking the link box.

You will need a macro to automate the reading of the CSV. I would recommend
using the DAta Menu - Importing External Data - Inputting Data. Before
reading the data turn on a Record Macro (Tool Menu -Macro) so excel will
automatically create the macro. You can then post the recorded macro on this
website if it needs any modifications.

"abro" wrote:

Can someone help me determine what the general process involved in
accomplishing the following task would be? I am trying to automate a system
in which data from a CSV file is used to automatically populate various
tables in an Excel worksheet. I then want those tables to be linked to a
Word document.

So basically, I have a program that generates a CSV output with all of the
data that I need for my charts and tables and some of the text in my final
Word report. I am clearly not a programmer, and not what I would call an
advanced Excel user, but I need to accomplish this automation. Can someone
tell me where to begin to look to find out how to do this? Am I going to be
programming macros, or is their some proprietary piece of software that I
will need. Thanks a lot.