— iIT-Services

Archive
Programming

Zapier is an online automation tool that connects your favorite apps, such as Gmail, Slack, Mailchimp, and more. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration. It’s easy enough that anyone can build their own app workflows with just a few clicks.

For example, maybe you get a lot of email attachments in your Gmail account and you want to save them to Dropbox. Every time you get an attachment, you could open up the email, click the attachment, and then save it to Dropbox. Or you can have Zapier automate this for you, saving you time and effort: zapier.com.

Read More

Useful websites (collection by Labnol) on the Internet to increase productivity and help learn new skills. These useful websites solve at least one problem really well. And they all have cool URLs that are easy to memorize thus saving you a trip to Google: https://www.labnol.org/internet/101-useful-websites/18078/.

Read More

An open source and collaborative framework for extracting the data you need from websites. In a fast, simple, yet extensible way.

This free, open source tool uses web crawlers to extract information from websites. Using this tool does require some advanced skills, and coding knowledge. However, if you are willing to work your way past the learning curve, Scrapy is ideal for large web extraction projects. Because it is an open source tool, there is a lot of good community support available to users: https://scrapy.org/.

Read More

Protecting MS Excel Worksheets with passwords can be user-friendly. No one fiddles with the configuration. Yet, if you need to administer the sheets, lost passwords are a pain. So, in case you need to unprotect a sheet – and obviously only if you have the right to do so! – the folling VBA code snippet can help:

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

 
Just open the VBA editor ([Alt]+[F11]), copy the snippet into a new VBA Module of the Excel worksheet, and execute (Run or [F5]).

Credits to: https://www.iseepassword.com/crack-ms-excel-password.html#part1

Read More

A secure solution for file and email encryption. Gpg4win (GNU Privacy Guard for Windows) is Free Software and assists in sending emails via Outlook etc. using PGP: gpg4win.de.

Read More

Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. Git is easy to learn and has a tiny footprint with lightning fast performance. It outclasses SCM tools like Subversion, CVS, Perforce, and ClearCase with features like cheap local branching, convenient staging areas, and multiple workflows: git-scm.com.

Read More

This site’s mission is twofold: to analyze the world of data science, and to help people learn to use R. R is free, open source, software for data science that is similar to the “big three” commercial packages: SAS, SPSS, and Stata: http://r4stats.com.

Read More