Christopher Kibble's Technical Ramblings
  • Excel COM Error Cant Load Library Fix

    2021-02-08 Excel PowerShell MSOFFICE

    I've been getting the following error when trying to access a new Excel COM object: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the …

    Read More
  • Video: How to use VLOOKUP in Microsoft Excel

    2016-03-09 MSOffice Excel

    In this video demo I'm going to show you how use VLOOKUP on a table in Excel. In order to see the text clearly, please set the video to one of the two HD options using the gear icon. Attachment: Using the VLOOKUP Function

    Read More
  • Video: Text Manipulation in Microsoft Excel

    2015-10-19 MSOffice Excel

    In this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …

    Read More
  • Creating an SCCM Collection from an List of Computers in Excel

    2015-06-03 ConfigMgr Excel

    I frequently use this trick to manage collections of computers in SCCM where the original list comes from Excel, or from a query of another system that I can dump into Excel. Doing it this way, you don't have to rely on adding computers one at a time to a collection query or dumping systems into tools like the the …

    Read More
  • Updated PingCell Function for Excel

    2009-08-24 VBA Excel

    This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping …

    Read More
  • Creating an SMS 2003 CCR within Excel

    2009-07-07 ConfigMGr Excel

    This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me …

    Read More
  • Generating a List of Values in Excel (VBA)

    2009-05-09 Excel VBA

    I frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists. 1Public Function …

    Read More

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Excel COM Error Cant Load Library Fix
  • Running Powerpoint in Windowed Mode
  • Managing Chrome in the Enterprise
  • Setup Google Cloud Certificate Authority - Part 2

Categories

CONFIGURATION-MANAGER 19 PKI 9 POWERSHELL 9 SYSTEMS-ADMINISTRATION 9 TROUBLESHOOTING 9 CONFERENCES 5 APPLICATION-PACKAGING 4 MSOFFICE 3 ACTIVE-DIRECTORY 2 DOMAINS-AND-HOSTING 2
All Categories
ACTIVE-DIRECTORY2 APPLICATION-PACKAGING4 CONFERENCES5 CONFIGURATION-MANAGER19 DOMAINS-AND-HOSTING2 EXCEL1 GEEKING-OUT1 GOOGLE1 GOOGLE-CHROME1 IPHONE1 JAVA1 MCAFEE-ENDPOINT-ENCRYPTION2 MICROSOFT-DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI9 POWERPOINT1 POWERSHELL9 SYSTEMS-ADMINISTRATION9 TROUBLESHOOTING9 WINDOWS-101 YNAB2
[A~Z][0~9]

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 8 VIDEOS 5 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2 SPEAKING-ENGAGEMENTS 1

Tags

CONFIGMGR 19 POWERSHELL 16 MSOFFICE 11 SQL 9 CA 8 PKI 8 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA8 CHROME3 CITRIX1 CONFIGMGR19 DOMAINS2 EDGE1 EXCEL7 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE11 NAS1 NINITE1 NOTEPAD++1 PKI8 POWERPOINT1 POWERSHELL16 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 YNAB2
[A~Z][0~9]