|
|
Subject:
Excel Macro to Automatically Print
Category: Computers > Programming Asked by: tigers-ga List Price: $2.50 |
Posted:
01 Nov 2004 06:40 PST
Expires: 01 Dec 2004 06:40 PST Question ID: 422900 |
I need a Microsoft Excel macro that will automatically print a document that is clicked on in a hyperlink in Excel. For example, if you click on a hyperlink in Excel for a Word or Excel document it will automatically print it. |
|
There is no answer at this time. |
|
Subject:
Re: Excel Macro to Automatically Print
From: ptrajkumar-ga on 01 Nov 2004 09:32 PST |
why dont you post your questions to any of these newgroups. http://groups.google.com/groups?hl=en&lr=lang_en&group=microsoft.public.excel It would be faster and free. |
Subject:
Re: Excel Macro to Automatically Print
From: lannaeus-ga on 03 Nov 2004 02:10 PST |
Hi tigers, Interesting question. I have found a macro that could be useful for you: Sub test() Dim WD As Object Set WD = CreateObject("Word.Application") WD.Documents.Open ("C:\ron.doc") WD.ActiveDocument.PrintOut Background:=False WD.ActiveDocument.Close WD.Quit Set WD = Nothing End Sub The newsgroup thread can be found here: http://groups.google.es/groups?hl=es&lr=&threadm=21D1F0C6-1B98-4C4B-913E-79B920340B1B%40microsoft.com&rnum=3&prev=/groups%3Fq%3Dprint%2Bhyperlink%2Bdocuments%2Bexcel%2Bmacro%26hl%3Des%26lr%3D%26selm%3D21D1F0C6-1B98-4C4B-913E-79B920340B1B%2540microsoft.com%26rnum%3D3 Let me now what do you think. Thanks, Lannaeus |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |