Explorer Preview Pane for Excel 2013 crashes!

Recently my Excel crashed and hid itself so there are multiple copies of the same file opened and the old copy overwritten the new copy. Whenever I try to open a file from Explorer, the opened Excel file closes itself and hides in the background! WTF!

Cause

Turns out Microsoft’s turned the preview handler for Excel on by default, and whoever the f***ing guy who programmed this handler chose to do the simple minded thing by simply opening the file in a full Excel limited into the preview pane by the ActiveX control!

Damn. Have they even thought users would normally click on the file in Explorer, which the preview pane opens it in the background when the file is selected/highlighted, just to double click to open it in a full Excel to edit it?!!

Continue reading

Loading

Namecheap SHARED HOST self-migration notes

Here’s the notes for moving from one namecheap hosting to another space yourself while keeping the same domain/settings.

Full backup on cPanel is a lie

A perfect full migration of shared host can only done by namecheap’s customer service. They told you in the doc that you can do a partial migration yourself but it’s not the full picture! Not only the self-service option is more tedious as you have to move the fragments instead processing one big archive file, there is a piece that’s not accessible from the self-service migration route: Calendars/Tasks/Contacts

This means if that ONLY IF you don’t use CardDAV/CalDAV at all, you can do the migration yourself.

Continue reading

Loading

Getting Quickbooks Pro 2019 to work on Windows 10 21H2

Turns out there’s two hurdles to launching Quickbooks as they used some old Windows dependencies

  1. Internet Explorer needed for DLL/ActiveX/DCOM
  2. XPS Writer needed for PDF libraries

In later versions of Windows 10, IE11 was turned off by default, and 21H2 made it difficult to re-enable it by hiding it from Windows’s (optional) features checkboxes, so it needs to be enabled through command line.

If you do not enable Microsoft’s XPS Writer feature, you’ll get this error message about PDF on start, though XPS is Microsoft challenger to PDF so they are not the same thing

Loading

Internet Explorer 11 on Windows 10 21H2

Microsoft has disabled Internet Explorer on later versions of Windows 10 as they really want people to use Microsoft Edge. However, disabling Internet Explorer 11 might break some software such as Quickbooks 2019, which relied on old fashioned DLLs.

Since 21H2, Microsoft went the extra mile preventing users from re-enabling Internet Explorer 11 by hiding it from GUI ways to turn Windows features on or off (whether you use the app mode interface or the classic optionalfeature.exe interface launchable from control panel’s “Programs and Features”). Instead this needs to be enabled from the command line

https://learn.microsoft.com/en-us/troubleshoot/developer/browsers/installation/disable-internet-explorer-windows

dism /online /Add-Capability /CapabilityName:Browser.InternetExplorer~~~~0.0.11.0.

or

dism /online /Enable-Feature /FeatureName:Internet-Explorer-Optional-amd64.

Loading