2023-04-05

Count files in a folder from Command Prompt / PowerShell

  • Command prompt 
    • dir *.* /a-d | find "File(s)"
    • dir *.* /b /a-d | find /c /v ""
  • PowerShell
    • (Get-ChildItem C:\csv -filter "*.*").Count
    • (Get-ChildItem C:\csv -recurse -filter "*.*").Count recursive search
    • (Get-ChildItem C:\csv -filter "*.*").Count
    • [System.IO.Directory]::GetFiles("c:\Path").Count

2023-01-05

Store location of the opened tabs from Chrome browser / Restore opened tabs from Chrome

Go the the following location:
%userprofile%\AppData\Local\Google\Chrome\User Data\Default\Sessions

To restore your opened tabs to another PC or user copy the files in this locatation to your new device:
Session_*.* and Tabs_*.*

2021-12-10

Fix blank screen for users on Windows 10

Open Services with elevated privileges and disable the App Readiness service

Restart required

2021-12-02

Color line if condition meet in Excel

To color a line if a cell has a specified value go to:

  • Conditional Formatting
  • New Rule
  • Use a formula to determinate witch cells to format
    • Format values where this formula is true
      • select the cell with the desired value and enter the condition
      • select the formatting you want (background color)
      • select the whole table

Example:
We have a table with column A to Z and we want to color each row if the cell from column S has the value "Shipped"
Formula should be: =$S1="Shipped" and Applies to =$A:$Z

2021-11-15

Fix Sentinel HASP error "hardlock.sys" file (null) processing error ... Status Code 12 4 2217 31

 Fix Sentinel HASP error:

"hardlock.sys" file (null) processing error. this is an internal error. For assistance contact your administrator or the software manufacturer.

Status Code 12 4 2217 31

Open registry editor

go to HKLM\SYSTEM\CurrentControlSet\Services\Hardlock

set Start=4

2021-07-27

How to search for special characters in files or folders from Windows Explorer

If you want to find a special character in a filename or folder go to the searchbox and type:

~="@"

This will find any file or folder containing the @ character

2021-04-12

Change wireless network priority from command line

Open a command prompt and enter:

netsh wlan set profileorder name="NetworkName" interface="Wi-Fi" priority=1

Delete network profile / wifi connection from command prompt

Open a command prompt and run the following command:

netsh wlan delete profile name=SSID

If you get the following error:

You do not have sufficient privileges or the profile "YourProfile" on interface "wifi" is a group policy profile.
then try this:
  • stop the WlanSvc service (WLAN AutoConfig)
  • delete all files in the \Windows\wlansvc\Policies folder
  • try again to delete the profile
    • netsh wlan delete profile name=SSID
  • restart the WlanSvc service

2021-02-15

Inkscape save default document properties

  • create a new document
  • go to Document Properties and adjust your settings
  • save as default.svg in %userprofile%\AppData\Roaming\inkscape\templates

2021-01-19

Add a network printer & Set a default printer in VBScript

Set WshNetwork = WScript.CreateObject("WScript.Network")
WSHNetwork.AddWindowsPrinterConnection "\\ServerName\PrinterName"
WSHNetwork.SetDefaultPrinter "\\ServerName\PrinterName"

Open Devices & Printers in VBScript

CreateObject("WScript.Shell").Run "control.exe /name Microsoft.DevicesAndPrinters"

2021-01-04

Disable ask for password after sleep

Windows 10:

Go to Settings > Accounts > Sign-in Options > Require sign-in and select Never

2021-01-02

Windows Error Reporting folder location

The Windows Error Reporting folder location can be found here:

%LOCALAPPDATA%\Microsoft\Windows\WER

All files inside this folder can be deleted

fix GRUB missing in Windows/Linux dual-boot

Open a command prompt with elevated rights (run as admin) and run:

bcdedit /set {bootmgr} path \EFI\ubuntu\grubx64.efi

To restore to previous settings run:

bcdedit /deletevalue {bootmgr} path \EFI\ubuntu\grubx64.efi delete grub boot

bcdedit /set {bootmgr} path \EFI\Microsoft\Boot\bootmgfw.efi set windows boot

List installed printers from command line / PowerShell

Open a command prompt and run:

wmic printer list brief

Open PowerShell and run:

Get-Printer | Format-List list printers with details

Get-Printer | Format-List Name list printers names

2020-12-29

How to change icon size of the dock in Ubuntu / Unity

To change the size of the Dock icons go to:

Settings > Appereance > Dock > Icon Size

2020-12-02

Disable ask for password after suspend in Ubuntu

Run in the terminal:

gsettings set org.gnome.desktop.screensaver ubuntu-lock-on-suspend false

2020-12-01

Add Chrome shortcut for more profiles on desktop

1. Create a file named User.desktop

2.Edit the file:

#!/usr/bin/env xdg-open
[Desktop Entry]
Version=1.0
Type=Application
Terminal=false
Icon[en_US]=google-chrome
Exec=google-chrome --profile-directory=Profile\ 1
Name[en_US]=User
Name=User
Icon=google-chrome

3. Move the file on the desktop

4. Right click on he file and select "Allow Launching" 

5. Double click on the file to start chrome with your profile

2020-11-03

Dell Diagnostic Error Codes

Blinking Pattern

Possible Problem Problem Description
AmberWhite
2
1
CPU CPU failure
2
2
BIOS ROM failure System board failure (included BIOS corruption or ROM error)
2
3
Memory No memory/ RAM detected
2
4
Memory Memory/ RAM failure
2
5
Memory Invalid memory installed
2
6
Chipset System board/ Chipset error
2
7
LCD LCD failure
3
1
RTC power failureCMOS battery failure
3
2
PCI/ Video PCI or Video card/ chip failure
3
3
BIOS recovery 1Recovery image not found
3
4
BIOS recovery 2Recovery image found but invalid

2020-10-21

Excel print to pdf gets the error mandatory field empty

This error occurs when you click on Enable content.

To solve this, you have to go to

Options > Trust Center > Trust Center Settings > Trusted Documents

and click on the Clear button