March 2026
M	T	W	T	F	S	S
	1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31

Archive for the ‘Office’ Category

Office 2011 for Mac update pesky Window pops up every 10 seconds

Posted by jpluimers on 2018/03/27

From the “I hate my users” department:

This dialog pops up every 10 seconds
The Office 2011 for Mac update requires non-Office apps to quit as well

–jeroen

Posted in Apple, Development, iMac, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, Office, Office 2011 for Mac, Power User, Software Development, Usability, User Experience (ux) | Leave a Comment »

Mixing x64 Outlook with x86 Delphi: never a good idea…

Posted by jpluimers on 2018/02/07

Via [WayBack] Hi all,I’m a bit stuck here with a “simple” task.Looks like Outlook 2016 doesn’t supports “MAPISendMail”, at least, if i trigger this, Thunderbird… – Attila Kovacs – Google+:

Basically only MAPISendMail works cross architecture and only if you fill all fields.

This edited [WayBack] email – MAPI Windows 7 64 bit – Stack Overflow answer by [WayBack] epotter is very insightful (thanks [WayBack] Rik van Kekem – Google+):

Calls to MAPISendMail should work without a problem.

For all other MAPI method and function calls to work in a MAPI application, the bitness (32 or 64) of the MAPI application must be the same as the bitness of the MAPI subsystem on the computer that the application is targeted to run on.

In general, a 32-bit MAPI application must not run on a 64-bit platform (64-bit Outlook on 64-bit Windows) without first being rebuilt as a 64-bit application.

For a more detailed explanation, see the MSDN page on Building MAPI Applications on 32-Bit and 64-Bit Platforms

–jeroen

Posted in Delphi, Delphi x64, Development, Office, Outlook, Power User, Software Development, x86 | Leave a Comment »

Fixing PowerPoint Annoyances: When I double-click a .pps/.ppx file, the PowerPoint icon appear on the taskbar…

Posted by jpluimers on 2018/01/05

From [WayBack] 1. Presenting Your Presentation – Fixing PowerPoint Annoyances [Book]:

PowerPoint Opens Minimized

THE ANNOYANCE: I can’t get my presentation to open properly when I double-click it. I can see the PowerPoint icon on the taskbar, but it won’t maximize or restore. How can I view the presentation?

THE FIX: Your slide show is set to display on the secondary monitor, which is no longer attached to your computer. Open PowerPoint from Start → Program Files and select File → Open to open your presentation. Then select Slide Show → Set up Show and choose “Display slide show on primary monitor.”

–jeroen

Posted in Office, Power Point, Power User | Leave a Comment »

Completely Uninstall Skype For Business (aka Lync) – Skype Community

Posted by jpluimers on 2017/05/05

I don’t need Skype (aka Lync) on all my VMs, for enough reasons (obnoxiously getting in the way even when not configured, downloading updates even though not used, taking up space, etc).

Removing it through appwiz.cpl is more than just a single step. The reason is that Skype can be part of Office and – despite the updates being called Skype – can be listed as the Lync component in Office.

So the removal is as follows:

Run appwiz.cpl
Select the Microsoft Office version you have installed
Right click, then choose Change
Choose “Add or Remove features” then “Continue”
Choose the dropdown left of “Microsoft Lync” or “Microsoft Office”, then click “Not Available” and click “Continue”
Wait for the removal to proceed, then click “Close”

–jeroen

via: Solved: Completely Uninstall Skype For Business – Skype Community

Posted in Office, Office 2010, Office 2013, Office 2016, Power User | Leave a Comment »

Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted by jpluimers on 2017/01/09

To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:

Meaning: Column: Formula: Explanation:

Date1Text I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings

Date1Value J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # is any separator

DatesEqual K =J2=L2 Are the encoded dates equal?

Date2Value L =DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) Encode the date text to an actual date: mm#dd#yyyy format where # is any separator

Date2Text M =TEXT(N2,”mm/dd/yyyy”) Interpret date text of the original text no matter the Excel settings

Meaning:	Column:	Formula:	Explanation:
Date1Text	I	=TEXT(C2,”dd/mm/yyyy”)	Interpret date text of the original text no matter the Excel settings
Date1Value	J	=DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2))	Encode the date text to an actual date: dd#mm#yyyy format where # is any separator
DatesEqual	K	=J2=L2	Are the encoded dates equal?
Date2Value	L	=DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2))	Encode the date text to an actual date: mm#dd#yyyy format where # is any separator
Date2Text	M	=TEXT(N2,”mm/dd/yyyy”)	Interpret date text of the original text no matter the Excel settings

Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.

Source: Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted in Excel, Office, Office 2007, Office 2010, Office 2013, Power User | 1 Comment »

Simple download script to get all FREE Microsoft eBooks again! Including: Windows 10, Office 365, Office 2016, Power BI, Azure, Windows 8.1, Office 2013, SharePoint 2016, SharePoint 2013, Dynamics CRM, PowerShell, Exchange Server, System Center, Cloud, SQL Server and more! | Microsoft Director of Sales Excellence – Eric Ligman

Posted by jpluimers on 2016/12/21

