Results for "Author: john galanopoulos"

This is the source that i've been looking for, when i was trying to create an add-in that installed a new menu option with submenus in the shortcut menu of a workbook. (Look at the screenshot). The whole project is designed to be as simple as possible and it is an Excel Add-in. It is very helpfull for those of you that try to develop professional Add-ins. Any comments or suggestions are always welcomed (A special "Thank you" to all of you who voted for me)

In this article, we are going to see how to use WaitForSingleObject, WaitForMultipleObjects, RasConnectionNotification and many other commands with Visual Basic. We are also going to see how to monitor multiple events without the need of multithreading. I have included two examples : how to monitor when a shelled application has ended and how ICQ monitors connection state (that little flower that gets green when we dial-up and establish a connection). If you like it, post a comment. I ll be happy to read your thoughts or suggestions. (****** A Special "Thank you" goes to all of you who spent a few secs to rate this article :)

Kill the active password-protected screensaver of a windows 95/98 pc using Windows API. Please read first the included MustRead.txt! The source is FULLY commented. I would appreciate any thoughts or suggestions :-)

Completely destroy a file with no chance of recovery or trace. Use of CreateFile, FILE_FLAG_NO_BUFFERING (Open the file with no intermediate buffering or caching) FILE_FLAG_WRITE_THROUGH (Write through any intermediate cache and go directly to disk) and also FlushFileBuffers function to ensure that file buffers will be flushed! A must test and see.

This source can dynamically turn a normal form to a read only one and vice versa. Uses API functions. Also you can exclude a control from turning into a read-only one. Suggestions and thoughts always welcomed.

Error trapping in API Functions? Remember Err.LastDLLError? No description was available for you. With this function (LastDLLErrorDescription()) you can get the description of an API error. Includes a tester and is FULLY(!!!) commented. Comments or suggestions r always welcomed. Thanks to all the people who voted :)

Do you want to make your loops 100% faster? Here's how : Many of us have used several times DoEvents, to supply a bit of air to our App, on Heavy-Duty times such as loops for updates or inserts on recordsets etc. As we most know, DoEvents processes Windows messages currently in the message queue. But what if we wanted to execute DoEvents only in times, when we want to allow user (Keyboard and Mouse) input? ( A special "thank you" to all of you who rated this article)

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

In the past days, we have seen an exploit on how to get the text behind the password protected textbox control. This was sure a security breach. Windows XP don't have the same problem with their password protected textbox. They use their control from comctl32.dll and not user32.dll! Our textbox has the same protection. It is subclassed to intercept the WM_GETTEXT and EM_SETPASSWORDCHAR by transforming them into WM_NULL upon receival. Download the source and check it out. Any comments or suggestions are always welcomed :-) Subclassing source was borrowed by Stephen Kent's excellent article on PSC site : http://www.planet-source-code.com/xq/ASP/txtCodeId.30275/lngWId.1/qx/vb/scripts/ShowCode.htm

This is the source that i've been looking for, when i was trying to create an add-in that installed a new menu option with submenus in the shortcut menu of a workbook. (Look at the screenshot). The whole project is designed to be as simple as possible and it is an Excel Add-in. It is very helpfull for those of you that try to develop professional Add-ins. Any comments or suggestions are always welcomed (A special "Thank you" to all of you who voted for me)

In this article, we are going to see how to use WaitForSingleObject, WaitForMultipleObjects, RasConnectionNotification and many other commands with Visual Basic. We are also going to see how to monitor multiple events without the need of multithreading. I have included two examples : how to monitor when a shelled application has ended and how ICQ monitors connection state (that little flower that gets green when we dial-up and establish a connection). If you like it, post a comment. I ll be happy to read your thoughts or suggestions. (****** A Special "Thank you" goes to all of you who spent a few secs to rate this article :)

Kill the active password-protected screensaver of a windows 95/98 pc using Windows API. Please read first the included MustRead.txt! The source is FULLY commented. I would appreciate any thoughts or suggestions :-)

Completely destroy a file with no chance of recovery or trace. Use of CreateFile, FILE_FLAG_NO_BUFFERING (Open the file with no intermediate buffering or caching) FILE_FLAG_WRITE_THROUGH (Write through any intermediate cache and go directly to disk) and also FlushFileBuffers function to ensure that file buffers will be flushed! A must test and see.

This source can dynamically turn a normal form to a read only one and vice versa. Uses API functions. Also you can exclude a control from turning into a read-only one. Suggestions and thoughts always welcomed.

Error trapping in API Functions? Remember Err.LastDLLError? No description was available for you. With this function (LastDLLErrorDescription()) you can get the description of an API error. Includes a tester and is FULLY(!!!) commented. Comments or suggestions r always welcomed. Thanks to all the people who voted :)

Do you want to make your loops 100% faster? Here's how : Many of us have used several times DoEvents, to supply a bit of air to our App, on Heavy-Duty times such as loops for updates or inserts on recordsets etc. As we most know, DoEvents processes Windows messages currently in the message queue. But what if we wanted to execute DoEvents only in times, when we want to allow user (Keyboard and Mouse) input? ( A special "thank you" to all of you who rated this article)

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

In the past days, we have seen an exploit on how to get the text behind the password protected textbox control. This was sure a security breach. Windows XP don't have the same problem with their password protected textbox. They use their control from comctl32.dll and not user32.dll! Our textbox has the same protection. It is subclassed to intercept the WM_GETTEXT and EM_SETPASSWORDCHAR by transforming them into WM_NULL upon receival. Download the source and check it out. Any comments or suggestions are always welcomed :-) Subclassing source was borrowed by Stephen Kent's excellent article on PSC site : http://www.planet-source-code.com/xq/ASP/txtCodeId.30275/lngWId.1/qx/vb/scripts/ShowCode.htm

This is the source that i've been looking for, when i was trying to create an add-in that installed a new menu option with submenus in the shortcut menu of a workbook. (Look at the screenshot). The whole project is designed to be as simple as possible and it is an Excel Add-in. It is very helpfull for those of you that try to develop professional Add-ins. Any comments or suggestions are always welcomed (A special "Thank you" to all of you who voted for me)

In this article, we are going to see how to use WaitForSingleObject, WaitForMultipleObjects, RasConnectionNotification and many other commands with Visual Basic. We are also going to see how to monitor multiple events without the need of multithreading. I have included two examples : how to monitor when a shelled application has ended and how ICQ monitors connection state (that little flower that gets green when we dial-up and establish a connection). If you like it, post a comment. I ll be happy to read your thoughts or suggestions. (****** A Special "Thank you" goes to all of you who spent a few secs to rate this article :)