Google Answers Logo
View Question
 
Q: Excel Macro to Automatically Print ( No Answer,   2 Comments )
Question  
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.
Answer  
There is no answer at this time.

Comments  
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

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy