 |
 | 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 / Excel / Programming / March 2008useing a macro copied
Someone tried to respond to this link will not open. I tried google stumped HELP copy a macro over to run from vba in Excel works fine in word. When try from excel will not go to printer following is code this is only part. Have noticed that .destination all ways goes to small not caps Thanks to all With ActiveDocument.MailMerge '.Application = ActivePrinter .destination = wdSendToPrinter error 5852 required object not available ' Application = ActivePrinter 'ActiveSheet.PrintOut .MailAsAttachment = False .MailAddressFieldName = "" That is the way the world is (at least in Microsoft's version). Each office program uses it's own objects, properties, methods and constants with very little overlap. Code for Word will not work in Excel and vice versa. Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm  SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Curt" wrote in message Someone tried to respond to this link will not open. I tried google stumped HELP copy a macro over to run from vba in Excel works fine in word. When try from excel will not go to printer following is code this is only part. Have noticed that .destination all ways goes to small not caps Thanks to all With ActiveDocument.MailMerge '.Application = ActivePrinter .destination = wdSendToPrinter error 5852 required object not available ' Application = ActivePrinter 'ActiveSheet.PrintOut .MailAsAttachment = False .MailAddressFieldName = "" Thank you for responce. I was unaware that a macro was stored in the document. There by I can build macro in document with no problem. Thank You much for your responce to a novice. Stii learning > That is the way the world is (at least in Microsoft's version). > Each office program uses it's own objects, properties, methods and constants > with very little overlap. > Code for Word will not work in Excel and vice versa. > > Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
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.