RevitTricks

  @ echo off @ echo 2021-06-02v01.00 :: Hard-coded revit ini file to the 'builder' locaton for the Revit ini (cached locaiton) :: This script should move the esisting one to a dated RECORD\yyyy-mm-dd folder and copy the :: NNEW Revit ini file in it place. set RevitINI = "\\ktgyir-a-cad\BIM\_Deployments\Autodesk\REVIT\2020\Revit-KTGY.ini" @ echo - Checks If file/folder exists for 2020 Ktgy-Revit.ini if that doesn't exist exit :::Visual file check will show 0 files if doesn't exist: :::dir "%revitINI%" :::pause ::If the Revit ini file doesn't exist - exit out - good if source cannot be found if not exist %RevitINI% goto :ExitNoFile @ echo . @ echo FOUND: %RevitINI% @ echo Proceeding... @ echo . ::Working Revit INI Backup folder - Tpical of revit (Version # varies) ::Make the record folder for the Revit.ini cached version- set RecordFP = c:\ProgramData\Autodesk\RVT 2020\UserDataCache\RECORD if not exist " %RecordFP% " mkdir ...

For custom User-profile extensions and locations for deployments: Turns %userprofile% into the expanded path for the local user profile (C:\users...)      Option Explicit ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''This program looks at the Revit INI and 'escapes' ''or replaces the %USERPROFILE% with the actual path under the executed profile ''Run-as the user to make the replacement in the path. ''Adapt this script to modify poritons of the INI using RegExp ''''''''''''''''''''''''''...

https://nonica.io/   (Free) NonicaTab: 12 Dynamo scripts as Revit buttons. Integrate scripts into Nonica toolbar in two clicks. Commands are up to you! http://prorubim.com/en/tools/dyno/ (Russian product - paid ?) - Organizing, deploying and running Dynamo workspaces tool for Autodesk Revit,  ·          email: office@prorubim.com   https://github.com/MarkAckerley/Csharp/blob/master/Dynamo_Launch_From_Ribbon     (Free) GIT  hub API  Csharp/Dynamo_Launch_From_Ribbon   https://forums.autodesk.com/t5/revit-api-forum/dynamo-script-in-revit-api/m-p/9087859/highlight/true#M41896  -  (Free) API -    Dynamo script in Revit API   ·          https://www.orkestra.online/?PageSpeed=noscript (PAID) Create, deploy & scale Dynamo scripts like never before  

This function sets the CURRENT cell value to an RGB based on the target cell- Uses REGEX 5.5 [ ✓ ]Microsoft VBScript Regular Expressions 5.5 Function SetCellColor ( X As Range ) As String Dim re As New RegExp Dim MC As MatchCollection Dim SM As SubMatches Dim RGB As String Dim AC As Range ''What cell is calling: ''https://www.mrexcel.com/board/threads/function-determining-what-cell-it-is-being-called-from.51343/ Set AC = X.Parent.Cells ( Excel.Application.Caller.Row , Excel.Application.Caller.Column ) re.Pattern = ( "(\d{3}).?(\d{3}).?(\d{3})" ) If re.Test ( X.Value ) Then Set MC = re.Execute ( X.Value ) Set SM = MC.Item ( 0 ). SubMatches RGB = SM ( 0 ) & ", " & SM ( 1 ) & ", " & SM ( 2 ) RGB = "SetRGB(" & AC.Address ( False , False ) & ", " & RGB ...