This function returns the pattern in the second parameter, where the characters not present in the range specified in the first parameter are replaced with the third parameter. 1Function ReplaceMissingCharacters(range As Range, pattern As String, replacement As String) As String 2 Dim car As String 3 Dim i As Integer 4 …

Read More

The objective of the Certiphyto Genius application is to help you analyze the official Certiphyto exam reports and generate individual certificates of success for the exam, allowing successful candidates to request their certificate.

Read More

The goal of this post is to explain how to save data in user's google drive storage. Prerequisites It's probably better to know how OAuth2 and HTTP works. OAuth2 is an Authorization framework. So it manages the keys to access a protected area. The most important thing about HTTP in our situation is how to upload data, …

Read More

The goal of this post is to explain how to handle updates on extremely large database tables. Prérequis Modifications are not atomic, which means you don't need to make sure all modifications are completed or none are. When should I use it ? 1.000 rows: You should have that in mind 1.000.000 rows: You start stressing …

Read More