项目作者: EddieBranigan

项目描述 :
A group of small tools and quality of life programs that run within the Bluezone Mainframe system or with visual basic applications within Excel.
高级语言: VBA
项目地址: git://github.com/EddieBranigan/Visual-Basic-for-Applications-scripts.git


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.