| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print a chart in another workbook without opening the workbook?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print workbook without opening it | Excel Discussion (Misc queries) | |||
| Print Chart in Shared Workbook | Excel Discussion (Misc queries) | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
![neowok[_85_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
