#VBA
Browse all articles tagged with #VBA. Find expert insights and practical tutorials from our PI System community.
Enhancing PI ProcessBook Trends with Banding and Zones: User Needs, Workarounds, and the Road Ahead
A look at the user demand for trend banding/zoning in OSIsoft PI ProcessBook, current VBA workarounds, UI challenges, and how future PI Vision releases aim to address these visualization needs.
Roshan Soni
Searching for Usernames Across Multiple PI Servers: Methods, Challenges, and the Road Ahead
Managing user accounts across several PI Servers is often a challenge. In this post, we review current community-driven solutions for searching usernames across multiple PI Data Archive servers and discuss future enhancements to PI System management capabilities.
Roshan Soni
Designing a Custom Playback Function in PI ProcessBook: Dynamic Trace Redrawing Explained
Explore how to create a custom animated playback feature in PI ProcessBook for dynamically redrawing traces within a fixed time window. Learn about PI Calculation Datasets, VBA scripting, challenges, and alternative approaches.
Roshan Soni
Navigating Between Displays in PI ActiveView: Challenges and Workarounds
Implementing navigation and context-passing between displays in PI ActiveView can be tricky. This post discusses the technical challenges and reviews workarounds for building usable dashboard navigation, including the limitations of VBA, file-based session logs, and alternatives like .NET add-ins and URL parameters.
Roshan Soni
Running Excel Macros in Embedded Objects within PI ProcessBook: Strategies to Minimize Flicker and Maximize Performance
Learn best practices for triggering Excel macros within embedded OLE objects in PI ProcessBook, including code samples and strategies for smooth integration without screen flicker.
Roshan Soni
Dynamically Detecting and Resolving New Aliases in PI ProcessBook Displays
Learn how to use PI SDK Event Pipes and ContextHandlers to automatically detect and resolve new aliases or tags added in PI ProcessBook module contexts, ensuring real-time updates without polling.
Roshan Soni
Programmatically Recalculating and Resizing PI DataLink Arrays in Excel
Learn how to programmatically recalculate and resize PI DataLink arrays in Excel using volatile functions, VBA, and the dlresize method for dynamic data reporting.
Roshan Soni
Autoscaling Trends with Limits in OSIsoft PI ProcessBook
A practical guide to autoscaling trend axes in PI ProcessBook with defined limits, combining filter-based PI data queries and VBA scripting to keep your trends readable when outliers occur.
Roshan Soni
Reading PI Points Values with PI Web API and VBA
Learn how to efficiently access PI System data using PI Web API with VBA by understanding common troubleshooting techniques for connection issues.
Roshan Soni
About #VBA
Explore our collection of articles tagged with #VBA. Our expert contributors share their knowledge and experience to help you succeed with PI System implementations.
From configuration tips to advanced development techniques, these articles provide practical guidance for PI System professionals at all levels.