Is it possible to print a chart which is in another workbook withou
opening that other workbook?

at the moment i have

Set snagworkbook = Workbooks.Open("Snagging List - 1.xls", False
True)
snagworkbook.Charts("Snag Graph").Select
snagworkbook.Charts("Snag Graph").Select
snagworkbook.Charts("Snag Graph").PrintOut
snagworkbook.Close False

this is kinda slow due to the network (im running this macro for 1
files to print 10 graphs), and even though I hav
application.screenupdating set to false, you can also still see th
file being opened and closed on the screen.

thank

--
neowo
-----------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...nfo&userid=594
View this thread: http://www.excelforum.com/showthread.php?threadid=50670