MS Teams - Open Files in Desktop Apps

Its really annoying to have to open a file in Teams and the click again on Open in Desktop App

Below is a workaround that works very well.

• When you are in teams right click the 3 dots next to General and click "open in sharepoint"
• When in Sharepoint online click on the gear next to your picture or initials (in the top right of the screen)
• Click on Library settings
• Select Advanced Settings in General Settings
• In "Opening Documents in the Browser" Change to Open in the client application
• Go back to the documents in Sharepoint online and copy and paste the entire web address
• Go Back to Teams
• Right Click Documents Library and select Remove
• Select the plus and select website
• Name it whatever you like
• Paste the document library web address you just copied
• Select Save
• It will now open the desktop app as default

Reference

https://techcommunity.microsoft.com/t5/microsoft-teams-ama/open-in-desktop-apps/m-p/300035

MS Teams chat and meetings now support popout windows

https://office365itpros.com/2020/04/10/teams-pop-out-windows-chats-meetings/

How To Automatically Run Excel VBA Macros Daily April 29, 2019 Chris Newman

It is a great shame that PowerApps can run excel macros yet....

Here is a work around

utilize the Windows Task Scheduler application (don’t worry, this comes installed with most Windows PCs) to automatically open an Excel file, run it’s VBA code, save the file, and finally close the Excel file. With this solution, you will be able to customize the frequency and exact time(s) this automation will need to be executed. The ONLY CATCH to this solution, is that the PC will need to be on during the scheduled time.

https://www.thespreadsheetguru.com/blog/how-to-automatically-run-excel-vba-macros-daily

How to Customize Your Background in Microsoft Teams Video Calls

Link https://lifehacker.com/how-to-customize-your-background-in-microsoft-teams-vid-1842838567

Find a spoken word or phrase in Microsoft Stream videos

Using MS Stream you can search transcript text in one video, or across multiple videos.  See this page for more info

Additionally if you type time codes into the description then you can create your own table of contents which can be clicked on to go directly to that section

Eg 02:26 end of intro

03:45 Joe's presentation...

Ths works alongside "Generate automatic captions and a transcript for your Microsoft Stream videos".  (Note Teams admins can turn off this automation if they are worried by GDPR and the like).  The setting for this policy is ....

VTT video transcript files

Microsoft Stream can automatically generates a WebVTT (text) file from what was spoken in a video and uses it for a video's transcript and closed captions.

You can download this file as the owner of the video. 

As well as the transcript text, a VTT file contains time codes, metadata and confidence levels, which makes getting the text transcript out into word or other editor painful

Fortunately Microsoft have a VTT cleaner here.  You can upload your VTV and it removes the data just keeping what was said in text

Another online tool is here 

Hyper-V Gen2 SCSI boot issues with legacy IDE converted machines

I was converting a Windows 2012R2 server from a VMDK to a VHDX, creating a new Hyper-V Gen2 host and struggling to get it to boot.  I could mount the drive, read from it from a safe CMD prompt, tried to make sure the correct partition was active using DISKPART, even used BOOTBCD to try but with no luck.

I eventually found that the issue was because I was creating Gen2 Hyper-V machines rather than the Legacy Gen1.   Whilst Gen2 will support Win2012R2 they do not support the booting of IDE drives connected as a virtual SCSI controllers can only be recognized after installing Hyper-V Integration Services on the guest OS on the VM. If this is not the case then the guest OS cannot boot from a SCSI disk.

Running up a Gen1 machine and connecting the drive to the IDE booted first time...!

References: 

The Differences Between Hyper-V Generation 1 vs. 2 VMs

https://docs.microsoft.com/en-us/windows-server/virtualization/hyper-v/plan/should-i-create-a-generation-1-or-2-virtual-machine-in-hyper-v#windows-guest-operating-system-support