I saw a lot of people mention the Eric Ligman, Microsoft Director of Sales Excellence Blog a while ago: FREE! That’s Right, I’m Giving Away MILLIONS of FREE Microsoft eBooks again! Including: Windows 10, Office 365, Office 2016, Power BI, Azure, Windows 8.1, Office 2013, SharePoint 2016, SharePoint 2013, Dynamics CRM, PowerShell, Exchange Server, System Center, Cloud, SQL Server and more! | Microsoft Director of Sales Excellence – Eric Ligman

Even though I make most of my income from the Microsoft World, my main machine is a Mac and I dislike browsing

So I wanted to download them all in one easy go so SpotLight could index them.

Luckily there is a file that has all the download URLs in it: http://ligman.me/29zpthb (it expands to http://www.mssmallbiz.com/ericligman/Key_Shorts/MSFTFreeEbooks.txt and is archived at http://web.archive.org/web/*/http://www.mssmallbiz.com/ericligman/Key_Shorts/MSFTFreeEbooks.txt).

The file is mentioned at How to “Download All” of the FREE eBooks and Resources in My FREE eBooks Giveaway | Microsoft Director of Sales Excellence – Eric Ligman.

It’s very easy to download from there using wget (on Windows get it from https://eternallybored.org/misc/wget/ – the x64 versions work fine).

Be sure to use a “recent” version as 1.12 and lower have no support for the --trust-server-names parameter which makes wget use filenames from the http 301 followed links:

--trust-server-names
     If this is set to on, on a redirect the last component of the redirection URL will be used as the local file name.  By default it is used the last component in the original URL.

This is the script:

wget -m -np --trust-server-names http://ligman.me/29zpthb wget -m -np --trust-server-names --input-file www.mssmallbiz.com/ericligman/Key_Shorts/MSFTFreeEbooks.txt

You might think why not do just wget -m -np --trust-server-names --input-file http://ligman.me/29zpthb in one go?

Simple answer: like all software, wget occasionally crashes somewhere in the middle of downloading the URLs embedded.

If you restart, then it sees the followed http://ligman.me/29zpthb file has already been downloaded and won’t re-scan its contents.

Bug? I’m not sure. But the two-liner just works.

–jeroen

PS: if you want a script with all the URLs, try these:

https://news.ycombinator.com/item?id=12071552

	wget –trust-server-names -m -np http://ligman.me/29ngkYn
	wget –trust-server-names -m -np http://ligman.me/29jL5wW
	wget –trust-server-names -m -np http://ligman.me/29afIRV
	wget –trust-server-names -m -np http://ligman.me/29pyHgR
	wget –trust-server-names -m -np http://ligman.me/29dmbfC
	wget –trust-server-names -m -np http://ligman.me/29ollRF
	wget –trust-server-names -m -np http://ligman.me/29gvv67
	wget –trust-server-names -m -np http://ligman.me/29pzkHg
	wget –trust-server-names -m -np http://ligman.me/29CWQ20
	wget –trust-server-names -m -np http://ligman.me/1G0Cm7T
	wget –trust-server-names -m -np http://ligman.me/29vDVrw
	wget –trust-server-names -m -np http://ligman.me/29CW4SV
	wget –trust-server-names -m -np http://ligman.me/29G1z1N
	wget –trust-server-names -m -np http://ligman.me/29yWAAO
	wget –trust-server-names -m -np http://ligman.me/29DHWHq
	wget –trust-server-names -m -np http://ligman.me/1HGwMgm
	wget –trust-server-names -m -np http://ligman.me/29yUVeH
	wget –trust-server-names -m -np http://ligman.me/29ErxWs
	wget –trust-server-names -m -np http://ligman.me/29EsHkr
	wget –trust-server-names -m -np http://ligman.me/29v5zCF
	wget –trust-server-names -m -np http://ligman.me/1H32nUT
	wget –trust-server-names -m -np http://ligman.me/29yixk9
	wget –trust-server-names -m -np http://ligman.me/29vq6d2
	wget –trust-server-names -m -np http://ligman.me/29cvrjG
	wget –trust-server-names -m -np http://ligman.me/29pzjTR
	wget –trust-server-names -m -np http://ligman.me/29rPOf6
	wget –trust-server-names -m -np http://ligman.me/29ctW9z
	wget –trust-server-names -m -np http://ligman.me/29gvoHt
	wget –trust-server-names -m -np http://ligman.me/29gvfEd
	wget –trust-server-names -m -np http://ligman.me/29LvcBg
	wget –trust-server-names -m -np http://ligman.me/29DS3gJ
	wget –trust-server-names -m -np http://ligman.me/1q9L65I
	wget –trust-server-names -m -np http://ligman.me/29pufLO
	wget –trust-server-names -m -np http://ligman.me/29wODdA
	wget –trust-server-names -m -np http://ligman.me/29vch9q
	wget –trust-server-names -m -np http://ligman.me/29EmfZc
	wget –trust-server-names -m -np http://ligman.me/29LXmMt
	wget –trust-server-names -m -np http://ligman.me/29qwKfQ
	wget –trust-server-names -m -np http://ligman.me/29sp3nZ
	wget –trust-server-names -m -np http://ligman.me/29yWFFf
	wget –trust-server-names -m -np http://ligman.me/29ZNaMN
	wget –trust-server-names -m -np http://ligman.me/29gYy5h
	wget –trust-server-names -m -np http://ligman.me/29NhudA
	wget –trust-server-names -m -np http://ligman.me/29jDRJf
	wget –trust-server-names -m -np http://ligman.me/29conIf
	wget –trust-server-names -m -np http://ligman.me/29cnLlL
	wget –trust-server-names -m -np http://ligman.me/29fNYRE
	wget –trust-server-names -m -np http://ligman.me/29cq9cw
	wget –trust-server-names -m -np http://ligman.me/29acqhj
	wget –trust-server-names -m -np http://ligman.me/29fJJCS
	wget –trust-server-names -m -np http://ligman.me/29nbxWK
	wget –trust-server-names -m -np http://ligman.me/29fO9MV
	wget –trust-server-names -m -np http://ligman.me/29pr2x1
	wget –trust-server-names -m -np http://ligman.me/29oa0kH
	wget –trust-server-names -m -np http://ligman.me/29i6ntm
	wget –trust-server-names -m -np http://ligman.me/29n7JVF
	wget –trust-server-names -m -np http://ligman.me/29fQsQ4
	wget –trust-server-names -m -np http://ligman.me/29fQo2J
	wget –trust-server-names -m -np http://ligman.me/29idz8T
	wget –trust-server-names -m -np http://ligman.me/29dfwlu
	wget –trust-server-names -m -np http://ligman.me/29fLliP
	wget –trust-server-names -m -np http://ligman.me/29i83TI
	wget –trust-server-names -m -np http://ligman.me/29diypX
	wget –trust-server-names -m -np http://ligman.me/29fNpHO
	wget –trust-server-names -m -np http://ligman.me/29oefNf
	wget –trust-server-names -m -np http://ligman.me/29jGTgC
	wget –trust-server-names -m -np http://ligman.me/29crPhL
	wget –trust-server-names -m -np http://ligman.me/29FUJIk
	wget –trust-server-names -m -np http://ligman.me/1G2oDNG
	wget –trust-server-names -m -np http://ligman.me/29u5uMT
	wget –trust-server-names -m -np http://ligman.me/29rlRt3
	wget –trust-server-names -m -np http://ligman.me/29Yd9V0
	wget –trust-server-names -m -np http://ligman.me/29s4EQ1
	wget –trust-server-names -m -np http://ligman.me/29vkv6E
	wget –trust-server-names -m -np http://ligman.me/29A3q8Z
	wget –trust-server-names -m -np http://ligman.me/29H7ovO
	wget –trust-server-names -m -np http://ligman.me/1dHMOui
	wget –trust-server-names -m -np http://ligman.me/1G2pw8X
	wget –trust-server-names -m -np http://ligman.me/29gnaPK
	wget –trust-server-names -m -np http://ligman.me/29d7GZH
	wget –trust-server-names -m -np http://ligman.me/29i2Mvf
	wget –trust-server-names -m -np http://ligman.me/29rbpkY
	wget –trust-server-names -m -np http://ligman.me/29e6cTO
	wget –trust-server-names -m -np http://ligman.me/29hJU1c
	wget –trust-server-names -m -np http://ligman.me/29bcJtd
	wget –trust-server-names -m -np http://ligman.me/29bcRZO
	wget –trust-server-names -m -np http://ligman.me/29d5mS2
	wget –trust-server-names -m -np http://ligman.me/29cz6OD
	wget –trust-server-names -m -np http://ligman.me/29fDult
	wget –trust-server-names -m -np http://ligman.me/29pEdjN
	wget –trust-server-names -m -np http://ligman.me/29rwoY0
	wget –trust-server-names -m -np http://ligman.me/29fTQrx
	wget –trust-server-names -m -np http://ligman.me/29gfrkN
	wget –trust-server-names -m -np http://ligman.me/29rwoHw
	wget –trust-server-names -m -np http://ligman.me/29d5AbX
	wget –trust-server-names -m -np http://ligman.me/29fudHc
	wget –trust-server-names -m -np http://ligman.me/29FzGG5
	wget –trust-server-names -m -np http://ligman.me/29osNwd
	wget –trust-server-names -m -np http://ligman.me/29a22WR
	wget –trust-server-names -m -np http://ligman.me/29alDpK
	wget –trust-server-names -m -np http://ligman.me/29fDylj
	wget –trust-server-names -m -np http://ligman.me/29jPTCx
	wget –trust-server-names -m -np http://ligman.me/29d5XTw
	wget –trust-server-names -m -np http://ligman.me/29rUIci
	wget –trust-server-names -m -np http://ligman.me/29hVdVa
	wget –trust-server-names -m -np http://ligman.me/29ijDhm
	wget –trust-server-names -m -np http://ligman.me/29pn5e2
	wget –trust-server-names -m -np http://ligman.me/29ckVx7
	wget –trust-server-names -m -np http://ligman.me/29cfePX
	wget –trust-server-names -m -np http://ligman.me/29vGIvY
	wget –trust-server-names -m -np http://ligman.me/29hfnPR
	wget –trust-server-names -m -np http://ligman.me/29fCVFe
	wget –trust-server-names -m -np http://ligman.me/29a6YLu
	wget –trust-server-names -m -np http://ligman.me/29n4GwJ
	wget –trust-server-names -m -np http://ligman.me/29jAS3v
	wget –trust-server-names -m -np http://ligman.me/29ci56U
	wget –trust-server-names -m -np http://ligman.me/29nW9L3
	wget –trust-server-names -m -np http://ligman.me/29hV6ZM
	wget –trust-server-names -m -np http://ligman.me/29d1qAV
	wget –trust-server-names -m -np http://ligman.me/29pfpbI
	wget –trust-server-names -m -np http://ligman.me/29v8nwX
	wget –trust-server-names -m -np http://ligman.me/29uq452
	wget –trust-server-names -m -np http://ligman.me/29d1wc3
	wget –trust-server-names -m -np http://ligman.me/29Y1O7a
	wget –trust-server-names -m -np http://ligman.me/29a7wRA
	wget –trust-server-names -m -np http://ligman.me/29pnEEG
	wget –trust-server-names -m -np http://ligman.me/1FYtDD8
	wget –trust-server-names -m -np http://ligman.me/1HByNKS
	wget –trust-server-names -m -np http://ligman.me/1NCfcKC
	wget –trust-server-names -m -np http://ligman.me/1HCDxl9
	wget –trust-server-names -m -np http://ligman.me/1HCCCRP
	wget –trust-server-names -m -np http://ligman.me/1H4Q0e5
	wget –trust-server-names -m -np http://ligman.me/1JI6V77
	wget –trust-server-names -m -np http://ligman.me/1CSMobd
	wget –trust-server-names -m -np http://ligman.me/1jWMJA2
	wget –trust-server-names -m -np http://ligman.me/1m6xucg
	wget –trust-server-names -m -np http://ligman.me/1onTg9n
	wget –trust-server-names -m -np http://ligman.me/1n49kzj
	wget –trust-server-names -m -np http://ligman.me/1sgBtn4
	wget –trust-server-names -m -np http://ligman.me/1qZlnOJ
	wget –trust-server-names -m -np http://ligman.me/TWa2Dg
	wget –trust-server-names -m -np http://ligman.me/1vM9mwt
	wget –trust-server-names -m -np http://ligman.me/1qzON6Q
	wget –trust-server-names -m -np http://ligman.me/1rB8nl1
	wget –trust-server-names -m -np http://ligman.me/TL3pn1
	wget –trust-server-names -m -np http://ligman.me/1vM9H2d
	wget –trust-server-names -m -np http://ligman.me/29odbJ6
	wget –trust-server-names -m -np http://ligman.me/1LSKTC0
	wget –trust-server-names -m -np http://ligman.me/1qC1pu4
	wget –trust-server-names -m -np http://ligman.me/1dHSpRh
	wget –trust-server-names -m -np http://ligman.me/1LO5k1Y
	wget –trust-server-names -m -np http://ligman.me/1M7Xr5v
	wget –trust-server-names -m -np http://ligman.me/29jLNtX
	wget –trust-server-names -m -np http://ligman.me/29agpuw
	wget –trust-server-names -m -np http://ligman.me/29cv8FE
	wget –trust-server-names -m -np http://ligman.me/29ieXIo
	wget –trust-server-names -m -np http://ligman.me/29dmCXi
	wget –trust-server-names -m -np http://ligman.me/29jLjnM
	wget –trust-server-names -m -np http://ligman.me/29agkqx
	wget –trust-server-names -m -np http://ligman.me/29gvTBJ
	wget –trust-server-names -m -np http://ligman.me/29pztuz
	wget –trust-server-names -m -np http://ligman.me/29dmTJT
	wget –trust-server-names -m -np http://ligman.me/29ieSEI
	wget –trust-server-names -m -np http://ligman.me/29hB9CQ
	wget –trust-server-names -m -np http://ligman.me/29fOWdV
	wget –trust-server-names -m -np http://ligman.me/1JPNIAt
	wget –trust-server-names -m -np http://ligman.me/29Xnqk8
	wget –trust-server-names -m -np http://ligman.me/29oRWlp
	wget –trust-server-names -m -np http://ligman.me/29csX4C
	wget –trust-server-names -m -np http://ligman.me/29jH8bx
	wget –trust-server-names -m -np http://ligman.me/29pcQFA
	wget –trust-server-names -m -np http://ligman.me/29FkNr3
	wget –trust-server-names -m -np http://ligman.me/12FIapt
	wget –trust-server-names -m -np http://ligman.me/13WvGXa
	wget –trust-server-names -m -np http://ligman.me/1bPPb6C
	wget –trust-server-names -m -np http://ligman.me/12FIZ1I
	wget –trust-server-names -m -np http://ligman.me/16CaDM1
	wget –trust-server-names -m -np http://ligman.me/19LwMLI
	wget –trust-server-names -m -np http://ligman.me/1JHmqiB
	wget –trust-server-names -m -np http://ligman.me/1KHqGNK
	wget –trust-server-names -m -np http://ligman.me/1M7Ycve
	wget –trust-server-names -m -np http://ligman.me/1LSOsIu
	wget –trust-server-names -m -np http://ligman.me/1UrQDFx
	wget –trust-server-names -m -np http://ligman.me/TUmyTW
	wget –trust-server-names -m -np http://ligman.me/1NLviCk
	wget –trust-server-names -m -np http://ligman.me/17iaq4l
	wget –trust-server-names -m -np http://ligman.me/1bPRqqz
	wget –trust-server-names -m -np http://ligman.me/17iah0Q
	wget –trust-server-names -m -np http://ligman.me/1287Jt4
	wget –trust-server-names -m -np http://ligman.me/29djdrk
	wget –trust-server-names -m -np http://ligman.me/29rLH2H
	wget –trust-server-names -m -np http://ligman.me/29fNPxT
	wget –trust-server-names -m -np http://ligman.me/29ddm60
	wget –trust-server-names -m -np http://ligman.me/29gsnHt
	wget –trust-server-names -m -np http://ligman.me/29nc2QS
	wget –trust-server-names -m -np http://ligman.me/29fOrnd
	wget –trust-server-names -m -np http://ligman.me/29dk0Ze
	wget –trust-server-names -m -np http://ligman.me/29aewh2
	wget –trust-server-names -m -np http://ligman.me/29gteI8
	wget –trust-server-names -m -np http://ligman.me/29ibJVq
	wget –trust-server-names -m -np http://ligman.me/29fKMD6
	wget –trust-server-names -m -np http://ligman.me/29cthAz
	wget –trust-server-names -m -np http://ligman.me/29ohqUT
	wget –trust-server-names -m -np http://ligman.me/29crGiw
	wget –trust-server-names -m -np http://ligman.me/29gsFOl
	wget –trust-server-names -m -np http://ligman.me/29ncgrb
	wget –trust-server-names -m -np http://ligman.me/29fKWdi
	wget –trust-server-names -m -np http://ligman.me/29djvi9
	wget –trust-server-names -m -np http://ligman.me/29FW41O
	wget –trust-server-names -m -np http://ligman.me/29ddKBp
	wget –trust-server-names -m -np http://ligman.me/29dkhf4
	wget –trust-server-names -m -np http://ligman.me/29rML6Q
	wget –trust-server-names -m -np http://ligman.me/29hxyEN
	wget –trust-server-names -m -np http://ligman.me/29fPweO
	wget –trust-server-names -m -np http://ligman.me/29fPMug
	wget –trust-server-names -m -np http://ligman.me/29fPnIe
	wget –trust-server-names -m -np http://ligman.me/29hxogT
	wget –trust-server-names -m -np http://ligman.me/29deg2k
	wget –trust-server-names -m -np http://ligman.me/29pwCBO
	wget –trust-server-names -m -np http://ligman.me/29fPAec
	wget –trust-server-names -m -np http://ligman.me/29deQgz
	wget –trust-server-names -m -np http://ligman.me/29afaLE
	wget –trust-server-names -m -np http://ligman.me/29pxarl
	wget –trust-server-names -m -np http://ligman.me/29ne5V5
	wget –trust-server-names -m -np http://ligman.me/29csBjh
	wget –trust-server-names -m -np http://ligman.me/29dkZZK
	wget –trust-server-names -m -np http://ligman.me/29ojrAy
	wget –trust-server-names -m -np http://ligman.me/29jJLdx
	wget –trust-server-names -m -np http://ligman.me/29df2fw
	wget –trust-server-names -m -np http://ligman.me/29cu6sX
	wget –trust-server-names -m -np http://ligman.me/29dlaE5
	wget –trust-server-names -m -np http://ligman.me/29FZx0B
	wget –trust-server-names -m -np http://ligman.me/29idnpO
	wget –trust-server-names -m -np http://ligman.me/29dlH9d
	wget –trust-server-names -m -np http://ligman.me/29cs157
	wget –trust-server-names -m -np http://ligman.me/29dkq1V
	wget –trust-server-names -m -np http://ligman.me/29aelm3
	wget –trust-server-names -m -np http://ligman.me/29ycEnb
	wget –trust-server-names -m -np http://ligman.me/29w5gr9
	wget –trust-server-names -m -np http://ligman.me/29pfQ50
	wget –trust-server-names -m -np http://ligman.me/1sgMWDe
	wget –trust-server-names -m -np http://ligman.me/29w68w8
	wget –trust-server-names -m -np http://ligman.me/29viFmi
	wget –trust-server-names -m -np http://ligman.me/29zYWzl
	wget –trust-server-names -m -np http://ligman.me/29H2bo1
	wget –trust-server-names -m -np http://ligman.me/29AT60J
	wget –trust-server-names -m -np http://ligman.me/29xtlNa
	wget –trust-server-names -m -np http://ligman.me/29xtHDs
	wget –trust-server-names -m -np http://ligman.me/29GpFsY
	wget –trust-server-names -m -np http://ligman.me/29ddd2b
	wget –trust-server-names -m -np http://ligman.me/29fJpEc
	wget –trust-server-names -m -np http://ligman.me/29cs7Fg
	wget –trust-server-names -m -np http://ligman.me/29fJA2g
	wget –trust-server-names -m -np http://ligman.me/29cqzzq
	wget –trust-server-names -m -np http://ligman.me/29ddbYb
	wget –trust-server-names -m -np http://ligman.me/29rLlZV
	wget –trust-server-names -m -np http://ligman.me/29ialCf
	wget –trust-server-names -m -np http://ligman.me/29pvj5I
	wget –trust-server-names -m -np http://ligman.me/29hwj8y
	wget –trust-server-names -m -np http://ligman.me/29dj7zY
	wget –trust-server-names -m -np http://ligman.me/1sl39Hs
	wget –trust-server-names -m -np http://ligman.me/1anyEJj
	wget –trust-server-names -m -np http://ligman.me/17icbPc
	wget –trust-server-names -m -np http://ligman.me/ZZezok
	wget –trust-server-names -m -np http://ligman.me/12S035G
	wget –trust-server-names -m -np http://ligman.me/12RZWY1
	wget –trust-server-names -m -np http://ligman.me/13PlvVY
	wget –trust-server-names -m -np http://ligman.me/12FMEMP
	wget –trust-server-names -m -np http://ligman.me/128a1ID
	wget –trust-server-names -m -np http://ligman.me/19LCgpM
	wget –trust-server-names -m -np http://ligman.me/13Pn1XY
	wget –trust-server-names -m -np http://ligman.me/13WChkr
	wget –trust-server-names -m -np http://ligman.me/12FN71F
	wget –trust-server-names -m -np http://ligman.me/ZZh7Ts
	wget –trust-server-names -m -np http://ligman.me/14HcD5O
	wget –trust-server-names -m -np http://ligman.me/17UHSNJ
	wget –trust-server-names -m -np http://ligman.me/19LEPIz
	wget –trust-server-names -m -np http://ligman.me/11VIxdB
	wget –trust-server-names -m -np http://ligman.me/12FObmf
	wget –trust-server-names -m -np http://ligman.me/11HXnjD
	wget –trust-server-names -m -np http://ligman.me/14fCxLS
	wget –trust-server-names -m -np http://ligman.me/16CkUI4
	wget –trust-server-names -m -np http://ligman.me/17VqB79
	wget –trust-server-names -m -np http://ligman.me/13XRfqr
	wget –trust-server-names -m -np http://ligman.me/19fCnqV
	wget –trust-server-names -m -np http://ligman.me/11WvSqL
	wget –trust-server-names -m -np http://ligman.me/1002Upx
	wget –trust-server-names -m -np http://ligman.me/14HMJ1Q
	wget –trust-server-names -m -np http://ligman.me/10ttQ3n
	wget –trust-server-names -m -np http://ligman.me/15fRBI9
	wget –trust-server-names -m -np http://ligman.me/19fDuqE
	wget –trust-server-names -m -np http://ligman.me/11IMDlh
	wget –trust-server-names -m -np http://ligman.me/10tu5eD
	wget –trust-server-names -m -np http://ligman.me/128NAD6
	wget –trust-server-names -m -np http://ligman.me/1bRgXzV
	wget –trust-server-names -m -np http://ligman.me/14givRo
	wget –trust-server-names -m -np http://ligman.me/18VNatF
	wget –trust-server-names -m -np http://ligman.me/128Ogso
	wget –trust-server-names -m -np http://ligman.me/13Qbl7k
	wget –trust-server-names -m -np http://ligman.me/10tuWvL
	wget –trust-server-names -m -np http://ligman.me/16dFAWc
	wget –trust-server-names -m -np http://ligman.me/11lkViX
	wget –trust-server-names -m -np http://ligman.me/1bRhVMn
	wget –trust-server-names -m -np http://ligman.me/14HOjki
	wget –trust-server-names -m -np http://ligman.me/1bRiXbc
	wget –trust-server-names -m -np http://ligman.me/13QcfRi
	wget –trust-server-names -m -np http://ligman.me/16E4lf4
	wget –trust-server-names -m -np http://ligman.me/1005lbB
	wget –trust-server-names -m -np http://ligman.me/14HOxb2
	wget –trust-server-names -m -np http://ligman.me/16E6G9L
	wget –trust-server-names -m -np http://ligman.me/14gkBRc
	wget –trust-server-names -m -np http://ligman.me/1006fEV
	wget –trust-server-names -m -np http://ligman.me/16dHXZ9
	wget –trust-server-names -m -np http://ligman.me/13QdHDb
	wget –trust-server-names -m -np http://ligman.me/11IQ8bd
	wget –trust-server-names -m -np http://ligman.me/17jgPfG
	wget –trust-server-names -m -np http://ligman.me/15fXTHQ
	wget –trust-server-names -m -np http://ligman.me/11vx5Cy
	wget –trust-server-names -m -np http://ligman.me/N1JiHO
	wget –trust-server-names -m -np http://ligman.me/OudHlO
	wget –trust-server-names -m -np http://ligman.me/OudJdr
	wget –trust-server-names -m -np http://ligman.me/N1I2o4
	wget –trust-server-names -m -np http://ligman.me/Oue0NG
	wget –trust-server-names -m -np http://ligman.me/Oue2oE
	wget –trust-server-names -m -np http://ligman.me/N1HQW0
	wget –trust-server-names -m -np http://ligman.me/Ouebsh
	wget –trust-server-names -m -np http://ligman.me/OuecfK
	wget –trust-server-names -m -np http://ligman.me/N1Ienp
	wget –trust-server-names -m -np http://ligman.me/OuelQu
	wget –trust-server-names -m -np http://ligman.me/OueoMd
	wget –trust-server-names -m -np http://ligman.me/N1J8A8
	wget –trust-server-names -m -np http://ligman.me/OueFPb
	wget –trust-server-names -m -np http://ligman.me/OueIKU
	wget –trust-server-names -m -np http://ligman.me/N1I935
	wget –trust-server-names -m -np http://ligman.me/OueUd4
	wget –trust-server-names -m -np http://ligman.me/OueVxy
	wget –trust-server-names -m -np http://ligman.me/N1HMW7
	wget –trust-server-names -m -np http://ligman.me/Ouf6sO
	wget –trust-server-names -m -np http://ligman.me/Ouf9og
	wget –trust-server-names -m -np http://ligman.me/N1Jo27
	wget –trust-server-names -m -np http://ligman.me/OufgQN
	wget –trust-server-names -m -np http://ligman.me/OufkQs
	wget –trust-server-names -m -np http://ligman.me/N1HEpM
	wget –trust-server-names -m -np http://ligman.me/Oufwzg
	wget –trust-server-names -m -np http://ligman.me/OufCXN
	wget –trust-server-names -m -np http://ligman.me/N1JfvI
	wget –trust-server-names -m -np http://ligman.me/OufRSs
	wget –trust-server-names -m -np http://ligman.me/OufVlq
	wget –trust-server-names -m -np http://ligman.me/N1HX3Q
	wget –trust-server-names -m -np http://ligman.me/Oug5Jl
	wget –trust-server-names -m -np http://ligman.me/Oug74a
	wget –trust-server-names -m -np http://ligman.me/1H1Exty
	wget –trust-server-names -m -np http://ligman.me/1S1f34H
	wget –trust-server-names -m -np http://ligman.me/1HGqihD
	wget –trust-server-names -m -np http://ligman.me/1G2ccS5
	wget –trust-server-names -m -np http://ligman.me/1ffeiJo
	wget –trust-server-names -m -np http://ligman.me/1NKjUqp
	wget –trust-server-names -m -np http://ligman.me/1KEShAt
	wget –trust-server-names -m -np http://ligman.me/1S1i4C0
	wget –trust-server-names -m -np http://ligman.me/1ReR3Qq
	wget –trust-server-names -m -np http://ligman.me/1dGxnSW
	wget –trust-server-names -m -np http://ligman.me/1IZCarE
	wget –trust-server-names -m -np http://ligman.me/1H2Bq3J
	wget –trust-server-names -m -np http://ligman.me/1Rf7BaZ
	wget –trust-server-names -m -np http://ligman.me/1LRIveQ
	wget –trust-server-names -m -np http://ligman.me/1dGxEW7
	wget –trust-server-names -m -np http://ligman.me/1omCrM6
	wget –trust-server-names -m -np http://ligman.me/1j5aDhH
	wget –trust-server-names -m -np http://ligman.me/1n3mkVY
	wget –trust-server-names -m -np http://ligman.me/1n3mAUZ
	wget –trust-server-names -m -np http://ligman.me/1vKOGot
	wget –trust-server-names -m -np http://ligman.me/1H7bxTv
	wget –trust-server-names -m -np http://ligman.me/1G0DEjb
	wget –trust-server-names -m -np http://ligman.me/29pbiLY
	wget –trust-server-names -m -np http://ligman.me/29dlTVV
	wget –trust-server-names -m -np http://ligman.me/29rOYz9
	wget –trust-server-names -m -np http://ligman.me/29ie2rq
	wget –trust-server-names -m -np http://ligman.me/29fQN5c
	wget –trust-server-names -m -np http://ligman.me/29idEct
	wget –trust-server-names -m -np http://ligman.me/29nevuE
	wget –trust-server-names -m -np http://ligman.me/29olaWI
	wget –trust-server-names -m -np http://ligman.me/29pz4Im
	wget –trust-server-names -m -np http://ligman.me/29fQRlQ
	wget –trust-server-names -m -np http://ligman.me/29hzPzU
	wget –trust-server-names -m -np http://ligman.me/29rON6X
	wget –trust-server-names -m -np http://ligman.me/29cumbH
	wget –trust-server-names -m -np http://ligman.me/29cv1JW
	wget –trust-server-names -m -np http://ligman.me/29dmh6L
	wget –trust-server-names -m -np http://ligman.me/29dfUkt
	wget –trust-server-names -m -np http://ligman.me/1giniO7
	wget –trust-server-names -m -np http://ligman.me/29H7K5O
	wget –trust-server-names -m -np http://ligman.me/1qbEeVc
	wget –trust-server-names -m -np http://ligman.me/1ewwcq6
	wget –trust-server-names -m -np http://ligman.me/1H1MFKr
	wget –trust-server-names -m -np http://ligman.me/1pxniH4
	wget –trust-server-names -m -np http://ligman.me/1dG2ZZ9
	wget –trust-server-names -m -np http://ligman.me/29v9igV
	wget –trust-server-names -m -np http://ligman.me/29hofVk
	wget –trust-server-names -m -np http://ligman.me/29idcee
	wget –trust-server-names -m -np http://ligman.me/29rOvx0
	wget –trust-server-names -m -np http://ligman.me/29ctkki
	wget –trust-server-names -m -np http://ligman.me/29okalt
	wget –trust-server-names -m -np http://ligman.me/29i2CEe
	wget –trust-server-names -m -np http://ligman.me/29FT71n
	wget –trust-server-names -m -np http://ligman.me/29NBSj1
	wget –trust-server-names -m -np http://ligman.me/29H3O3o
	wget –trust-server-names -m -np http://ligman.me/29OHLKa
	wget –trust-server-names -m -np http://ligman.me/29uHKKV

view raw

msdn-ebooks-urls.txt

hosted with ❤ by GitHub

Posted in *nix, .NET, Development, Office, Power User, Software Development, wget, Windows | 2 Comments »

datetime – Round time to nearest 15min interval in Excel – Stack Overflow

Posted by jpluimers on 2016/10/14

Easy, but I always forget:

= (ROUND((A1 * 1440) / 15, 0) * 15) / 1440

Thanks David for answering.

–jeroen

via datetime – Round time to nearest 15min interval in Excel – Stack Overflow.

Posted in Excel, Office, Power User | Leave a Comment »

How to group by date in excel? – Super User

Posted by jpluimers on 2016/10/10

Sometimes you don’t recognize how easy it is until you see it:

Add a column that is of type date with value =FLOOR(A2,1) .Then Insert -> Pivot Table. Then drag the date column on the right into the Rows box, and also drag it into values box. Done.

Thanks David d C e Freitas!

via How to group by date in excel? – Super User.

Posted in Excel, Office, Power User | Leave a Comment »

Word for Windows Keyboard Shortcut for Find Next – Super User

Posted by jpluimers on 2016/09/05

Unlike most applications where F3 is search next, Office has their own thought about keyboard shortcuts.

So in Word for Windows, you can use these:

Find next:
- “RepeatFind”: Shift+F4 or Ctrl+Alt+Y.
- “Browse next item”: Control+PageDown.
Find previous:
- “Browse previous item”: Control+PageUp.

–jeroen

via:

Posted in Keyboards and Keyboard Shortcuts, Office, Power User, Word | Leave a Comment »

Deleting Horizontal Lines From Word

Posted by jpluimers on 2016/08/01

Oh man, why didn’t they make a line object out of this…

But if you realize it is a bottom border, then deleting is easy:

The answer is something of a trick, as the horizontal line is not a line (or a graphic), it’s a bottom border.

–jeroen

via: Deleting Horizontal Lines From Word.

Posted in Office, Office 2007, Office 2010, Office 2013, Power User | Leave a Comment »

« Previous Entries

Next Entries »

	Jeroen Wiert Pluimer… on Pie Comic by John McNamee: Mov…
	Attila Kovacs on Crowbarring Windows 95 into Wi…
	Jeroen Wiert Pluimer… on Does Odido (the old T-Mobile N…
	Lars Fosdal on Security alarm provider Woonve…
	Thomas Mueller on Question got closed in May 202…

The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

Subscribe

Archives

Recent Comments

Recent Posts

Blog Stats

Meta title

Tag Cloud Title

Top Clicks

Top Posts

My badges

Twitter Updates

My Flickr Stream

Pages

All categories

Email Subscription

Archive for the ‘Office’ Category

Office 2011 for Mac update pesky Window pops up every 10 seconds

Mixing x64 Outlook with x86 Delphi: never a good idea…

Fixing PowerPoint Annoyances: When I double-click a .pps/.ppx file, the PowerPoint icon appear on the taskbar…

PowerPoint Opens Minimized

Completely Uninstall Skype For Business (aka Lync) – Skype Community

Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

datetime – Round time to nearest 15min interval in Excel – Stack Overflow

How to group by date in excel? – Super User

Word for Windows Keyboard Shortcut for Find Next – Super User

Deleting Horizontal Lines From Word

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

Subscribe

Archives

Recent Comments

Recent Posts

Blog Stats

Meta title

Tag Cloud Title

Top Clicks

Top Posts

My badges

My Flickr Stream

Pages

All categories

Email Subscription

Archive for the ‘Office’ Category

Rate this:

Share this:

Rate this:

Share this:

PowerPoint Opens Minimized

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this:

Rate this:

Share this: