Unable to Share files from OneDrive for Business in File Explorer

The error is "Sorry, we're unable to reach the server right now. Please try again later."

The solution is to uncheck "Do not save encrypted pages to disk" in IE, Internet Options/advanced tab.

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

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:https://community.spiceworks.com/topic/328118-need-to-unlock-a-password-protected-excel-2010-workbook?page=5)

"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.

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.

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.

Steps:

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.

Scan to email using gmail as SMTP on HP printer

Provided by HP Expert, "ShlomiL" on https://h30434.www3.hp.com/t5/LaserJet-Printing/Scan-to-email-using-gmail-as-SMTP/td-p/5388877

First, Gmail settings should be made as following:

SMTP: smtp.gmail.com

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.
https://myaccount.google.com/

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.

Fxxk Ya!

Nothing. Just wanted to vent!