 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / July 2005Print all the worksheets in an embedded Excel workbook
I'm not sure if this is a vba question but ... Is there a way from within word that you can print the word document plus all the worksheets from an embedded excel workbook? David > Is there a way from within word that you can print the word document > plus all the worksheets from an embedded excel workbook? Might be VBA, then again... Do you mean print them independently of the Word document? As in open them in the Excel application and print them? Yes, it can be done using VBA. If you mean, just everything, then please explain how clicking the "Print" button in the Word toolbar is NOT working. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Using the print button in word prints the word document plus the displayed worksheet of the embedded spreadsheet but I want to have all the sheets in the workbook print. I figured out that I could control excel from word to print the complete spreadsheet but which was basically equivalent to opening excel from word and then selecting the corresponding workbook to print. This works okay but the document and workbook are not linked. My preferred method would be link the workbook to the document and then at the time of printing have word print all sheets in the workbook. David Cindy M -WordMVP- wrote: > > Is there a way from within word that you can print the word document > > plus all the worksheets from an embedded excel workbook? [quoted text clipped - 16 lines] > This reply is posted in the Newsgroup; please post any follow question > or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.