Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100360

From BetaArchive Wiki


APP.SIZE() Returns Error When Document Window Is Maximized

Last reviewed: June 30, 1997
Article ID: Q100360

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a

SUMMARY

The APP.SIZE() function may return a #VALUE! error if the Microsoft Excel window is maximized.

In the Microsoft Windows operating system, a window cannot be resized that is already maximized or minimized. To use APP.SIZE() correctly, you must first restore the window. In an Excel macro, to restore a window, use the APP.RESTORE() function.

The following sample macro illustrates the use of the APP.RESTORE() and APP.SIZE() functions to size the Windows Control Panel application window:

   A1:=EXEC("control.exe")
   A2:=APP.ACTIVATE("Control Panel")
   A3:=APP.RESTORE()
   A4:=APP.SIZE(200,200)
   A5:=RETURN()

REFERENCES

"Function Reference", version 4.0, pages 21-22 "Function Reference", version 3.0, pages 12-13


Additional reference words: 3.00 4.00 4.00a resize change

Keywords : kbmacro kbprg
Version : 3.00 4.00 4.00a
Platform : WINDOWS


Last reviewed: June 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.