April 28, 2021

How to delete images from blogger

I had to search for this one for removing images in my blogger blog that may contain personal data.
To delete completely an image from your blog, you need to go to https://get.google.com/albumarchive/
Search for Photos from Blogger -> Your Blog.

April 23, 2021

Opening AutoHotkey Help from any editor

I have this week found out a better way to open the AutoHotkey help based on current selection/ context. (thanks to RaptorX and Joe the-Automator.) This is based on AHK Help Launcher.

April 16, 2021

Opening AutoHotkey Help from Visual Studio Code

I am using Visual Studio Code as code editor for my AutoHotkey development. I was looking for an easy way to open the AHK documentation about a selected command from the editor. Here is my final solution.

April 15, 2021

Google Analytics 4 for Blogger keeping Universal Analytics

I have tried to update my Blogger blog to the new Google Analytics tracking (GA4). But I have noticed that my old tracking with Universal Analytics was discontinued (data won't be fed).
Here is the solution I have come to fix it and keeping using UA and GA4 tracking in parallel.

April 12, 2021

AutoHotkey: Paste and restore clipboard pitfall

I have stumbled about a paste pitfall in AutoHotkey and seen recently in Reddit I am not alone ;-)
I have learned also recently from an AHK Forum post (thanks to rommmcek) how to handle properly such issue.
I share here my learning and Clipboard code library.

April 9, 2021

Quick YouTube Channel Search (AutoHotkey Tutorial)

Today I wanted to quickly search for videos inside a specific YouTube Channel.
The prominent search bar would search in whole YouTube. The search for the channel only is a bit hidden.
I share here how I have implemented a Quick Search functionality in the NWS PowerTool based on AutoHotkey.
This is more a on the fly implementation recording post.

How to create a Public location in your OneDrive

I share in this post how you can open a folder in your OneDrive for access to all your colleagues and easily share files without caring about creating shared links.

Google Sheets Tricks: Copy formula to whole column

I have learned this tricks in Google Sheets:

Drag and drop all the way down of a column can be a bit cumbersome.

To select all the cells below another one, you can use the hotkey Ctrl+Shift+Arrow Down.
Then you can for example copy/ paste on this whole selection.

To copy a formula in the whole row, you can edit the first cell and use an ArrayFormula

Example : 

=ARRAYFORMULA(IF(ISBLANK(E2:E);"";YEAR(E2:E)))

When you do so the cells must be empty else you will get an error that the formula would overwrite the existing value.

April 8, 2021

Teams pitfall: Sharing control with different keyboard layouts

I have encountered recently a very annoying bug (yes, this is definitely not a feature) in Microsoft Teams meetings. I was taking over the control on another PC via Teams to edit a Word document on his PC. While typing in Word the letters rendered did not match to what I was typing. (I guess because my colleague has an other keyboard layout than mine. I have a German keyboard. He has an English one.)

April 7, 2021

Quick Google Site Search in the Browser

I have extended the NWS PowerTool Quick Search feature: you can now in a browser quickly fire a Google search that restricts the results to the current site.

April 6, 2021

Handling of Open calls/webinars (Connections/ Outlook/ Teams)

I share here a best practice how to handle open calls, webinars or any events if you are also using Microsoft Outlook and Microsoft Teams and want to share the event in an open platform like HCL Connections ESN. (without inviting your whole company via Outlook; pull vs. push)

April 1, 2021

AutoHotkey: Microsoft Teams Get active meeting window without user prompt

The previous solution I have shared to identify the current Microsoft Teams meeting window with AutoHotkey would prompt the user to finally validate the window - in case you have meetings in parallel e.g. with one on hold. I share here a way to skip this user prompt / fully automate the meeting window detection.

March 31, 2021

AutoHotkey Tutorial: using FindText to implement shortcuts for Microsoft Teams Meeting Actions (e.g. toggle Full Screen)

I explain in this blog post including screencast, how to implement any shortcut with the AutoHotkey FindText function. Example is for Microsoft Teams and specially a Meeting Action like Toggle Full screen.

