Friday, July 20, 2018

Reset Excel Profile in Registry

Reset Excel profile in registry if Excel is acting up.
  1. Exit Excel 
  2. Open Registry (regedit)
  3. Browse to \HKEY_CURRENT_USER\Software\Microsoft\Office\15.0 (Office Version 2013)
  4. Right click Excel and rename to ExcelOLD 
  5. Launch a blank Excel and close it to recreate Excel key

Wednesday, March 28, 2018

Unlock worksheet vs unlock workbook

Scenario 1
Unlock worksheet ( file is open but Workbook is protected)
Solution: upload to Google Docs and download as regular Excel file.

Scenario 2
Unlock workbook (unable to get into the file because is password protected) (Source:

"Press ALT   F11 or click on View Code in Developers Tabs
In the visual basic Enter the below Code. Do not change the code just copy paste:

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5:"
You can also click on module one by one (Or on which workbook password is applied) on left side and then paste and press F5.

Thursday, February 1, 2018

Back up CUCM and UNITY to SFTP server on Windows Server

I'm replacing an old Window 2003 server hosting freeFTPd app for Cisco Call Manager and Unity backup files with a Windows 2008 R2 server.

I got the freeFTPd downloaded to the new server but had very hard time to get it to work. CUCM could not communicate with it. WinSCP could not connect to it either. After messing around the firewall settings, I gave it up on freeFTPd.

Then I decided to try the free version of SolarWinds SFTP/SCP server, WOW it only took me few minutes to get the backup to work.

On SFTP server, create the root directory, I also created two sub-folders to separate backup files between CUCM and UNITY.

 Create a new user. The credential will be used in CUCM and UNITY.

 Make sure the SFTP server is running.

On CUCM, go to Disaster Recovery System, create a new backup device.
Host name/IP address: enter the IP of the Windows server running SFTP
Path name: /CUCM (the sub-folder created in the root directory)
Username and password: same credential created in SFTP

It worked much better than the setup with FreeFTPd server based on my experience.

Monday, January 8, 2018

Prevent users accidentally move the top level folders

All top-level folders are shown in the file server share below. To prevent users from accidentally moving or deleting any of the top-level folders, the "Delete" permission needs to be removed.

  1. Right click a top-level folder, Security tab, Advanced, select the user/group and click Change Permissions button, click Edit and un-check allow Delete.

Monday, September 25, 2017

Scan to email using gmail as SMTP on HP printer

Provided by HP Expert, "ShlomiL" on

First, Gmail settings should be made as following:

Port: 465
SSL: Checked.

User and password should be checked, you should use yoru full gmail address as the user and its password.

Additionally, Gmail had recently changed several security options which may block the printer from connecting to their servers.

First open the following link and ensure you are logged on to the same account as you are setting for the printer.

Within the Sign-in & security section click on Signing in to Google and ensure that "2-Step Verification" is set as "Off".

Within the left pane click on Connected apps & sites and ensure that "Access for less secure apps" is set as "ON", otherwise the verification will fail.

Within the left pane click on Device activity & notifications, witin the 'Recent security events' section click the Review events link and ensure there are no blocked connection attempt (it will be highlighted in red) , if there is any alert follow the steps on screen to ensure there is no block for that device.

Thursday, June 1, 2017

Acrobat Error: Unable to access registry

If you received this error message when trying to open a PDF file in IE. THERE IS NO FXXKING FIX. Don't bother to edit the registry or restore the Windows. The only way to fix this problem is to create a new user profile in Windows

Reset Excel Profile in Registry

Reset Excel profile in registry if Excel is acting up. Exit Excel  Open Registry (regedit) Browse to \HKEY_CURRENT_USER\Software\Microso...