Linking a graph to a csv file

[Smitty]

**Excel 2002

Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
with this? I just want to be able to link this up and
let it run every month.

Thanks much!!

 

[Don Guillett]

I recently created a macro for a client that opens the csv file, gets the
data required for the chart, closes the csv file. All that the client had to
do was type in the name of the csv file such as: file1. The rest is done
without seeing anything or doing anything.

 

[Jon Peltier]

This can be carried further. Here are a couple possibilities:

* Allow the user to browse to a directory and process each csv file in
that directory, or selected csv files, using the multiselect option for
GetOpenileName.

* Somewhere in the workbook, list the directory, or the file name(s) to
be processed each time a button is clicked, or each time the workbook is
opened.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

It is possible, of course, to use PowerPoint and VBA (without Excel) to
create the chart from a text file. Microsoft has this article that
describes how:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q222687

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______