March 24, 2021

How to rename All Web Site Data in Google Analytics

I have been playing around with Google Datastudio for reporting my blog and AHK Homepage metrics.
I want to use the same report for both data sources and simply switch the data source in the report.
Unfortunately both data sources are shown as "All Web Site Data" and it is hard to identify.

March 23, 2021

How to copy/ duplicate a google analytics dashboard

I have been looking for this one: How to copy/ duplicate a google analytics dashboard

March 19, 2021

GitHub: How to download a single folder

For setting up the powertools I have been looking for a solution to download a whole folder (including subdirectories) from a GitHub repository. I share here my final solution/ learning.

Blogger: Set up Google Analytics to new dynamic tag (gtag.js)

I got this email by Google Analytics:

I thought my Blogger blog was properly set, but checking at the page source code it wasn't.

March 8, 2021

AutoHotkey: Modal InputBox

I have struggled to set an InputBox in AutoHotkey as modal/ always on top. Unfortunately, there is no built-in option for this. I share here my learning and final solution.

February 17, 2021

LastPass to Bitwarden (Password manager transition)

LastPass will change its free plan (on March 16 2021) so you won't be able to use it both on mobile and PC.
This is the kick for me to switch to another Password Manager. (LastPass also got some critical security issues in the past). I have chosen as alternative Password manager Bitwarden, because it is open source and free and well recommended and meets my basic needs (browser extension+mobile access to vault).

February 8, 2021

AutoHotkey Pitfall: System Tray actions remove window focus

I have again stumbled upon this tricky behavior in AutoHotkey: when clicking on a script tray icon the focus of the active window will be removed.

Quick Create Gist (AutoHotkey script)

Recently I have learned from Joe Glines aka the-Automator this nice way to quickly create a Gist with AutoHotkey. I share here my improved solution/ workflow.

February 5, 2021

Reinventing Organizations (Book recommendation)

I have just finished recently reading Reinventing Organizations by Frederic Laloux
And I highly recommend it.


Next, I will have a look at the Videos Collection

All this is provided for free - Pay What you Feel Like

So don't hesitate to try it! 


Thanks to Harald Schirmer for recommending this within Continental.

After reading it, I have reflected a bit upon the stage of my current company.

At the beginning I had some troubles to understand the term "Teal organization". (I am not an English speaker) but Teal is just a color like blue-green.

AutoHotkey: How to add a Setting for a user-configurable hotkey

In this post I explain how you can offer the option to your user to set a custom hotkey for your AutoHotkey script. This option is configurable via a AHK Icon Tray Settings menu.
I illustrate this on a example, the Mute PowerTool.

February 1, 2021

AutoHotkey: Custom Tray Icon Clicks

Normally AuoHotkey Tray Icon only enables a context menu that you can reach out via right-mouse click on the icon. I explain in this post how you can customize different click actions on the Script tray icon - for example add a left-mouse click action and another for right-mouse click.

AutoHotkey: Embed image in Script / Toggle Tray icon

In AutoHotkey, you can embed an image into a Script. I've been using this for example to be able to switch a script tray icon (see mute on/off) and still provide the script as single file, without any image files dependency.I explain here in this post how to do so.

January 25, 2021

PowerToys - Great Windows 10 Utilities

PowerToys are great Windows Utilities provided by Microsoft and Open Source.
I share here resources and my key take-aways about them.

January 21, 2021

Chrome New version 88

There is a new version 88 available for Chrome. 
I share here my main take-aways about the new version.

CLC Jahresmotto 2021

From the Corporate Learning Community https://colearn.de/clc-jahresmotto-besser-formulieren-wissen-teilen-ist-macht/

Current Motto: Von „Wissen ist Macht“ zu „Wissen teilen ist Macht“
What do you think about it? Alternative formulations?

January 18, 2021

Chrome Customization: Ctlr+Tab to switch to last Tab

