Bluepoint Design

Practical Cost-Effective Solutions
Macro Express: Sample Subroutines

Home
Up
Text to Serial Time
Text to Serial Time VBS
Multiple Multiple Choice
Case Conversion - Title
CRLF & TAB Macro
Date String From File Date
Delete to Recycle
Email Settings Check
File Name Increment Macro
At first I created simple self contained macros but soon realized that I was creating the same routines in different macros so now I am breaking some of that out and creating generic subroutines. I immediately thought of my fellow ME users and that they might benefit from some of these routines so I decided to start posting them here. If you have any questions feel free to contact me or if you would like some written for you.

A problem with subroutines is that they usually require variables and one can not anticipate their future use and therefore can't anticipate if they will step on other macro variables. In order to avoid this dilemma I use the variable save and restore commands. Of course this would also wipe out the subroutines results so I use the registry to pass the results back (feedback) to the parent macro as well as passing it to the macro. This will be apparent in some of the macros as you look at them

On the subject of subroutines there is great resource out there by Professional Grade Macros. Their PGM Functions Library™ is in a sense a collection of macros that can be used as subroutines and they cover a wide swath of common functions.

 
Practical Cost-Effective Solutions