Close Print Dialogue Box after printing using VBA

[ashvinsolanki]

Hi Guys

I have a process that goes through a few sheets of Excel and finds links in a particular column that go to web pages and these i then need to print to Adobe PDF

the links are similar to :
http://www.rightmove.co.uk/property-...rtyId=47021753

Which automatically send you to a print function

As side effect to this is that i then get multiples of the "PRINT" Dialogue boxes that remain open as the printing process to a default printer and save as filename is already automated in my vba code.

(screenshot attached of the dialogue box that needs to be removed)

Is there a way for me to be able to dismiss the Print Dialogues that pop up with a "Cancel" command so that the screen is tidy at the end of the process?

Thanks for any tips to help me achieve this

Ash

[nathansav]

Why not just save them as PDFs using the Save AS? You could record this, then alter the code accordingly.

[ashvinsolanki]

Hi NathanSav

It doesn't record the dialogue windows clicks outside of Excel using the record function
If you have any tips that can help me do this, greatly appreciated

The link i provided is a good example if you wanted an example to test

Thanks
Ash

[nathansav]

Save as PDF from Excel.

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\nsavidge\AppData\Roaming\Microsoft\AddIns\Book1.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, _
OpenAfterPublish:=False

Are you printing from Internet Explorer?

[ashvinsolanki]

Hi Nathansav

Im not trying to print from excel - this is why its trickier......the macro opens the link and then the macro prints the brochure from the webpage and saves it to a desired location
The issue is i have these print dialogues left on screen that dont close as part of the process and when the macro finishes - im left with many of these that need to be cancelled manually
so i need help on how can i clean these up by adding something to to script to do this at the end.

Sorry if i was not clear before
Ash

[nathansav]

Have you seen this
http://www.experts-exchange.com/Prog..._20195891.html