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 shows a dashboard with button that utilizes a Stored Procedure to update the data 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.

Last Updated: November 22, 2011 Top of Page

JavaScript


Examples of useful JavaScript can be found here: JavaScript Examples.doc

The scripts documented in file available per above link are used on my web sites. Some are used on this web site, but most are used on Excel Users Group.

All meeting dates on home and Meetings pages are based upon variables which are calculated and updated automatically at the stroke of midnight on the first day of each month. Meeting dates are set to calculate the third Thursday of each month.

There is link to send me an e-mail in footer of each web page. Due to bots scraping e-mail addresses from HTML code and adding them to spam lists, I use JavaScript to concatenate variables to generate the e-mail with the appropriate e-mail address.

Last Updated: March 6, 2021 Top of Page

Miscellaneous VBA

PowerPoint VBA


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

Thanks to Shyam Pillai, MVP for permission to use and display his code.

Top of Page


Word VBA


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

Top of Page



Last Updated: July 17, 2012 Top of Page

VBScript


Examples of useful VBScripts can be found here: VBScript Examples.doc

File includes code (and sample script files) to do the following:
  • Kill, Terminate and Application or Process
  • Get count of folders and files for given path(s)
  • Map a network drive
  • Unmap a network drive

Last Updated: March 6, 2021 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!

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 (YYYYMM) 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.

Last Updated: October 18, 2011 Top of Page