| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
useing 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 = "" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
useing a macro copied
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 -- Jim 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 = "" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
useing a macro copied
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 "Jim Cone" wrote: 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 -- Jim 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 = "" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return while useing CONCATENATE | Excel Discussion (Misc queries) | |||
| Copied formula produces unexpected copied results | New Users to Excel | |||
| Useing If to Delete a Range | Excel Programming | |||
| Macro copied from ng returns a #VALUE! | Excel Programming | |||
| useing arrows to move | Excel Discussion (Misc queries) | |||
Hybrid Mode
