The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,364 other followers

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 | 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 [WayBackemail – MAPI Windows 7 64 bit – Stack Overflow answer by [WayBack] epotter is very insightful (thanks [WayBackRik 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 [WayBack1. 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:

  1. Run appwiz.cpl
  2. Select the Microsoft Office version you have installed
  3. Right click, then choose Change
  4. Choose “Add or Remove features” then “Continue”
  5. Choose the dropdown left of “Microsoft Lync” or “Microsoft Office”, then click “Not Available” and click “Continue”
  6. 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

 

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 »

 
%d bloggers like this: