Actaully I was hoping NOT to have to write anything. I was hopign to be lazy
and merely swap out teh .csv file and the next 'reload' things would refresh.
Reading up on Excel 2003 and XML , this may be supported if I upgrade. I just
don't wantto have to re-generate frick'n .gif images.... :-) If we can
upgrade then I guess I will have to look towards your implementation.

thanks

"Tushar Mehta" wrote:

Well, once you complete the setup done by hand, any changes to the CSV
file will automatically show up in the chart, won't they?

Of course, you will have to write the necessary VBScript and/or VBA to
run XL, open the CSV and XLS files (the charts will update
automatically), and export the charts to the appropriate location.

I did something similar for a pharmaceutical company recently -- well,
a bit more complicated {grin} -- and it's fully automated using a
VBScript scheduled through the Windows Scheduler.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions