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