Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

Excel

Excel VBA Procedures to Break All External References in Workbook

Excel VBA functions to break all external references and delete defined names containing external workbook references.

Categories Productivity Tags Excel, VBA Leave a comment

Function to Check If Workbook is Already Open Using Excel VBA

Excel VBA utility function to test if a workbook is already open.

Categories Productivity Tags Excel, VBA Leave a comment

Function to Check If File Exists Using Excel VBA

Excel VBA utility function to test if a file exists.

Categories Productivity Tags Excel, VBA Leave a comment

Refresh Data and Pivot Tables in Excel Using VBA

How to programmatically refresh external data lists and pivot tables in Excel using a VBA macro.

Categories Productivity Tags Excel, VBA Leave a comment

Calculate Quarter Number In Excel

How to calculate the quarter number for a given date in Excel.

Categories Productivity Tags Excel Leave a comment
Newer posts
← Previous Page1 Page2 Page3

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Create Self-Signed S/MIME Certificates
  • How to Use Unicode Characters in Power BI
  • Display Total Inside Power BI Donut Chart
  • Mapping Continents and Countries in Power BI

Latest Posts

  • Creating a Power BI What-If Scenario Analysis
  • Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
  • Manually Create a WordPress Database from the MySQL Client
  • Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack
  • Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.