Loop Fill for each Catchment in a Directory

This macro will change the fill colour of each catchment within a single directory. You will be prompted to select a catchment. Each catchment in that directory will have the fill style altered in a loop fashion cycling through the 15 main basic colours (skipping white and black). The catchments must be selected from a subdirectory, not the root directory.

Subset Point set by Catchment macro

This macro will create subsetted point sets of a point set for each catchment within a single directory. You will be prompted to select a catchment and point set. The subsetted point sets will be put in a subdirectory of the chosen one named the same as the catchment directory.

Create new Projects from Template Project

This macro will make several copies of a template Project.
Each project will be based on a different catchment from a single directory. A point set will be subsetted for each catchment.
It prompts for the template project, catchment directory and a point set to subset by catchment. The projects created are put in a subdirectory named "Instances of ProjectName " and the subset point sets are put in the subdirectory named "Instances of PointSetName"

Create segmented Projects from Template Project
with set value ranges

This macro will make several copies of a template segmented Project.
Each project will be based on a different catchment from a single directory. A point set will be subsetted for each catchment.
Your product will be shown segmented on the map with the Ranges set automatically. Text will be reloaded for the new area.
The macro prompts for the project, catchment directory and a point set to subset by catchment. The projects created are put in a subdirectory named "Instances of ProjectName" and the subset point sets are put in the subdirectory named "Instances of PointSetName"

Create radius Catchments from Point set (Miles)
Create radius Catchments from Point set (Km)

These macros will use the current point set. They will prompt for a radius in miles or kilometres, depending on the option set in Prospex. For every location in the point set they will add sectors within the given radius from that point, creating a catchment. The names of catchments created will be derived from the first field in the point set.

Create metafiles of Catchment maps from Template Project

You need to create a directory called "metafiles" on your C:\ drive This macro will prompt for a template project and a catchment in a directory. For each catchment in that directory, a map will be drawn and then saved as a metafile in the C:\metafiles directory. You will be prompted whether you want to continue after each one. - You can either say "yes", "quit" or choose "all"

Create metafiles of Projects in Directory

You need to create a directory called "metafiles" on your C:\ drive This macro will prompt for the first project in a directory. For each project in that directory, a map will be drawn and then saved as a metafile in the C:\metafiles directory. You will be prompted whether you want to continue after each one. - You can either say "yes", "quit" or choose "all"

Print and move Projects

This macro will print all the projects in the selected directory. A printed project will be moved into a subdirectory called Printed.

Print Projects

This macro prints each project in the given directory.

Replace Catchment in Projects with selected Catchment

This macro will replace the current catchment for each project in a directory with the selected catchment. You will be prompted to select a project and a catchment.

Export Point sets into Excel

This macro exports Point Sets from your chosen directory and then prompt for names and paths for the Excel output. Either rename the Excel file each time to create a new Excel document, or press return to create new worksheets in the existing document.

Export Catchments into Access database

This macro will export the catchments in the current catchment directory to an Access database. If there is no current catchment you will be prompted for one and its directory will be used.You will also be prompted for the name of the database(full path) and the table name you want the catchments to be in

Delete Catchment Directory and sub Directories

This macro deletes a Catchment directory and all its sub directories and the contents of these directories.

Delete Project Directory and sub Directories

This macro deletes a Project directory and all its sub directories and the contents of these directories.