Disable APIPA (Automatic Private IP Addressing)

APIPA (Automatic Private IP Addressing) – Mechanism in a small network that clients will automatically allocated themselves an IP address in the range of 169.254.x.x if no DHCP server can be contacted.


It may be desirable to disable this and to do this perform the following:

  1. Start the registry editor (Regedit.exe)
  2. Move to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\Interfaces
  3. Select the required interface
  4. From the Edit menu select New – DWORD value
  5. Enter a name of IPAutoconfigurationEnabled and press Enter
  6. Double click the new value and set to 0. Click OK
  7. Close the registry editor


If you have multiple adapters and wish to disable for all just create and set HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\IPAutoconfigurationEnabled to 0.

Unprotect/Remove Excel Password

  1. Change the extension of you Excel file from .xlsx to .zip
  2. Extract these XML files outside the folder,they represent the worksheets in the Excel file.
    1. Location: xl -> worksheets -> *.xml
  3. Modified codes using simple “Notepad”.
    1. Open XML File & Delete  Excel v. 2007-10 “sheetProtection password=… />” v. 2013 – “sheetProtection algorithmName=…/>”
  4. Save & Close Xml File
  5. The modified XML file should be put again in the zipped file to replace the old XML files.
  6. Run File

VLC for openSUSE

VLC VideoLan client
VLC Repositories for openSUSE contains all the required libraries that are not shipped with original openSUSE. (VLC is also provided by Packman, do not add both repositories.)
Version: Tumbleweed http://download.videolan.org/pub/vlc/SuSE/Tumbleweed/
Version: Leap 15.0 http://download.videolan.org/pub/vlc/SuSE/Leap_15.0/
zypper dup:
After adding VLC repository be sure to switch system package to those in VLC as a mix of both can cause a variety of issues.
Version: both zypper dup –from SuSE –allow-vendor-change


Credits: https://en.opensuse.org/Additional_package_repositories#VLC_VideoLan_client

System file check to look for corrupt files.

Right click at Start button > click Command Prompt (Admin) > at the flashing prompt, copy/paste this…….
sfc /scannow

> press Enter.
It will take quite sometime.
When finished, it will give you one of the 3 reports……………(paraphrasing)
1. No integrity violation.
2. Found corrupt files and repair successful.
3. Found corrupt files but unable to repair.

If the report is #1, your solution lies elsewhere.
If the report is #2, check if your problems have been resolved.
If the report is #3, use this method…………….
In the same Command Prompt (Admin) windows, copy and paste this command………..

dism /online /cleanup-image /restorehealth

> press Enter.
Again it will take some time.



Why don’t I have the option to “continue to website (not reccomended)” when I encounter a website with a certificate error IE?

If you are launching from a pinned site or desktop shortcut you don't get the option to continue.  

Around that by creating a shortcut to IE on the desktop with 'run as administrator' privileges and passing the website in the command line. 

Like "C:\Program Files\Internet Explorer\iexplore.exe" https:\\



Merge PDF Files In Command Line On Linux

  • PDFtk (PDFtk is available in the AUR. You can install it using packer or yaourt front-ends.)
pdftk file1.pdf file2.pdf fiel3.pdf cat output outputfile.pdf
pdftk *.pdf cat output outputfile.pdf
  • Poppler (Poppler is a PDF rendering library based on the xpdf-3.0 code base.)
pdfunite file1.pdf file2.pdf file3.pdf outputfile.pdf


Gigolo is a frontend to easily manage connections to local and remote filesystems using GIO/GVfs. It allows you to quickly connect/mount a remote filesystem and manage bookmarks of such.