Posts

Search operators you can use with Gmail - Gmail Help

Search operators you can use with Gmail - Gmail Help

Find files in Google Drive - Computer - Google Drive Help

Find files in Google Drive - Computer - Google Drive Help

File naming cleanup excel - includes RegisterFunction help in excel

Excel function registration for variable by variable at Stack Overflow https://stackoverflow.com/questions/14731675/is-there-a-way-to-make-udf-that-gives-a-description-like-the-native-excel-functi/21917614#21917614 Attribute VB_Name = "RevitFileNames" Attribute VB_Name = "RevitFileNames" Public Function CleanStr ( strIN As String , Optional ReplaceChar As String = "-" , Optional SpacesToDashes As Boolean = True ) As String Attribute CleanStr.VB_Description = "Remove characters that could interfere with file naming" Attribute CleanStr.VB_ProcData.VB_Invoke_Func = " \n9" Dim I ''generic counter Dim replaceStr As String ''for building replacement string Dim x As String ''character Dim Pass As Boolean ''Pass/fail for character For I = 1 To Len ( strIN ) x = "" : x = ...

Long filenames - Windows CMD - SS64.com

Long filenames - Windows CMD - SS64.com dir "\\?\UNC\Server64\Teams\Personnel\some - very - long - file - name.txt" ...turns off automatic expansion of the path string, the  "\\?\"  prefix also allows the use of ".." and "." in the path names, which can be useful if you are attempting to perform operations on a file with these otherwise reserved relative path specifiers as part of the fully qualified path. This syntax can be used in both CMD and PowerShell.

Outlook Record Of Conversation (Select meeting in calendar and run)

Image
This allows you to select a meeting in Outlook, run the macro and create a pre-formatted Record Of Conversation (ROC:[SUBJECT]) message with keys for identifying Projects, Then you can start filling in content as the meeting progresses for a quick start and a consistent format. The HTML sections in the back hard code in the header information for the body text to start. Attribute VB_Name = "Outlook_ROC" Option Explicit Private Const PR_SENT_REPRESENTING_ENTRYID As String = " http://schemas.microsoft.com/mapi/proptag/0x00410102 " ''stripped character index tables '''''''''''''''''''0'''''''''1'''''''''2'''''''''3' '''''''''''''''''''0123456789x123456789x123...