I was struggling to switch between two Tabs in Chrome, having opened many.
I share here my final solution.

January 15, 2021

How to add a counter/timer?

We got this question within Continental: How to add a counter in a Connections page?
I share here the solution/ answer to it.

YouTube Channel displaying Subscribed Channels

In my YouTube Channel I had the problem that on the Channel Homepage under the Channels Tab, all my subscribed channels were displayed.
I struggled quite a lot to fix it. I share here how I've changed this.

January 4, 2021

Custom Search Engines triggered by CapsLock modified hotkeys

With AutoHotkey it is pretty easy to add hotkeys to run a special search engine on the current text selection.
Moreover you can remap the else useless CapsLock key for this purpose.
I present here how it can be implemented and is implemented in the NWS PowerTool.

December 11, 2020

Send to Kindle

As explained in a previous post I am used to ordering Kindle ebooks on Amazon.com and send them to my Amazon.de Kindle. In the past, I was doing so by forwarding the order email to my Kindle email with the .mobi file attached.
Now Google Mail does not allow me to send bigger Email attachments. So I had to look for another way.

Blogger: Analytics issue because of mobile views

I've noticed following trouble with Blogger and Google Analytics:
A same page will have different analytics wether it is opened from mobile or not.
I present here a solution to fix this.

December 10, 2020

Microsoft Teams: New Breakout Rooms feature

Microsoft Teams has just released this new Break-out rooms feature. I share here good references and tutorial about it.

December 8, 2020

Video Tools

I list here some video tools recommendations/ resources for creating video content on a Windows PC.

December 7, 2020

Monitor web content

Frequently I want to watch a webpage i.e. be notified when a web page is updated.
Common use cases for example: get a notification when a software is updated (watch the changelog), be notified when a question (I haven't asked myself but I'm interested in its answer) in StackOverflow is updated, dedicatedly watch a page in HCL Connections (out of my overcluttered notifications feed), subscribe to a github commit feed etc.

I present here the best solutions I have found so far for this.

James Clear: sharing, writing, recording, networking

I have listened recently to this podcast with James Clear (Atomic Habits) interviewed by Chase Jarvis (CreativeLive) .
Below are some notes/ transcripts that resonated with myself in respect of GUIDE mindset: networking, why writing, sharing and recording.

Chromy: Chrome Launcher Plugin

In this post I share a Chrome Plugin for a Launcher e.g. Executor (my preferred one) or Launchy.
(It is implemented in AutoHotkey but shared as small executable.)

December 3, 2020

Read faster

I summarize here some techniques/ resources I have learned about Speedreading/ how to read faster.

Mindfulness recommendations

I share in this post some recommendations related to mindfulness.

November 12, 2020

RegEx Greedy Trap

I have stumbled upon a regular expression trap - so called greedy (or ungreedy) trap. In short, in regex the ungreedy operator does not mean the shortest possible match
I explain here the problem description where I have faced it and workaround I came to use.

November 10, 2020

CamGif: Great small free tool to create gifs

I recommend CamGif to create animated images aka Gif files on Windows.
It is free, very light (700kB), portable (it is only one exe file), maintained (last update as of now Nov 2020 was in Oct. 2019), which creates small size output file and provide also edit capabilities.

October 31, 2020

Cursor Highlighter

I've stumbled by chance (watching Kevin Stratvert's great videos) on this great tool provided by Prof. Luc Boisvert that allows you to highlight your mouse cursor. It is really handy when you are presenting or recording screencasts.
I have included it in my PowerTools so you can start, install run from the PowerTools bundler and also
I provide it as a compiled version: that will avoid you to install AutoHotkey (prerequisite you trust me)

October 27, 2020

Global Hotkey Launcher

Most of the PC applicaitons provide hotkeys but they can only be accessed if the program window is activated. (no global hotkey)
Moreover hotkeys are sometimes hard to remember.
I present here an approach using AutoHotkey and a launcher app to easily launch program-specific features even when the program is not activated and using an easy to remember keyword syntax.
I illustrate this approach for Microsoft Teams and Microsoft Outlook.

October 14, 2020

Blogger: share to twitter including post preview with pictures

 I was looking for a way while sharing one of my Blogger blog post to twitter to embed some nice blog preview including images.

I have this solution here: https://www.kimsixbloggersupport.com/2016/04/how-to-add-twitter-cards-to-your.html 

Blogger: Hide Post Footer from Home

While adding the last modified date to my Blogger blog posts footer, this date isn't displayed nicely in the Home / list view.
I have looked for a way to hide the footer from this index view only.
This is the solution I have found.

Blogger: Add Last Updated / Modified Date

I was looking for a way how to display the Last modified date besides the first published date in my Blogger blog.

I have found the solution here: https://www.twistblogg.com/blog/last-updated-date-in-blogger 

October 13, 2020

How to hide Blog description from Blogger Template

It is recommended for SEO to add a Blog description.

But the default blogger Template will then display it below the Home page title.


This clutters a lot the page and it isn't very useful/ a bit annoying. Specially if you already have an About page. I present here how to hide the blog description from you Blogger theme.

AutoHotkey: Gui to list and select a window

For getting the current Teams window, I have looked for a GUI Utility in AutoHotkey to select a window from a list.
I present here my final solution and code for this.

October 8, 2020

Excel Trick: Average/Formula for visible range only TLDR; SUBTOTAL(10x,

Today I have learned this trick in Microsoft Excel:
How to calculate an average for a range but for only the visible cells? (e.g. if you hide some rows or use a filter in a Table.)

Chrome Extension: View source

This is a recurring question I always have to look out: How to view the source code of a Chrome Extension?

I document here the step-by-step answer.

October 6, 2020

Blogger: Embed GitHub file

I have looked for an answer to this question: How to embed a GitHub file in a Blogger blog post?

Jira to Power BI (Recursive approach)

It is not so obvious to get data from Atlassian Jira into Microsoft Power BI. I share here my learnings and solution about it.

October 5, 2020

Using Calibre to send English ebooks to my Kindle

I had to rethink about my Calibre/Kindle setup because Calibre got an update to the 5.x version which now uses Python 3.x instead of previous Python 2.x.
Some Plugins haven't updated yet so I got some DRM errors with the newest version and wondered why.
I am used to purchasing English ebooks from Amazon.com because there are a lot of offers you don't get on Amazon.de and I watch ebooks bargains via sites like bookbub.com or ebookdaily.com.

September 18, 2020

Quick Share a link to Microsoft Teams

Introduction
I have discovered recently by chance this nice feature: https://docs.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/share-to-teams that allows to quickly share a link from the browser into a Microsoft Teams Channel.
I share here my learnings and how to integrate this feature e.g. to a hotkey.

September 16, 2020

Outlook VBA: How to get Appointment Organizer or Email Sender Email

I have struggled to find out this one: How to get an Microsoft Outlook Appointment Organizer in VBA.

I needed this for this nice Outlook to Teams Chat Macro.
I share here my learning and final solution.

How to create a shortcut to/ start an office 365 Standalone Web Application?

Introduction

Most of the office 365 applications can be accessed via the browser. You can browse to them via the waffle = open office.com.
Now for each application if you use Chrome as browser you can also create a shortcut to the web apps a bit less cluttered by the default browser menus and toolbar.

I explain here step-by-step how to do this.

September 10, 2020

Universal Date Picker/Calendar with week numbers/ Quick insert current date

(AutoHotkey is really great!)
With AutoHotkey you can very easily get a date picker + small calendar utility displaying also the week numbers.

(This might avoid you implementing forms in vba.)

September 7, 2020

How to synchronize playlists between services (Spotify, Google Play Music...)?

For running, I was used to using Google Play Music to hear music offline from my phone.
Now Play Music will soon be closed and YouTube Music does not offer offline listening for free.
So I had to look for a way to synchronize my Google Music Playlist to another service like Spotify.
(With Spotify Premium you can download a playlist to your phone and here music offline, without internet connection - even if this account is used by someone else e.g. in your family)

I share here the solution I have found.

How to synchronize MiFit workouts to Strava?

I am using a MiFit Band 4 for activity/ workout tracking (combined with my Android phone).
I was looking for a solution to synchronize activity/workouts to other services like Strava. 
I share here the solution I have found.

August 4, 2020

AutoHotkey: Adaptive ListBox

In AutoHotkey I was looking for displaying in a ListBox Gui several text options with the width of the listbox being adaptive to the length of each options. See illustration below:


I couldn't find a standard solution for this but I have found two resources in the AutoHotkey forums which I have combined to build a library function.

Executor: My preferred App Launcher

I have been using Launchy since years.
Now Launchy is unfortunately not maintained anymore - since 2008 and its follower LaunchyQT lacks some features I was used to.

So I have looked for an alternative and came to use now Executor.
I present here a short overview how I use it.

August 3, 2020

Outlook Google Calendar Sync

It is sometimes pretty useful to be able to view his work calendar within your private mobile phone.
In private I use Google Calendar where I also share my calendar with my close family members.

To synchronize my work calendar to my Google Calendar I use this small utility:
@OGCalSync
Source code is available in GitHub here: https://github.com/phw198/OutlookGoogleCalendarSync/

I set it to synchronize to a separate Calendar 'Work' also to a separate Google account dedicated for Work purpose.

Be aware not to share work critical information with Google. 

Blogger: How to remove date from url

I was annoyed about standard blogger post url with a date in it e.g. https://tdalon.blogspot.com/2020/07/teamsy.html . I wanted a date neutral one so I can redirect documentation with a fixed doc root url (example from internal to external). Instead of previous url https://tdalon.blogspot.com/2020/07/teamsy.html something like this: https://tdalon.blogspot.com/teamsy  This is a solution I have found to fix it.

Blogger: How to add a Table of Contents

I have been looking for a way to insert a table of contents to my blogger blog posts that is built automatically.
This is the solution I have found.


Thanks to MyBloggerTricks (MBT) for sharing this one.
 

Blogger: How to add Excerpts

I was looking for this one for my blogger blog: How to display in the Blog Homepage not the full blog posts but only a preview/excerpt of the posts with a Read more link?

I have found the answer here:
http://blogaholicdesigns.com/tutorials/how-to-add-post-excerpts-on-blogger/

It is very easy (it has changed a bit with blogger update)
Simply add a page break now called insert jump break where you want the excerpt to end.

How to create a shortcut to an app from the Microsoft App Store?

For starting a program from the Microsoft App Store (e.g. MS Whitboard or MS To-Do) from an application launcher like Executor or Launchy I was looking for a way to create a shortcut to such an app.
This isn't trivial as expected. Here is the solution I have found.

July 27, 2020

AutoHotkey: Read a CSV Table

Having exported a list of my Teams into a CSV file (see previous post) I want to be able to read this table.
The CSV file looks like: first row is for the header. Then each following row contains information for each item in the list.
Properties of each item are ordered column-wise.
I want given a value for one property to get the value for another property.
Example: 
TeamName := ReadCsv(CsvFile,"MailNickName",MailNickName,"DisplayName")

July 14, 2020

MS Outlook: Edit Received Emails

In this post I share a quite unknown Microsoft Outlook tip.

I want to be able to edit received emails to better search them later.
I receive a lot of emails with unclear subjects for example. (who doesn't?).
I don't want to have to forward it to me to be able to edit the subject of the email because the sender is then changed to myself and it duplicates the email.

This is quite a common requested feature for an Email application.
(This seems still hard to do in Gmail.)

No need to forward it to yourself for editing it.

You can edit an Email in Outlook by customizing the quick access toolbar:
Choose "More Commands..."

Select "Message Tab" -> Edit Message command as shown below:
Add Edit Message Command to Quick Access Toolbar

Then press the "Add>>" button.
You can move it to the top.
Add Edit Message Command to Quick Access Toolbar - Move to the top

Now when the email is opened in a standalone window, you can edit the message by clicking on this button on the quick access toolbar.
You can then rename the subject or edit its content for example.

Send the message after editing (Ctrl+S).

No need to forward it to yourself for editing it!

Note: you can also do this from the Actions Menu in the Move section of the ribbon as explained here. The location of this menu is quite hard to find/ remember. That's why I prefer creating a shortcut in the Quick Access Toolbar.

July 3, 2020

Bookmarklet: Open Amazon book in Goodreads

Introduction I like before buying a book on Amazon to check the reviews on Goodreads. You can use a bookmarklet to do this in one click.

Goodreads offers one but it doesn't work. https://www.goodreads.com/user/edit?tab=widgets
Here is a working solution.
 

Good solution in Github

See https://gist.github.com/lightningdb/cfee260c3b7af7e65fce

javascript: var asin_elements, asin;asin_elements = document.getElementsByName('ASIN'); if (asin_elements.length == 0) { asin_elements = document.getElementsByName('ASIN.0'); };if (asin_elements.length == 0) { alert('Sorry, this doesn\'t appear to be an Amazon book page.'); }else { asin = asin_elements[0].value; if (asin.match(/\D/) === null) { var x = window.open('http://www.goodreads.com/review/isbn/'+ asin, 'add_review'); } else { var x = window.open('https://www.goodreads.com/search?q='+ asin); } x.focus();}

My solution

My solution used some regexp trick:

javascript: var array = document.URL.match(/amazon\..*?\/.*?\/([^\/\?]*)/); if (array == null) { alert('Sorry, this doesn\'t appear to be an Amazon book page.'); } else { var x = window.open('https://www.goodreads.com/search?q='+ array[1] + '&search_type=books'); x.focus(); }

Installation

Add a bookmark and paste the code in the URL



Chrome Extension: Close Current Tab

Introduction I've faced the challenge in a Chrome extension to close the current tab - and the chrome window if this Tab is the last one.

Standard answer

chrome.tabs.query({"active": true, "lastFocusedWindow": true}, function (tabs) {
chrome.tabs.remove(tabs[0]);
});
The drawback of this solution is that it won't close the Chrome window if it is the last tab to be closed.

My solution (close window if last tab)

/ ----------------------------------------------------------------------------------------------------------
function closeCurrentTab(){
// Close current tab and browser window if last tab
// chrome.tabs.remove will not close the window on last tab closure -> needs to check if single tab opened
chrome.tabs.query({
    //active: true,
    currentWindow: true
}, function(tabs)   {
    if (tabs.length > 1{
        chrome.tabs.query({
            active: true,
            currentWindow: true
        }, function(tabs)   {
        chrome.tabs.remove(tabs[0].id, function() { });
        });
    } else {
        chrome.windows.getCurrent(function(win) {
            chrome.windows.remove(win.id, function() { });
        });
    }       
});

AutoHotkey: Customize Button Message Box

It is not so easy in AutoHotkey to use a custom Message Box with customized Text on the Buttons or as many buttons as wished.
I present here 2 approaches and share some code.

June 15, 2020

AutoHotkey: TrayTipAutoHide

There is a nice function in AutoHotkey to display system tray notifications called TrayTip.
I present here an adaption to display the notification and auto-hide after a customizable time.
(The 3rd input parameter 'Time' in the active TrayTip function has no effect on Windows Vista and later.)

March 9, 2020

Text Expander supporting links / rich text format

Text Expander functionality is really useful. I have used PhraseExpress on Windows for this a lot (free for personal use only).
Now you can also use AutoHotkey for this using the so-called Hotstrings.
I present here a way to use Hotstrings that support links i.e. rich-text formatting.
It is based on the AutoHotkey utility I have highlighted in a previous post: WinClip

February 20, 2020

AutoHotkey: Copy content of MsgBox

While debugging in AutoHotkey I use a lot of MsgBox.
I've used also to copying to the clipboard (clipboard:= sVar)
to search and have a look in a variable content
Because I could not find a wait to copy the content of the MsgBox.
You can not select the content of the MsgBox.

The point is: you can ; just by pressing Ctrl+C: it will copy the whole content of the MsgBox. (plus the window title)

See here where I've found this answer in the AutoHotkey forum.

February 13, 2020

AutoHotkey: Add option to launch on startup

It is common to want to add your AutoHotkey script to the startup, so that it automatically is started when you start your PC.
I share here a standard approach to provide this to the user.

February 12, 2020

AutoHotkey: Clipboard handling

For clipboard handling with AutoHotkey I recommend the following resource called WinClip .

February 10, 2020

AutoHotkey: Undocumented Hotkeys for Gui Menus

This is a feature a bit hidden/undocumented in AutoHotkey I have learned from Jack's blog post here:
https://jacksautohotkeyblog.wordpress.com/2019/12/30/use-autohotkey-gui-menu-bar-for-instant-hotkeys/

When appended to the end of a MenuItemName, the tab character (`t) followed by one or more standard Hotkey modifiers (CtrlAlt, or Shift) plus another key “indicates a keyboard shortcut that the user may press instead of selecting the menu item. If the shortcut uses only the standard modifier key names CtrlAlt and Shift, it is automatically registered as a keyboard accelerator for the GUI.”
I use this for example in a simple ListView Gui with checkboxes to be able to select all with Ctrl+A.

Menu, ItemsMenu, Add, Check All`tCtrl+A, SelectAll
Menu, ItemsMenu, Add, Uncheck all`tCtrl+Shift+A, UncheckAll

SelectAll:
LV_Modify(0, "Check")  ; Uncheck all the checkboxes.
return
UncheckAll:
LV_Modify(0, "-Check")  ; Uncheck all the checkboxes.
return

This saves a lot of work-arounding with dynamic hotkeys.

(Thanks to Jack for sharing it)

January 20, 2020

PowerPoint: Change Language in whole Presentation (VBA Macro)

Working in an international environment, I need a lot of time to fix the language in a whole PowerPoint presentation. There is no built-in feature for this available. I share here my VBA based solution.

January 13, 2020

Gmail Disposable Email Addresses

This is a (old but still) great tip to know if you are using Gmail / Google Mail:

You can use custom email addresses postponing a +text to your standard gmail adress before the @.
Example: I can use thierry.dalon+spam@gmail.com

After this you can create a filter/ rule to handle these email. Example Move to Promotions or Spam or add a label "promo" to all incoming emails sent to thierry.dalon+promo@gmail.com

I've used this trick for a site requesting to register to a newsletter to get a discount:

Reference: https://www.lifehacker.com.au/2010/08/how-to-manage-disposable-email-addresses-with-gmail/

LinkedIn Translation Language Settings


Are you annoyed in LinkedIn by this "See translation" button for posts you understand the language of?


You can add additional languages you understand to avoid this.
Go to Settings->Account->Site preferences->Content Languages

January 4, 2020

How to download a spotify song or playlist (using Python)

For my kids I use following way to put their spotify playlist on their mp3-player.
It is based on some python scripts available here: https://github.com/ritiek/spotify-downloader

December 16, 2019

Meditation Apps

I have tried a couple of meditation apps. I share here my favorites.
.

October 28, 2018

MATLAB bug: Why does QUESTDLG return the wrong button string if I use the TAB key to switch between different buttons and then hit the Return key?


The UI MATLAB function questdlg has following issue:

If you use questdlg and use the TAB key to switch different button and press the ENTER key to validate your selection, the returned selected Button is always the Default button.

The issue is described in details in the Support Knowledge base 1-3MB2SF.

Below a short screencast to demonstrate it:
It is still not solved in MATLAB R2015b.
As mentioned in the Answer here, this issue can be fixed easily by adding/editing 2 lines in questdlg:
Change the KeyPressFcn callback to:

function cb_KeyPressFcn(obj,evd)
switch(evd.Key)
    case {'return','space'}
        ButtonName=get(get(figureHandle,'CurrentObject'),'String');
        setappdata(figureHandle,'ButtonName',ButtonName);
        uiresume(gcbf);
    case 'escape'
        doDelete
end

and after the uiwait change the line:

ButtonName=get(get(QuestFig,'CurrentObject'),'String');

into:

ButtonName=getappdata(figureHandle,'ButtonName');
if isempty(ButtonName), % no KeyPress/ MouseClick,
    ButtonName=get(get(figureHandle,'CurrentObject'),'String');
end


This fix is implemented in the myquestdlg available in my .


Note:

It is still required to used a drawnow after a myquestdlg call, because of some MATLAB hanging issues.


Related Posts:

Word: Update All Fields

Changes done by updating the fields or TOC shall not be tracked

References / Word Tips



Code is available in Gist


AutoHotkey Script to Open file in Explorer with specific application

Solution is available https://autohotkey.com/board/topic/77665-open-files-with-portable-notepad/


; AutoExecute Section must be on the top of the script
#NoEnv
SetWorkingDir %A_ScriptDir%
GroupAdd, Explore, ahk_class CabinetWClass         ; Add a class to the group
GroupAdd, Explore, ahk_class ExploreWClass         ; Add a other class to the group


; Open file With Notepad++ from Explorer using Alt+N hotkey
; https://autohotkey.com/board/topic/77665-open-files-with-portable-notepad/

#ifWinActive,ahk_group Explore              ; Set hotkeys to work in explorer only
; Alt+N
!n::
   ClipSaved := ClipboardAll
   Clipboard := ""
   Send ^c
   ClipWait, 0.5
   file := Clipboard
   Clipboard := ClipSaved
   Run D:\DSUsers\uid41890\PortableApps\Notepad++Portable\Notepad++Portable.exe "%file%"
return



Code is available in Gist


Add this script to your Startup folder.

MATLAB: How to find when a feature was introduced in MathWorks products?


Once I wanted to find when = in which MATLAB Release the Fast Restart feature of Simulink was introduced.
This post explains the way to find it out.
1.) Go to the MathWorks product documentation http://www.mathworks.com/help/
2.) Search for "fast restart" (with quotation marks around)
3.) On the left under "Refine by Product" select Simulink
4.) On the left under "Refine by Type" select Release Notes

Direct link looks like this: http://www.mathworks.com/help/search.html?qdoc=%22fast+restart%22+type%3Arn+product%3Asimulink



5.) Click on the one remaining search entry and you should find what you are looking for.

StackOverflow https://stackoverflow.com/questions/19778832/how-can-i-check-since-which-matlab-version-a-function-exists/36922759#36922759

FileExchange Utility when

Window always on top

Problem description

Sometimes it is pretty useful to set a Window to be always on top e.g. when viewing a video on the side or presenting something with your video camera stream on the top.

 With AutoHotkey it doesn't take more than one line of code:

MATLAB bug: How can I modify the INPUTDLG function to make the "Enter" key synonymous with the "OK" button?

It is quite annoying for the user that with the standard MATLAB input dialog (

) you can not validate your inputs by simply pressing the Enter key and have to click with the mouse on the "OK" button or the only way to close the dialog without using the mouse is to Tab through all of the fields until the OK button is active and then press "Enter".
The question was already asked to MathWorks support. This is the solution provided by MathWorks:
It is not very comfortable, since you have to copy a file into the MATLAB installation uitools subfolder.
Another solution is implemented in the function myinputdlg. This function is standalone and does not require the use of native uitools/private functions.
Besides you can press the "Space" key on the pushbuttons to activate them and the space KeyPress on the figure is not buggy anymore.

Related posts: