Suprajathvam: March 2020

Tuesday 31 March 2020

Macro to Crack the Password of a Protected Sheet

Sub PasswordBreaker()
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

Credit: http://www.excelsupersite.com/how-to-unprotect-an-excel-spreadsheet-if-you-have-lost-your-password/

Thursday 12 March 2020

Have You Heard About These Modern Lendors?

1. Tachy loans

About:

Tachy loan is an online platform launched by FinMomenta Pvt Ltd that facilitates P2P lending. It was founded in the year 2016 with its headquarters at Bengaluru. The platform connects prospective lenders with credible borrowers.

Products

v Loans for School Education

v Loans for Online Training & Professional Courses

v Loans for Skill Development Courses

v Personal loans

Features:

v At Tachyloans, Education loans are available for salaried individuals and self-employed professionals/ businesspeople.

v Through Tachyloans, enders can highlight their investment preference and choose the person they wish to provide unsecured personal loans to.

v The interest rates on Tachyloans range from 11.5% to 25% depending on the FinMomenta credit rating.

v Lenders and borrowers can negotiate in a 3-day window, on loan tenure, interest rate, and principal amount.

https://www.tachyloans.com/

2. Neev

About

Neev Credit Private Limited is an NBFC with operations across six cities viz., Bengaluru, Kolkata, Mumbai, Pune, Nagpur and Hyderabad. The NBFC finances education fees for pre-schools, schools, colleges, tuition centres and other academic centres.

Features:

v The NBFC is exclusively engaged in lending for K12 education.

v The loan amount ranges from ₹ 30,000 to ₹ 200,000 per annum.

v They charge interest at a rate ranging from 3% to 5%.

v In 2016, Neev Finance has signed an MoU with Ola Cabs to finance the school fees of the driver’s children.

Neev has collaborated with 300+ educational institutions wherein students studying at these institutes are being financed by Neev.

https://www.neevfinance.com/