Microsoft

Visual Basic for Applications (VBA) projects are integral to Microsoft Office automation. From automating repetitive tasks in Excel to creating powerful macros for Word or Excel, VBA can significantly enhance productivity. However, protecting and securing your VBA projects is essential to safeguard your intellectual property, maintain data integrity, and prevent unauthorized access. This blog will […]

As a Databricks Champion working for Perficient’s Data Solutions team, I spend most of my time installing and managing Databricks on Azure and AWS. The decision on which cloud provider to use is typically outside my scope since the organization has already made it. However, there are occasions when the client uses both hyperscalers or […]

The Optimizely Configured Commerce SDK and Optimizely Configured Commerce Cloud serve different but complementary purposes within the Optimizely ecosystem. Below is a breakdown of their differences to help clarify their roles: Optimizely Configured Commerce SDK (Software Development Kit) The SDK is a toolkit developers use to build, extend, and customize Optimizely Configured Commerce solutions. Key […]

So, DeepSeek just dropped their latest AI models, and while it’s exciting, there are some cautions to consider. Because of the US export controls around advanced hardware, DeepSeek has been operating under a set of unique constraints that have forced them to get creative in their approach. This creativity seems to have yielded real progress […]

Automation is essential for increasing productivity and simplifying work. Downloading files is one of these tasks, particularly when handling a lot of file downloads. The lack of native file download functionality in PowerApps makes it difficult to download files. In this blog post, we’ll go over how to use Power Automate to automate file downloads […]

Introduction: In this Part, we’ll show the process of integrating the child flow created in Part 1 into a Parent flow – the critical flow that you will be tracked for its history. “If you missed Part 1, be sure to check it out for a complete guide on creating child flow in Power Automate.” […]

Introduction: In today’s digital landscape, organizations increasingly rely on automated workflows to enhance efficiency and streamline processes. However, as these workflows grow in complexity, tracking their execution history becomes essential for ensuring reliability and facilitating troubleshooting. This blog explores a powerful approach to logging workflow running history using child flows in Power Automate. By leveraging […]

Microsoft Outlook is a powerful tool for organizing emails, calendars, contacts, and tasks. While it offers an array of built-in features, its full potential is unlocked when you customize it to suit your needs. One of the most effective ways to achieve this is through Visual Basic for Applications (VBA).  VBA allows you to automate […]

Implementing Optimizely a Configured Commerce platform is a significant milestone for any business looking to scale its digital operations. A well-structured timeline ensures a seamless transition from planning to execution, ultimately delivering a robust eCommerce solution tailored to your needs. The implementation involves four key phases: Prepare, Build and Verify, Go Live, and Post-Go Live. Let’s examine each phase […]

Debugging and Error Handling in VBA After setting up VBA in Excel, you can start automating tasks and creating your macros. This blog will guide you through what comes next after the setup process—writing, running, and debugging VBA code in Excel. Debugging and error handling are crucial for writing effective and reliable VBA (Visual Basic […]

Objective Automate the deployment of Azure Kubernetes Service (AKS) using Terraform Cloud Workspaces. This ensures Infrastructure as Code (IaC) is centrally managed, and all changes are traceable. 1. Set Up a Terraform Cloud Workspace Free Account Step 1: Create a Terraform Cloud Account Navigate to https://developer.hashicorp.com/sign-up. Sign up or log in with a valid email […]

In Visual Basic for Applications (VBA), variables, data types, and constants are fundamental building blocks that allow you to create dynamic and efficient macros. Let’s explore these concepts in detail. Variables in VBA A variable is a named storage location in your computer’s memory that contains data. Variables make your code more flexible by allowing […]