Recursive Creativity LLC

RECURSIVE CREATIVITY LLC

MISCELLANEOUS

Content listed below are items that do not fit in other menu categories.


Dynamics GP (formerly Great Plains Dynamics)

Accounts Receivable Dashboard

The screenshot is shows a dashboard that utilizes a Stored Procedure to update at the click of a button. The receivables can be sorted in any manner and the "aging" buckets can be customized. For example, the first two aging buckets could be combined to create "00 to 30 Days" bucket, the last bucket could be change to "91 to 120 Days" and a bucket could be added for "over 120 Days".


Trial Balance

The screenshots below are various views of the Trial Balance sorted using the toggle button.

These files will be posted at a later date as will some snapshots of Financial Statements.


Top of Page

Miscellaneous VBA


PowerPoint code is for refreshing linked Excel objects and breaking the links after saving "dated" files. Code automatically adds last Friday's date to file name...it can be changed to any week day or modified to use msdate. Using msdate will date stamp "dated" files with today's date. Thanks to Shyam Pillai, MVP for permission to use and display his code.

Word code is for refreshing linked Excel objects and breaking the links after saving "dated" files. Code automatically adds last Friday's date to file name...it can be changed to any week day or modified to use msdate. Using msdate will date stamp "dated" files with today's date.


The code for the above is found in examples files posted at:


Top of Page

JavaScript


Examples of useful JavaScripts can be found here: JavaScriptExamples.doc

Top of Page

Visual Basic

While Visual Basic 6 was still around I developed one program which automated the WinZip Command Line Tool. Links are provided to a screen shot of the program and the executable file.

Much of the functionality of this program is built into an Excel file I also developed and WinZip blessed.

WinZip thought so much of my ideas they incorporated them into their product...and won several awards for it!

In short, this program automated WinZipping your My Documents (Windows XP) and allowed user to specify individual paths for WinZipping. Versioning was also supported. Versioning added the YearMonth to end of the file name created during the WinZip process.



Screen Shot


Windows XP Windows Vista I have not tested on Windows 7 but the Windows Vista file should work with Windows 7.

Top of Page