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.
>
|
Similar Threads
