PC Review


Reply
Thread Tools Rate Thread

how to close Printer status bar

 
 
how to close Printer status bar
Guest
Posts: n/a
 
      3rd Dec 2009
HI,
I Open a Excel File with 'Excel.Application', then print Active WorkBooks.
this ExcelApplication show a dialog Mesage with 'pRING THE FIRST PAGE TOTAL
PAGES 2 ..........' .THIS IS A USEFULL MESSAGE,BUT In my programe. i don't
need.
please help me how to close this message.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      3rd Dec 2009
Excel can't control this. But you can use an API.

Saved from a previous post:

There are API calls that can freeze your screen so nothing moves. But if
something goes wrong, it's reboot time. I wouldn't use them. I'd live with
minor flashing.

At the top of the module:

Declare Function LockWindowUpdate Lib _
"user32" (ByVal hwndLock As Long) As Long
Declare Function FindWindowA Lib _
"user32" (ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

In your code:

Sub whatever()
'do stuff

'freeze the screen
hWnd = FindWindowA("XLMAIN", Application.Caption)
LockWindowUpdate hWnd

'do more stuff

'unfreeze the screen
LockWindowUpdate 0

'do more stuff

End sub

Remember to save your work often (in all open applications!) if you use this.
You may be rebooting more than you want. (I wouldn't use this--but I've said
this before.)

how to close Printer status bar wrote:
>
> HI,
> I Open a Excel File with 'Excel.Application', then print Active WorkBooks.
> this ExcelApplication show a dialog Mesage with 'pRING THE FIRST PAGE TOTAL
> PAGES 2 ..........' .THIS IS A USEFULL MESSAGE,BUT In my programe. i don't
> need.
> please help me how to close this message.


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printer Status or Queue Status ZitoMD Microsoft VB .NET 0 19th Jun 2008 05:55 AM
refill Dell-Printer and how to reset the printer-status Georg Walk Printers 0 25th Jul 2006 02:26 PM
get printer status and change path of printer Jurgen Oerlemans Microsoft Dot NET 0 14th Feb 2006 08:32 AM
Printer Status Status Commands Stephane Belzile Printers 0 28th Jan 2005 03:56 PM
Outlook Reminder - When you close it, what is its status? josh b. Microsoft Outlook Calendar 1 17th Mar 2004 01:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.