Christopher Kibble's Technical Ramblings
  • Import Teams Meeting Into Camtasia

    2021-10-13 camtasia msoffice

    I've had an issue loading meeting recordins from Microsoft Teams into Camtasia recently. The video imports perfectly, but the audio cuts out after about a minute. After a lot of message board posting and troubleshooting of my own, the consensus seems to be that it's something about the bitrate that the audio is saved …

    Read More
  • 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
  • Visio cannot open the file or a component in the file because it is corrupt (Visio 2016)

    2018-09-20 MSOffice Visio

    After upgrading a number of systems to Visio 2016, I started to hear more and more about old pre-2010 Visio files in VSD format that would no longer open and would throw the following error: The strange thing was that the files were still launching without issue for users who were still on Visio 2010 and 2013. The …

    Read More
  • Remove All Objects from an Excel Sheet

    2018-07-30 MSOffice

    After pasting some content into Excel 365 (2016), I found that I had brought along thousands of little objects from the source data. These were tiny invisible objects, but they'd constantly get in the way of me clicking into a cell, because I'd inadvertently click on one of the objects instead. While I should have just …

    Read More
  • Convert Office 365 Version Numbers to Build Numbers for SCCM Reporting

    2018-07-24 SQL MSOffice PowerShell

    I've written the following three PowerShell functions to build a mapping of Office 365 ProPlus version numbers (e.g. 16.0.10205.2009) to more reportable build numbers (e.g. 1806). I've created the following three functions to start: Get-Office365BuildToVersionMap Get-OfficeBuildListToCase …

    Read More
  • Adding Individual Office 365 Product to Existing Installation

    2018-05-23 MSOffice

    I was having a discussion last week about how if you want to add a new product to an existing Office 365 ProPlus installation (such as adding Microsoft Access after already laying down Word, Excel, and PowerPoint), you need to supply an XML with the apps you want to exclude (no longer including Access) but you don't …

    Read More
  • Modify Access Application Options in PoSH

    2017-06-21 PowerShell MSOffice

    I put together the following script to help a small group configure Microsoft Access during login in a kiosk environment. You're welcome to steal and modify as you see fit. For all the options you can possibly set, see this MSDN page (ignore the comment that it's for Visual Basic...) 1<# …

    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
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Finding or Recovering your WSL Data
  • Lenovo Vantage IMController Vulnerability - ConfigMgr Query
  • Lenovo Thunderbolt Firmware Version Detection
  • Import Teams Meeting Into Camtasia

Categories

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

Series

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

Tags

CONFIGMGR 20 POWERSHELL 17 MSOFFICE 12 CA 9 PKI 9 SQL 9 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA9 CAMTASIA1 CHROME3 CITRIX1 CONFIGMGR20 DOMAINS2 EDGE1 EXCEL7 FIRMWARE2 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 LENOVO2 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE12 NAS1 NESSUS1 NINITE1 NOTEPAD++1 PKI9 POWERPOINT1 POWERSHELL17 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 WIZTREE1 WSL1 YNAB2
[A~Z][0~9]