MessageBox From OLE Server Comes Up Behind The App

You have a VB4-based OLE Automation server that has no main UI, anddisplays forms that are parented into Excel in response to various automationcalls. Sometimes you need to display a message box instead of a form. Ifyou haven’t yet parented any forms into Excel, the message box frequentlyappears behind Excel.To make sure that the message box appears where the user can see it–ifall your forms are modal–the best way is to compile the VB4 OLE Automationserver as an in-process server (DLL). The server becomes part of Excel’sprocess space, and all forms and message boxes are automatically parentedas you would expect them to be.If your forms are modeless, you cannot use the DLL approach. Your OLEAutomation server must be an EXE. The following workaround should do thetrick.Create a hidden, modeless form and use SetParent to make it a childof Excel’s main window. Make this the first thing you do when Excel getsan instance of your object. Create a Public (visible throughout your project,but not outside) method for the hidden modeless form. The Public methodtakes the same parameters as a message box, and its job is to call MsgBoxwith those parameters. When your server needs to display a message boxwhen no other form is parented to Excel, call this method. Excel shouldnever hide the message box.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS