Skip to content

Instantly share code, notes, and snippets.

Thierry Dalon tdalon

Block or report user

Report or block tdalon

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@tdalon
tdalon / CheckTodayReminders.bas
Last active May 7, 2019
Outlook vba to check appointment reminders
View CheckTodayReminders.bas
Sub CheckTodayReminders()
' https://www.datanumen.com/blogs/quickly-send-todays-appointments-someone-via-outlook-vba/
Dim objAppointments As Outlook.Items
Dim objTodayAppointments As Outlook.Items
Dim strFilter As String
Dim objAppointment As Outlook.AppointmentItem ' Object
Set objAppointments = Application.Session.GetDefaultFolder(olFolderCalendar).Items
objAppointments.IncludeRecurrences = True
objAppointments.Sort "[Start]", False ' Bug: use False/descending see https://social.msdn.microsoft.com/Forums/office/en-US/919e1aee-ae67-488f-9adc-2c8518854b2a/how-to-get-recurring-appointment-current-date?forum=outlookdev
@tdalon
tdalon / MyScript.ahk
Created Oct 10, 2016
AutoHotkey Script: Open in Explorer with Notepad++, Keep Window always on top
View MyScript.ahk
; 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
; Always on Top CTRL+SPACE on current window
; http://www.labnol.org/software/tutorials/keep-window-always-on-top/5213/
^SPACE:: Winset, Alwaysontop, , A
@tdalon
tdalon / DeleteEmptyParagraphs.bas
Created Sep 30, 2016
MS Office Word VBA Macros to delete empty paragraphs
View DeleteEmptyParagraphs.bas
Sub DeleteEmptyParagraphs()
Dim oPara As Word.Paragraph
For Each oPara In ActiveDocument.Paragraphs
If Len(oPara.Range) = 1 Then oPara.Range.Delete
Next
End Sub
Sub DeleteEmptyParagraphsWithSpaces()
Dim oPara As Word.Paragraph
Dim var
@tdalon
tdalon / UpdateAllFields.bas
Created Sep 30, 2016
Update All Fields Macro for MS Office Word
View UpdateAllFields.bas
Sub UpdateAllFields()
'
' UpdateAllFields Macro
'
'
Dim oStory As Range
Dim oField As Field
For Each oStory In ActiveDocument.StoryRanges
For Each oField In oStory.Fields
oField.Update
@tdalon
tdalon / myquestdlg.m
Created Sep 28, 2016
MATLAB Modified questdlg to solve bug
View myquestdlg.m
function ButtonName=myquestdlg(Question,Title,Btn1,Btn2,Btn3,Default)
%MYQUESTDLG Question dialog box. Same as QUESTDLG plus solves the issue that if user press ENTER
% it will return the Default Button and not the selected one.
% See http://tdalon.blogspot.com/2016/09/matlab-bug-questdlg.html
% Moreover the dialog window is now properly centered in the middle of the screen.
%
% SYNTAX:
% ButtonName=myquestdlg(Question,Title,Btn1,Btn2,Btn3,Default)
% OUTPUT
% ButtonName (char) is empty if User ESC the dialog.
@tdalon
tdalon / TextBox_Search_KeyDown.bas
Last active Sep 27, 2016
PowerPoint VBA TextBox KeyDown Callback
View TextBox_Search_KeyDown.bas
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
' https://tdalon.blogspot.com/2016/09/powerpoint-quick-search-tagged-slides.html
' References: http://stackoverflow.com/questions/26587114/powerpoint-search-box-vba
' Hidden Search TextBox
Dim osld As Slide
Dim oshp As Shape
Dim sTextToFind As String
If KeyCode <> 13 Then 'ENTER PRESSED
View plot_depfun.m
function [opt, callstr] = plot_depfun(foo,varargin)
% PLOT_DEPFUN plots a call graph tree of the function dependencies
% SYNTAX
% plot_depfun(foo,varargin)
%
% Ignores MATLAB function in matlabroot and any function names given in varargin.
% Uses current file in MATLAB Editor as default if no argument is passed or first argument is empty.
%
% See also depfun, mydepfun, plot_subfun (file exchange ID 46070)
@tdalon
tdalon / UpdateAllFieldsTOCWithoutTracking.bas
Last active Sep 30, 2016
MS Office Word VBA Macro to update all fields including in header and footer also update Table of Contents. Tracking Changes is disabled during the update.
View UpdateAllFieldsTOCWithoutTracking.bas
Sub UpdateAllFieldsTOCWithoutTracking()
' Update All Fields and TOC without Tracking Changes for it:
' References:
' http://www.gmayor.com/installing_macro.htm or
' http://stackoverflow.com/questions/33733113/macro-to-update-all-fields-in-a-word-document
' http://gregmaxey.mvps.org/word_tip_pages/word_fields.html
' http://vba.relief.jp/word-vba-toggle-track-change/
Dim oStory As Range
Dim isChangesTracked As Boolean
@tdalon
tdalon / EditorGetFile.m
Last active Oct 10, 2016
Get current file opened in MATLAB Editor
View EditorGetFile.m
function file=EditorGetFile
% EditorGetFile get current file opened in Editor
%
% SYNTAX:
% file=EditorGetFile
% OUTPUT:
% file (char): fullpath
edhandle = com.mathworks.mlservices.MLEditorServices.getEditorApplication;
file = edhandle.getActiveEditor.getDocument.getFilename;
@tdalon
tdalon / MoveSectionsSelectedBySlides.bas
Last active Sep 22, 2016
PowerPoint VBA: Move sections selected by slides
View MoveSectionsSelectedBySlides.bas
Sub MoveSelectedSections()
' Slides are copied ready to be pasted
Dim lngNewPosition As Long
'Debug.Print ""
'Debug.Print "###Move Sections..."
lngNewPosition = InputBox("Enter a destination section index:")
lngNewPosition = CInt(lngNewPosition) ' Convert String to Int
Call MoveSectionsSelectedBySlides(ActivePresentation, lngNewPosition)
End Sub
You can’t perform that action at this time.