Hi,

I have a single chart in excel which is indexed to a table so that I can
select via a combo box which range of data I require to chart.

Currently I can print out every variation of the chart via a simple macro,
by looping to change the index row value.

My question is, I need to produce these charts in PDF format. But when I
print to Acrobat Writer is uses the excel filename as the PDF filename, how
can use the index value as the PDF Filename.

Thus allowing me to add this code to my existing macro to allow me to print
every variation of the chart to a single directory without having to rename
the pdf files as they are printed.

By the way I have 660 different index values / charts to produce on a weekly
basis.

Thanks
Stuart