Posts

Excel VBA Get DATA RANGE ONLY of HEADER

' ''Pivot Header Field Data Range Function PHFDR ( TableID As Variant ) As Variant () ''returns all headers from the table point to table or call by name Dim objPivot As PivotTable Dim x On Error GoTo SetErr Select Case LCase ( TypeName ( TableID ))               ''Takes pivot(any cell) or name Case "range" Set objPivot = TableID.PivotItem.Parent ''check if table name exists Case "string" Set objPivot = Application.Caller.Worksheet.PivotTables ( TableID ) End Select ''Data range of column header PHFDR = objPivot.ColumnRange.PivotField.DataRange     ''set header.data range Exit Function SetErr : PHFDR = CVErr ( xlErrNA ) ''failed to find/set pivot table End Function

Open catalogs, manage them then re-Export Revit Catalogs from Excel

Attribute VB_Name = "REVIT_EXPORT_CATALOG" ''2023 Ron E. Allen - Share with WM under general use license ''Required reference "Microsoft scripting runtime" for FSO and text streams Option Explicit Const VBQT = """" ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Function CheckFilepath ( ByRef filepath ) ''subs out sharepoint filepath for 'local' If LCase ( filepath ) Like "http*sharepoint*" Then ''Sharepoint hack to try to rewrite to local drive path... If filepath Like "http*/Documents/*" Then ''we can take a guess to...

Revit API and Dynamo Zero Touch

Coding in Visual studio or other platforms these are the references to include to access the DLLs for Revit and Dynamo for Revit.  (2023-05-25). If The IDE reports inaccessible be sure to check the .net versions. Switching the version of .net framework to 4.8 from 4.7 for later versions should resolve the error. I did this by adding conditions to my debug configurations for the later Revit versions in the .csproj file. Solutions then built with no errors. Can provide  further info on how to do this if needs be should it turn out to fix someone else's issue also.  Revit API Dynamo (zero touch): Version specific: C:\Program Files\Dynamo\Dynamo Revit\1.3\Revit_2019\RevitNodes.dll C:\Program Files\Dynamo\Dynamo Revit\1.3\Revit_2018\RevitNodes.dll C:\Program Files\Dynamo\Dynamo Revit\1.3\Revit_2017\RevitNodes.dll Newer: C:\Program Files\Autodesk\Revit 2021\AddIns\DynamoForRevit\Revit\RevitNodes.dll C:\Program Files\Autodesk\Revit 2022\AddIns\DynamoForRevit\Revit\RevitNodes.dl...

Environment | Revit | Autodesk App Store

Environment | Revit | Autodesk App Store updated for Revit 2024! https://archintelligence.com/category/news/ Revit 2024 release and the supporting Environment 11.0 features So what exactly is the Toposolid? If you know Revit well enough, imagine a Floor and a Toposurface fell in love and had a baby- this would be the Toposolid! We are basically talking about a solid element with Types and parameters where you can add structure layers- very similar to a Floor but with additional Topography capabilities such as contour lines and contour labels. Here are 10 things you need to know about the new Toposolid: Read more

(1) Revit plans to Power BI using Dynamo! (Part 1 of 2) - YouTube

(1) Revit plans to Power BI using Dynamo! (Part 1 of 2) - YouTube REvit > SVG to Power BI

Solved: Select all content on level - Autodesk Community - Revit Products

Solved: Select all content on level - Autodesk Community - Revit Products ##https://forums.autodesk.com/t5/revit-api-forum/select-all-content-on-level/td-p/10577273 """ Selects all elements that share the same Reference Level as the selected element. TESTED REVIT API: 2020.2.4 Author: Robert Perry Lackowski """ from Autodesk . Revit . DB import ElementLevelFilter , FilteredElementCollector from Autodesk . Revit . DB import Document , BuiltInParameter , BuiltInCategory , ElementFilter , ElementCategoryFilter , LogicalOrFilter , ElementIsElementTypeFilter , ElementId from Autodesk . Revit . Exceptions import OperationCanceledException # from pyrevit import DB doc = __revit__ . ActiveUIDocument . Document uidoc = __revit__ . ActiveUIDocument from rpw import ui import sys #Ask user to pick an object which has the desired reference level def pick_object (): from Autodesk . Revit . UI . Selection import ObjectTy...