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 MoreI'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 MoreAfter 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 MoreAfter 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 MoreI'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 MoreI 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 MoreI 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 MoreIn 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