Skip to main content

Posts

Unlock worksheet vs unlock workbook

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

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.…
Recent posts

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 wor…

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: 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…

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.

Just great!