Home » Forums » Open Source Learning Center » Question and Answer

Click the print button

Submitted by noel_vales on 24 January, 2014 - 17:06

Hi I have the following code in VBA i just wanted to click the print button on the print pop
and enter a file name ans save

Code

Call objIE.document.parentWindow.execScript("doPrint()", "JavaScript")

used SendKeys "(%{ENTER})" ***but it does not work

please help

code stops here
AttachmentSize
code stops.jpg57.37 KB
‹ convert crosstabs into flatfile How to Parse ›
»

did you do the SendKeys

Submitted by chris on 24 January, 2014 - 22:28.

did you do the SendKeys before the execScript command? I ask only because, erm, I've made a similar mistake once...

Chris

»

no used it after the

Submitted by noel_vales on 25 January, 2014 - 06:13.

no used it after the execscript command

»

I think you'll need to use it

Submitted by chris on 27 January, 2014 - 18:26.

I think you'll need to use it before, in order to get the keypresses into the buffer. Otherwise your code will be waiting for the ExecScript command to finish.

Chris

»