Hi,

I`m sure this has been discussed before but I can`t seem to fin
exactly what I`m looking for in previous threads.

I use a macro to print a chart to file. Excel then prompts with a prin
to file - output filename messagebox. At this point my macro stop
because I haven`t dealt with this. How do, in vba, specify the filenam
thereby completing the process of printing tha chart to file

--
hk
-----------------------------------------------------------------------
hke's Profile: http://www.excelforum.com/member.php...nfo&userid=155
View this thread: http://www.excelforum.com/showthread.php?threadid=26950