ExecWB(4,1) Type=button value= save as> ExecWB(6,1) Type=button value= print>. I wrote some Excel VBA code to print webpages from webform connected to a SQL server database. I need the code to input 1, After digging around on the web for a while I found the ExecWB method. So if you want to print your HTML document that you are creating in.

Author: Groshicage Fenrisar
Country: Suriname
Language: English (Spanish)
Genre: History
Published (Last): 15 December 2007
Pages: 358
PDF File Size: 14.25 Mb
ePub File Size: 19.37 Mb
ISBN: 196-9-23150-644-4
Downloads: 85556
Price: Free* [*Free Regsitration Required]
Uploader: Mooguzilkree

The complete WebBrowser.ExecWB

Results 1 to 3 of 3 Thread: This site uses cookies. How do I click on the print button on the print Dialog box or how do I print the PDF ptint the third webpage without clicking or handling a dialog box. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that pdint have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Note that the comment about printing from Word was from my first round to actually print a txt file using Word, which had some significant challenges as well.


Close this window and log in. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. Is there a direct command to print the PDF on the Webpage. Students Click Here Join Us! Item 1 ‘ or. You are commenting using your Twitter account.

Print from Internet Explorer without the Printer Selection Box

Post as a guest Name. Setting the values to 6 and 2 respectively give the command to print without prompting the user. Join Date Aug Posts 9.

The time now is ExecWB arguments maybe i am missing something here? I really appreciate anything you can point out that is an issue. The while loop stops any further processing while IE loads the file.

Thanks PHV, and do you know by any chance how to set up this things without user prompt? Quick Navigation Visual Basic 6. We then make IE visible to display the file. Count – 1 ‘second tab IE.

IE print websites ( .ExecWB page setup?) – VBA Visual Basic for Applications (Microsoft) – Tek-Tips

Navigate “url” Do While IE. ExecWB 6,2 displays print dialog box.

This compensation may impact how and where products appear on this site including, for example, the order in which edecwb appear. Developing Multithreaded Applications Slow Chat: Join your peers on the Internet’s largest technical computer professional community. Shank 1 2 Edvins 2 6. Thank you for your input and time testing!


None of my html files print, but IE opens and shows the file contents perfectly formatted. Red Flag This Post Please let us know here why this post is ptint. HI I have the following function that allows printing internet websites. To find out more, including how to control cookies, see here: I am trying to print a PDF after navigating through webpages.

The pritn is ableto find the Print dialog box and set it on the foreground. Some of the products that appear on this site are from companies from which QuinStreet receives compensation. It worked without any problem using normal and elevated privileges. Promoting, selling, recruiting, coursework and thesis posting is forbidden.