VBA Functions
Home Up Past Meetings Notes Tips Directory Links of Interest Site Map FAQs

[ VBA Functions ] VBA Subroutines ] VBA Code by Topic ] Visual Studio Tools for Office Links ] Key Reference Document Links ] PowerPoint ]
 

VBA User Functions from

bulletwwGetMD5Hash2  -  Returns a 16 character MD5 hash from a 1 required range and 3 optional ranges of cells.    Empty cells are not ignored.
bulletsmrNextNthWeekday  Solves the Question: Give me the date of the next 2nd Tuesday after April 10th, 2001.
bulletsmrNext3rdFriday   Special case of smrNextNthWeekday.   This one returns the next 3rd Friday after a given date.    Good for calculating the next Options Expiration Date.
bulletsmrIsVisible01:    This function will return a 0 if the row of the     Upper Left Cell of varRef is hidden.  'Other wise it returns a 1

VBA User Functions from Public Domain Sources

bulletwwUserID  -  for Excel 2002+
bulletGetWorkstationInfo and wwUserID   for getting UserID from early versions of Excel
bulletudsStringToHex(string)  - Converts any string into a string of Hexadecimal characters.

VBA Object Notes and Help

bulletFileSystemObject

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:09 .