/Visual-Basic-for-Applications-scripts

A group of small tools and quality of life programs that run within the Bluezone Mainframe system or with visual basic applications within Excel.

Primary LanguageVBA

Excel-and-VBA-Tools

A group of small tools and quality of life programs that run within the Bluezone Mainframe or with Visual Basic for Applications within Excel.

AccuracyReportGenerator An excel module that allows the user to generate a report from several different screens in Bluezones Mainframe.

ClearAlarmsinPaperless.js A script that automates the clearing of alarms in paperless, ran in Bluezone Mainframe.

CrewReg Macro An excel macro that takes roster information from several locations and creates a spreadsheet with rostered information for the given day.

PrintCardsMenu.bbs A small dialog box that runs within Denver on Bluezone Mainframe. It gives the user an easy to use interface to allow the printing of work cards.

RF28Automation.bas An excel module that allows several rows of data to be automatically inputted into areas of the screen for bluezones mainframe.

RosterEmailingSystem An excel module that pulls information from several worksheets located in different folders to generate a mailing list. The mailing list can then send several hundred emails to a range of email address or to individual selected ones.

RosterImporter A localised script version of the recruitment roster entry, that gives the user options via Dialog box. The script is ideally ran from a shortcut on the users toolbar.

ScreenGrab.bbs A script that allows the user to input how many screens they wish to save to the clipboard. It ten stitches together several screens into one large string.

vVolumeReportGenerator.bas An excel module that allows the user to generate a report from several different screens in Bluezones Mainframe.

ComparisonReport An excel module that allows the user to generate a report from several different screens in Bluezones Mainframe.

ColationReport An excel module that allows the user to generate a report from several different screens in Bluezones Mainframe.

pickRateReport An excel module that allows the user to generate a report from several different screens in Bluezones Mainframe.

recuitmentRosterEntry An excel macro that allows multiple rosters to be keyed to the bluezone mainframe system automatically.