Prev: Bookmark range
Next: Low-end temp predictions may bring 6-meter ocean level rise
From: Jonathan West on 18 Dec 2009 05:01

"Jeff" <Jeff(a)discussions.microsoft.com> wrote in message
news:357BA8E4-7A79-4A31-AB07-C2E64D0036D8(a)microsoft.com...
> Thanks For the help guys. The FSO created the folder correctly my trouble
> lied in the MoveFile method. The code was trying to move the file while
> still
> printing.
> Which brings me to another question aside from setting the Background
> parameter to True in th Application.PrintOut method is there a way to
> suppress the Printing Dialog box?

I presume you mean the print progress dialog which allows the user to cancel
the print job if he wants. There isn't any option within VBA to suppress
that dialog. If you are very clever with Windows API and timers, I believe
you can force the dialog to be minimised and/or hidden immediately after it
shows. If you really want to go that route, I'll leave you in the capable
hands of Karl. This is very much his area rather than mine.


--
Regards
Jonathan West

From: Karl E. Peterson on 18 Dec 2009 18:52
Jonathan West formulated on Friday :
> "Jeff" <Jeff(a)discussions.microsoft.com> wrote in message
> news:357BA8E4-7A79-4A31-AB07-C2E64D0036D8(a)microsoft.com...
>> Thanks For the help guys. The FSO created the folder correctly my trouble
>> lied in the MoveFile method. The code was trying to move the file while
>> still
>> printing.
>> Which brings me to another question aside from setting the Background
>> parameter to True in th Application.PrintOut method is there a way to
>> suppress the Printing Dialog box?
>
> I presume you mean the print progress dialog which allows the user to cancel
> the print job if he wants. There isn't any option within VBA to suppress that
> dialog. If you are very clever with Windows API and timers, I believe you can
> force the dialog to be minimised and/or hidden immediately after it shows. If
> you really want to go that route, I'll leave you in the capable hands of
> Karl. This is very much his area rather than mine.

I'm quite sure that'd be doable, yeah. It'd be very similar to
repositioning a MsgBox on demand (http://vb.mvps.org/samples/MovedMsg).
You'd just need to figure out the most basic clues about what makes
that dialog recognizable, then set a hook before allowing it to pop so
you can be alerted to take action when it does.

--
..NET: It's About Trust!
http://vfred.mvps.org


First  |  Prev  | 
Pages: 1 2
Prev: Bookmark range
Next: Low-end temp predictions may bring 6-meter ocean level rise