Vba Maximize Application Window

Microsoft is rolling out a preview of the multi-tabbed Windows Terminal v. Excel VBA Basics. LocationURL. WindowState = wdWindowStateMaximize. it’s realy usefull for me. ' Get the window's title. This can be avoided however, by naming your variables "prnt" or "print1". Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Back in July 2008, I published an example post which showed how to use Visual Basic for Applications (VBA) to remember a window’s size and position. Active VBA Maximize Access Application Main Window. 06 - How to Minimize Maximize and Restore An External Windows Application. How to programmatically maximize, minimize and center the form One of the frequently asked questions about Windows Forms 2. The proven pillars of success in logistics and supply chain. This is what I have done: ' Select the Access application window AppActivate ("Microsoft Access") '. This example maximizes the application window in Microsoft Excel. The code works in the fact that it opens up the external database, but it is not maximizing the external database window. If you are new to UserForms you may be overwhelmed by the amount of information about them. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate. 222 Excel Shortcuts for Windows and Mac. Description. From basic macro recording functionality to dedicated development teams building complex applications using windows forms, ActiveX objects and API calls, you really can build almost anything (whether you should is another. In figure 1. – mtness Aug 30 '17 at 11:46 ^^ This. I put the VBA code in the OnLoad event and I also tried putting it in the Click Event of a command button. And when reopening it f*cks up excel by removing the application minimize,. See the posts VBA - Screen Size and Position Example and Why can't I maximize my window? Also see Support Debugging Tool examples in links below. Open the Search Window. Hope this helps anyone interested and thanks again for your help John. How can I launch a minimized application in Windows PowerShell instead of opening the window in the foreground? Use the –WindowStyle parameter with the Start-Process cmdlet, and select Minimized, for example:. Close Excel and open the saved file from above. What I want it to do is also maximize the browser. For example: Option. They enable you to perform all sort of actions ranging from reading PDF, Excel or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user events. Dialogs(xlDialogZoom. Visual Studio creates a default form for you when you create a Windows Forms Application. ActiveWindow. The Controls collection is used to access the controls that are placed on the form. You can set the window state with one of these lines of code: [crayon-5d5b257b51ee6961246035/] And of course, once you can program a visual element you can throw in a loop and create an “animated effect”. Robert Hall wants a keyboard shortcut for maximizing a window. Learn more. >'Already tried a few solutions, but they works only when the IE is created by the command >'Set ie = CreateObject("InternetExplorer. I want this to run in the background, or at least be minimized in the windows taskbar. Test the code: Open Excel, resize the application to smaller than full screen and save it. However, pop-up forms aren't maximized. There are essentially two problems to this: How can we identify the window that we want to bring to the foreground?. Rankings visual basic 2015 in 24 hours downloads In just 24 sessions of one hour or less, you’ll learn how to build complete, reliable, and modern Windows applications with Microsoft® Visual Basic® 2015. Windows and views include Class View [hides hidden members and types], Command window, Dynamic Help window, Immediate window, Object Browser that displays public members, namespaces and inherited members, Output window, Properties window, Solution Explorer. You can easily connect these to your applications written in Visual Basic 5 and 6 to provide context-sensitive help when the user presses F1. This will help you to write Optimized VBA Code to fasten your code and build better VBA Macro Applications. Note: In Excel for Windows 2002-2010 you must have checked this setting: Trust access to Visual Basic Project (object model) This is only for the macro above and not for the first example that change the size at runtime. This is in contrast to single document interface (SDI) applications, which can - Selection from Programming Visual Basic. We index many online communities and look for a pattern of problems. I have a number of reports that this application will use. This time, you can actually use the quotes or not. Search Shortcut start in powershell. " "The definition of the fullscreen=yes specification is changed to mean 'show the window as maximized,' which will keep the title bar, address bar, and status bar visible. HelpScribble creates standard WinHelp HLP files and HTML Help CHM files. RunCommand acCmdAppMaximize Application. NET source code solutions. When we find a pattern we will ask one of our experts in that expertise to write a Troubleshooting guide for the problem. SendMessage app_hWnd, WM_SYSCOMMAND, SC_MAXIMIZE, 0 BringWindowToTop app_hWnd ' Stop searching. You can minimize, maximize, resize, hide, and rearrange them, and […]. There will be times when it is appropriate for your application to minimize the AutoCAD window, perhaps while your code is performing work in another application such as Microsoft ® Excel ®. In other versions of Windows the process for starting the Command Prompt is similar. VBA Portals. vbs) Basic tutorial on how to use the AppActivate Command to activate a specific window. This is the Official Windows 7 Home Premium ISO Download with service pack 1 (SP1) from MSDN with the Windows 7 product key. Now here's a useful trick! Ever had to make an application window smaller just to drag something to your Windows desktop? No more! In Windows 7, you can drag files directly to the Show Desktop button in the Windows taskbar. MZ-Tools is an add-in for Visual Basic 6. To access it, click on the Windows button and type cmd (Windows 10). The ability to control the Application window allows developers the flexibility to create effective and intelligent applications. For example, both eliminating the "Close"-button or creating a more opaque background on a window require the use of the Windows API. This will help you to write Optimized VBA Code to fasten your code and build better VBA Macro Applications. To maximize, minimize, or "restore" a window, set its WindowState property to wdWindowStateMaximize, wdWindowStateMinimize, or wdWindowStateNormal, respectively : Documents « Word « VBA / Excel / Access / Word. Start and keep maximized automatically specified applications or windows. Application. VBA can trigger the display of the Zoom window. and then if you double-tap the down-arrow, it means it will only restore back to a floating-window. Learn vocabulary, terms, and more with flashcards, games, and other study tools. EnableEvents to tell VBA processor whether to fire events or not. autocad 2015 vba module 64-bit Autodesk BIM 360 Glue AutoCAD 2015 Add-in 64 bit;vba enabler for autocad 2012 64-bit AutoCAD is an extremely versatile product thanks to the various AutoCAD versions. The AppActivate method activates an application window. In the Properties dialog box, select the Shortcut tab. from QTP script. The mother of all objects is Excel itself. How can I activate the internet explorer window which is already open through VBA macro. Summary: Learn how to specify the launch state of an application through Windows PowerShell. Developers from all over the world come together to share knowledge, source code, and tutorials for free to help their fellow programmers - Professional Developers, Hobbyists and Students alike. Neither of these commands are in the Macro Editor, so am asking for help please. Close Excel and open the saved file from above. NET language. When ever we open the main form it opens in a window. As you become proficient with Excel VBA, you spend lots of time working in Code windows. arranges the open workbooks in a. From basic macro recording functionality to dedicated development teams building complex applications using windows forms, ActiveX objects and API calls, you really can build almost anything (whether you should is another. Solver is a powerful analysis tool, bundled with Excel and used for optimization and simulation of business and engineering models. This post, VBA - Screen Size and Position Example used the Purchase Order Entry window for the example. I am running Excel 2003 (11. Width = Application. Excel VBA Tutorials and Examples Tutorials, Guides and Blog Posts. See the posts VBA - Screen Size and Position Example and Why can't I maximize my window? Also see Support Debugging Tool examples in links below. Step 3: Insert a code module from then insert menu. The ReportViewer employs the power of the Report Server to achieve the display of a report. Neither is working for me? I put the VBA code in the OnLoad event and I also tried putting it in the Click Event of a command button. Modules & VBA :: Maximize And Minimize Forms Feb 27, 2014 I have a Form [frmLogon] which opens on db open to allow users to logon, once they have entered their username and password they click a cmdbutton which then minimises [frmLogon] and opens form [Navigation Menu]. Press Search. VBA Function to Hide the MS Access Window Below is a set of three functions that work in conjunction, and is where all the magic takes place in the act of hiding and restoring the MS Access window. APIs call, or execute, Window's functions. Maximize current workbook window. VBA Portals. Now, there are two things you can do to maximize the window. Always Open Your Email in a Maximized Window. Close the Visual Basic Editor (File-Close) Save your file and close it. But I am not sure how to do that. This is the Official Windows 7 Home Premium ISO Download with service pack 1 (SP1) from MSDN with the Windows 7 product key. Every window you see in a running visual basic application is a form, thus the terms form and window describe the same entity. Click Minimize all Windows. You can also use the WindowState property to minimize, maximize, and check the current state of the Application window. This code was written for Word 97 and worked fine for Word 2000. Programming with Microsoft Visual Basic 2008, Fourth Edition by the best-selling author, Diane Zak, is designed for a first course in programming. WindowState = xlNormal. Another workaround coming to mind would be to wrap the IE object in a WScript. DoSomethingOnly2003Does Else ' Do something else for older versions End if. 1, including app code examples created using any of the universal app templates available in Visual Studio. If you want to do 3D. But when user press a button or some thing like that, window should resize (maximize) to. VBA Excel Windows API - V1. Search Shortcut start in powershell. Close Excel and open the saved file from above. If you want to know how to activate a file or folder that was previously opened, check out my article on AppActivate and more. VBScripting (. If you are using Winforms, then the chances are you can't do it with any real success - you can in WPF because it is very different. This tutorial also goes over how to restore, maximize, minimize, and close a window. Method in the article can help you. ActiveWindow. After running any of these on Win XP it can be seen on the toolbar that InDesign is active, however the Window doesn't show up causing all the problems. Minimize, maximize or hide the application whose caption you just entered. ' Maximize other Access window and quit current application. More than 650 students signed up and are now learning VBA each day. The Shell command returns the Process ID, PID, so you can kill the file when you're done. Usage 1: App(application). Restore the VBE windows to their default positions using VBA in Microsoft Excel If you have trouble with the docking of the different VBE windows, you can restore their positions by editing a setting in the Registry. MaximizeCommandWindow(h) displays the window for the server attached to handle h, and makes it the currently active window on the desktop. Learn vocabulary, terms, and more with flashcards, games, and other study tools. Maximizing, Restoring, and Minimizing Windows. Double click the “Minimized” button and do the following codes to minimize the form when the button is clicked. The followings are the detailed steps and VBA codes. Is an ASP solution the right answer for you?. The application window is set to fill the user's screen so that its maximum size can be determined. Excel VBA - How to maximize a minimized workbook - the workbook name is dynamic Showing 1-6 of 6 messages. Right click on the Windows Taskbar and choose from Cascade windows, Show windows side by side, or Show windows stacked. View Chris Stout, MBA, M. wow, it’s free cool, TQ for your information. Prev Essential VBA Training for Excel. I have a process in one folder that is trying to load the Crystal Report located in another folder. It has a FullScreen onebut that might not be what you want. config of your. Note: In Excel for Windows 2002-2010 you must have checked this setting: Trust access to Visual Basic Project (object model) This is only for the macro above and not for the first example that change the size at runtime. Sure, they could Alt-Tab or click on the Windows task bar to bring it into focus, but anything you can do to make things easier and more obvious for users is usually a good thing. Visual Studio will automatically create it for you when you start a new WPF application, including a Code-behind file called App. 0 ide free download for pc″. config file because in. This same function can also be used to completely hide Access window and just show your form on the desktop. Therefore, if you're just beginning to work with macros and Visual Basic for Applications, you probably don't need to display the Immediate Window. Visual Studio creates a default form for you when you create a Windows Forms Application. · You can use winapi functions to activate application windows. If you click on the icon in the upper left of an application (at the beginning of the title bar), a little menu opens, which is called the System menu: The keyboard method of opening this menu is Alt+Spacebar. We will also use the FormWindowState to Maximize and Minimize the form. Using the functions. WindowState = xlMaximizedit doesn't maximize the window and therefore i can't see the 'print preview'. How can I do this without downloadi. Due to the amount of fields on the form this causes some of the information to not be displayed until the window is maximised. Application #End If On. A WPF window is a combination of a XAML (. My solution is divided up into folders so that I can keep my files organized. Use the trick below to disable and turn off Aero Snap ability to auto arrange or auto maximize window when dragging. The ability to control the Application window allows developers the flexibility to create effective and intelligent applications. The more keyboard shortcuts I know the better. Who We AreH-Wave is leading the way in drug-free rehabilitation and pain relief for those injured at work or at play. Developers from all over the world come together to share knowledge, source code, and tutorials for free to help their fellow programmers - Professional Developers, Hobbyists and Students alike. Hope this helps anyone interested and thanks again for your help John. Sub DisableExcelMenu() ' Remove Exel Menu Items Dim hMenu As Long hMenu = GetSystemMenu(Application. The attach the code that has been used, and includes a Maximize line of code, which I thought was working, but is not. VBA-Excel: Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel. This variable is passed along to the processing routine so it knows which workbook to work with. 3 console application with a long list of improvements and bug fixes, including the ability to drag title bar, custom. I want to be able to minimize the Explorer and my Excel worksheet so when the userform is displayed user do not see the Explorer nor the worksheet and when the process is done and closing the userform I want to worksheet to be maximized as well as the Windows Explorer. If you are new to UserForms you may be overwhelmed by the amount of information about them. Not sure why it won't maximize to the application window on one display, but it will in the other. from QTP script. Download pascal ide for free. Hire the best freelance Microsoft Windows Server Specialists in Michigan on Upwork™, the world's top freelancing website. Often in VBA we need to ask the users to select files or directories before we execute the actual functionality of our macro. Although Outlook doesn’t have such a direct feature, fortunately you can use VBA codes to realize it. – mtness Aug 30 '17 at 11:46 ^^ This. I need my access application window to open up in full screen. Type "excel. If necessary, open the designer window. See the complete profile on LinkedIn and discover Chris. by SJ · January 24, 2014 To Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel , follow the steps mentioned below. The ultimate guide 15 tips to increase performance on Windows 10 If your PC is running slow, use these tips to help speed up. ActiveWindow. Is there any code I can place in the Load event of the opening Splash form which disables|hides the Close button but leaves the Min & Max buttons visible on the MS Access application window?. Faced with such a troublesome and repetitive operation, you must long for a method which can permit you to always open email in maximized window. Now Internet Explorer will open in the maximized state when you click on any short cut to iexplore. EnableEvents to tell VBA processor whether to fire events or not. There will be times when it is appropriate for your application to minimize the AutoCAD window, perhaps while your code is performing work in another application such as Excel. Usually the VBA Userform doesn't have this feature, but through API functions we can enable the maximize button in the userform. 8405) SP3 with Visual Basic 6. A frequently asked question is “How do I hide the red X close button on the corner of a VBA user form?” My answer is that you shouldn’t hide the red button, since the user knows what it does, or at least what it’s supposed to do. However, a window that is "Always On Top" could still cover up a window you Activated. Excel VBA - How to maximize a minimized workbook - the workbook name is dynamic Showing 1-6 of 6 messages. I used to run a utility to automatically open all my IE windows (or any other application I configured it to work with) maximized. My solution is divided up into folders so that I can keep my files organized. Sub DisableExcelMenu() ' Remove Exel Menu Items Dim hMenu As Long hMenu = GetSystemMenu(Application. I mainly use the effect when I open smaller windows, in order to allow the user to see one piece of code while reading over text in the larger, parent window. Net programmers have made extensive use of forms to build user interfaces. Right-click the shortcut and select Properties. ActiveWindow. Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. Programming with Microsoft Visual Basic 2008, Fourth Edition by the best-selling author, Diane Zak, is designed for a first course in programming. #If VBA7 And Win64 Then 'For 64 bit Excel. (windows 7). Application Static o As Outlook. WindowState = xlMaximizedit doesn't maximize the window and therefore i can't see the 'print preview'. vbs files that will (when triggered with a keyboard short-cut) will make the active window maximized, minimized, or restored. The For Loop in VBA is one of the most frequently used loops in VBA. This variable is passed along to the processing routine so it knows which workbook to work with. Re: Calling a macro upon minimizing/maximizing There are no minimize/maximize events for a workbook. You can also use the SetValue macro action to set a form's Visible property to hide or show the form's window. Projects can either be deployed over the Web, CD or in person. Creating Application Step 1. a system optimization and game management tool designed to maximize your system resources for the demands of gameplay. The shape of the window should. This is Part 1 of an introductory series on game programming using the Microsoft. A Boolean value that toggles Internet Explorer between the normal window and a full-screen window in which the title bar, menu bar, toolbar, and status bar are hidden. Next, you'll want to dig further into the Advanced Power Plan settings, and make sure that the On battery settings are set to maximize battery life—change the plan to turn off the hard disk. Or, you can make the entire document go full-screen and remove the header toolbars completely. It is also possible to add Visual Basic for Applications (VBA) code to windows to allow them to store their location and size. When users open the DB, I only want them to use the form (and not see the DB window or the main application window). WindowState = xlMaximized This example expands the active window to the maximum size available (assuming that the window isn't already maximized). Activates and displays a window. The projects are coded in Microsoft Microsoft Access or Visual Studio using VB and VBA. Rankings visual basic 2015 in 24 hours downloads In just 24 sessions of one hour or less, you’ll learn how to build complete, reliable, and modern Windows applications with Microsoft® Visual Basic® 2015. Tip Of course you can still double click on the Title Bar , or click on the Maximize/Restore Down button , to maximize or restore down a window. window([n]) where App instance someApp was created before. DoCmd Maximize: Enlarge the active window so that it fills the Microsoft Access window. Help, in modifying VBA to maximize my active window using button. Dialogs(xlDialogZoom. By Gopinath Taget AutoCAD application can be maximized or minimized through automation by utilizing the 'WindowState' property of the Application object as shown in the following sample code: 'To minimize the application Application. The ability to control the Application window allows developers the flexibility to create effective and intelligent applications. WindowState = xlMaximized This example expands the active window to the maximum size available (assuming that the window isn't already maximized). A WPF window is a combination of a XAML (. We may earn a commission for purchases using our links. This example maximizes the application window in Microsoft Excel. Re: Calling a macro upon minimizing/maximizing There are no minimize/maximize events for a workbook. · You can use winapi functions to activate application windows. But sometimes it's necessary to access them from your Excel Application (or Word or any other MS Office Application). Application. Step 3: Insert a code module from then insert menu. Back in July 2008, I published an example post which showed how to use Visual Basic for Applications (VBA) to remember a window’s size and position. Visual Basic Script Developer (Black Knight MSP) jobs at ResourceXperts in Dallas, TX 08-23-2019 - Our client, a national mortgage company, licensed to do business in all 50 states, is growing its loan servicing portfolio, creating new. AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. How To Always Run Excel In Full Screen Mode Using VBA. 1 application will be found very quickly. We index many online communities and look for a pattern of problems. Rankings visual basic 2013 download torrent Sep 07, 2015 · Visual Studio 2013 Ultimate ISO Free Download full trial version 32/64-bit for Windows 10, Windows 7, Windows 8, 8. Find a target window and minimize, maximize, or restore it in C# Posted on December 23, 2016 by Rod Stephens This is the first in a series of posts that allow one application to manipulate a target window in another application. Active VBA Maximize Access Application Main Window. The industry standard in supply chain management—fully revised and updated to provide today’s logistics solutions. However, the excel window is frozen when the macro is running, I could not select some shortcut on my desktop on the part where the excel window is on top of it. F2: Opens the Object Browser. Returns or sets the position of the left edge of the window. #If VBA7 And Win64 Then 'For 64 bit Excel. VBA Maximize Access Application Main Window. Re: Application argument to open Inventor in maximized window? Unfortunately Andrew I spoke too soon. I want the screen to switch between two different applications every, say, 30 seconds. NET developers joined together with a common goal: to learn, teach, and have fun programming. To run the MaximizeWindow macro action in a Visual Basic for Applications module, use. Help, in modifying VBA to maximize my active window using button. Unfortunately running another program like this doesn't give you much control. vba to minimize the window I am using Powerpoint in Office 2013 on Windows 7 and Windows 10. Create a new message and resize and position it accordingly. There's no way to do this with one keystroke. Application Private Sub App_WindowDeactivate(ByVal Doc As Document, ByVal Wn As Window) If Doc. This same function can also be used to completely hide Access window and just show your form on the desktop. Clicking this icon opens the Control Menu. 5: Universal Resource Scheduler, is an easy to use visual three dimensional scheduler. MDI Applications Multiple document interface (MDI) applications permit more than one document to be open at a time. VBA Excel Windows API - V1. This post, VBA - Screen Size and Position Example used the Purchase Order Entry window for the example. In this Windows 8 tutorial, you will learn how to show and hide desktop application icons. Change the ' value of C_MAIN_WINDOW_CLASS to the application's main window ' class (e. For those of you who have been wanting to know the list of keyboard shortcuts in Windows 10, here it is. The problem i have is that i can't find a method to open the form fully maximized. HelpScribble creates standard WinHelp HLP files and HTML Help CHM files. It leverages the U-PointTM technology for localized adjustments, and adds a full set of editing functionalities for amazing pictures: your pictures. Net, open your Visual Studio and follow this step: File -> New Project -> Windows Forms Applications. EnableEvents to tell VBA processor whether to fire events or not. Hi, I am running a macro which process about 500 excel files from a folder, the code is running fine. Finally we are done with QT designer. You've just taught your computer to open every new file in a separate window, a separate instance of Excel. Essentials for Windows Administrators on AWS. Essentially what the VBA code is doing is looking for a window on your screen and identifying it by its caption (the words displayed at the very top of the window, usually within the dark shaded bar that houses your minimize/maximize/close buttons). 9 KB) Conclusion. The Visual Basic settings allows you to maximize your productivity using Visual Basic. by SJ · January 24, 2014 To Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel , follow the steps mentioned below. Find subject specific tutorials like Sending emails through. The VBA UserForm is a very useful tool. It's simple to post your job and we'll quickly match you with the top Microsoft Windows Server Specialists in Michigan for your Microsoft Windows Server project. After the program is compiled you must use a shortcut to use command line arguments: Create a shortcut for the compiled Visual Basic program. The application window cannot be maximized and does not appear if I click on the taskbar application button. Net Applications reserves the right to publish anonymous, aggregate summary information regarding our website visitors. How To Minimize All Applications To System Tray In Windows 10? Portable and ridiculously lightweight (just about 40 KB), RBTray is an incredible little utility that can be used to minimize just about any open program or application window to the system tray, instead of the taskbar. Furthermore, it has a Height and Width property you could use to just size the window as large as you want. API: Manipulate Access Window. Application Static o As Outlook. In this example we'll use screen capture VBA to copy the active window to the clipboard and then paste it into a Word document. The distinction between the Workbook and Window objects lies in an additional method that can be used to create a Window object: 17. Now while we say that these things don't work, they really do work. It allows to observe a desktop or an application under test wholly. You can also use the WindowState property to minimize, maximize, and check the current state of the Application window. Is there a way through VBA we could easily create a minimize and maximize button on a userform in Excel VBA? I need these buttons on a form in my application and thought if someone could help me with this ? I have watched other websites for this, but seems a little bit complicated as there appears no simple way in Excel VBA to do this. The WindowState property (xlMaximized is a constant defined by VBA) of the Application object is used to maximize the Excel window (fill the user's screen). Solid models of the I/O terminal block kit (terminal block and cable) SBK-U-VBA-xx for use with MECHATROLINK and Option style SGDV & SGD7S servopacks. This demo includes: A minimize system button A maximize system button A restore button Resizing the userform with arrow keys. Disable the Microsoft Access Close Button to Prevent Users from Accidentally Closing Your Application Provided by: Luke Chung, President of FMS, Inc. As well as being able to model complex financial instruments, what really sets Excel apart is the automation ability of VBA. 40 Free and Useful Windows Applications. It changes the focus to the named application. The ability to control the Application window allows developers the flexibility to create effective and intelligent applications. It has a FullScreen onebut that might not be what you want. Returns or sets the position of the left edge of the window. Rather, it usually refers to a fixed-size area of memory used by Excel or Windows (for example, the area used for graphics or custom formats). Microsoft Access / VBA Forums on Bytes. DoCmd Maximize: The maximize command changes the size of the active Access form to the maximum dimensions allowed by the active Access application. UsableHeight. If you are using Winforms, then the chances are you can't do it with any real success - you can in WPF because it is very different. Find subject specific tutorials like Sending emails through. Start studying Visual Basic Chapter 2. This can be especially annoying when you want to see all of the data in an app like Access or Excel. AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. I am developing a Windows Form application using Visual Studio 2010 and framework 4. Add a new workbook and save it: 20. Using the most recent version of the software, Visual Basic 2008, this book teaches individuals how to. As long as it is not the exact word, it. But you can do it with two. Has anyone a solution Thnx in advance Peter. Click Apply. Since can't use VBA for WEB Database, am having to learn use of Macros instead. Thanks, and feel free to contact me, Anton. Position and size the Application window This example uses the Location and Size properties to position the AutoCAD Application window in the upper-left corner of the screen and size it to 400 pixels wide by 400 pixels high. ActiveWindow. It’s useful and reduces our effort in making different workbook with same data. The problem i have is that i can't find a method to open the form fully maximized. Another workaround coming to mind would be to wrap the IE object in a WScript. Selecting the entire screen lets you do a Windows-like "maximize" to have the frontmost window take up all available space on the screen.