Skip to main content

Posts

Showing posts from 2018

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

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.