Programming Examples

Subtotals before page breaks
This workbook shows how you can insert subtotals at the bottom of each page in a worksheet before you print it.
Click here to download this example.
Updated: 2006-05-18 Requires: XL5 File size: 19 kB

Create a list over all available drives
This example shows how you can use Microsoft Scripting Runtime to display information about all available drives (letter, type, free space e.t.c.). Microsoft Scripting Runtime is included in one of the following products: Windows98, Windows2000, IE5, og Office2000.
Click here to download this example.
Updated: 2001-07-28 Requires: XL97 File size: 31 kB

Sorting examples
You can compare the different sorting methods against each other to determine which is the most suitable for your project. The workbook contains the source code for 6 different sorting methods and 1 randomizing method.
Click here to download this example.
Updated: 2000-11-06 Requires: XL97 File size: 49 kB

Log file example
This workbook contains example macros that update log files every time the workbook is opened and closed.
Click here to download this example.
Updated: 2000-11-02 Requires: XL97 File size: 19 kB

Application class module example
This workbook contains a class module "template" for an event-enabled application class.
Useful if you want to attach macros to an Application-object event.
Click here to download this example.
Updated: 2000-11-02 Requires: XL97 File size: 11 kB

Prevent the user from stopping a running macro
This workbook shows how you can prevent the user from stopping a running macro by pressing the ESC-key or Ctrl+Break. The example can also be used to end a running macro in i tidy way when the user wants it to end.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 10 kB

OLE automation example
Contains three examples with source code that shows how to use Excel from Word, Outlook from Excel and Word from Excel.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 37 kB

An OnTime example macro
This workbook shows how to create a macro that runs at a given time interval, e.g. each second. The example updates a cell and the statusbar with the current date and time. The code is easy to adapt to your own projects.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 9 kB

Use the statusbar
Show the progress of your macros on the statusbar in a little bit more "graphic" way.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 4 kB

Create your own custom undo macro
This workbook shows how you can create your own custom undo macro that will allow your users to undo your macro actions by selecting the menu Edit Undo...
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 12 kB

Document last updated 2006-05-18 12:48:35 Printerfriendly version

User comments:

Ole P. from Norway wrote (2006-11-04 03:26:42 CET):

Re: Please Help...
Sorry, can't help you with this.
Search Google for "VBAProject password" to find a suitable commercial solution that can help you.

Edwin Montero from Venezuela wrote (2006-11-04 03:10:42 CET):

Please Help ERLANDSEN
Hi.
ERLANDSEN I have a very big problem. how can I found the password in the VBAProject. I forgot it, and I have sixty-one Excel files with the same password, as can you see it´s a big upset.
I know you can help me.
Thanks a lot
Edwin

Antonio from Adelaide, Australia wrote (2006-10-13 16:21:58 CET):

Have I been sleeping all this time....
bloody fantastic work, it has opened my eyes to the possibilities...again I say grazie!

V.D. Rama Rao from India, New Delhi wrote (2006-04-07 18:16:33 CET):

Marvelous !!
Excellent contribution for MS-Excel lovers. Great work and keep it up and keep going. Very well. Thanks a lot !!!

George from India wrote (2006-03-27 04:34:03 CET):

Wonderful!
Great site! keep up the good work

K-rule from Malaysia wrote (2005-12-05 17:32:01 CET):

Good page !!!!!!!!
Finally, i found the page that can help me to create system in excel. Thank you.

Jean paul from Poperinge - Belgium wrote (2005-11-30 18:36:50 CET):

EXCELLENT !!!!!!!!!!!!!!
You've helped me a lot of time. This website is very
good. Thanks a lot for all the usefull information

Ali from Paris, France wrote (2005-08-03 16:08:16 CET):

Thanks a lot
I want to thank you very much for your website which is excellent.
All the code and the downloads are very helpfull.
Your examples are very smart and very well design.
Another time, thank you.

Iceman from Conselheiro Lafaiete, Brasil wrote (2005-05-03 04:00:56 CET):

Congratulations.
Excellent!This page is very good!Thank you so much!

Ben Morton from Houston, Texas wrote (2005-04-28 14:29:07 CET):

SUPERB!
Excellent, practical, directly examples of HOW TO in this broad and ever elusive world of VB. Your examples have helped me tremendously! I'd like to talk to you about some work. email ben@asphotos.com.