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: Taugis Mikalmaran
Country: Austria
Language: English (Spanish)
Genre: History
Published (Last): 16 March 2015
Pages: 304
PDF File Size: 15.35 Mb
ePub File Size: 8.27 Mb
ISBN: 111-3-17198-798-9
Downloads: 60718
Price: Free* [*Free Regsitration Required]
Uploader: Dotaur

According to this postthe second parameter controls the behavior of the print dialog, so:. All times are GMT The navigate method allows us prit decide the file that will be opened. Join your peers on the Internet’s largest technical computer professional community. Wednesday 16 September at 9: Promoting, selling, recruiting, coursework and thesis posting is forbidden.

ExecWB 6, 2 ‘Application. Edvins 2 6. Red Flag This Post Please let us know here why this post is inappropriate. Print “didn’t find button! Shank 1 2 Create a free website or blog at WordPress.


Appreciate the post immensely! You were mostly there. Register now while it’s still free! You are commenting using your Twitter account. ExecWB arguments maybe i am missing something here?

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

By joining you are opting in to receive xeecwb. The example should click the print button after calling the ExecWB command. Does anyone have any idea? To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3. Leave a Reply Cancel reply Enter your comment here Sign up or log in Sign up using Google.

Thank you for your input and time testing! I added some conditional compilation conditions to specify the correct API call depending on the platform. You are commenting using your WordPress.

Print from Internet Explorer without the Printer Selection Box

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 prinh well. We start by creating an object that represents Internet Explorer. Notify me of new comments via email.


Exactly what is needed. How do I print this page?

Close this window and log in. Tuesday 22 September at 1: Hope This Helps, PH. Developing Multithreaded Applications Slow Chat: Windows 8 for Developers Slow Chat: The while loop stops any further processing while IE loads the file.

We then make IE visible to display the file. Fill in your details below or click an icon to log in: Sign up using Facebook. Anyway, I have this as a task for the next phase Q1 of our Intranet update.

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. I couldn’t find anything amongst. Students Click Here Join Us! Post as a guest Name. The code is ableto find the Print dialog box and set it on the foreground.

Results 1 to 3 of 3 Thread: