Discover cavo789/excel_tips Open Source project

SQL Server to Microsoft Excel. VBA class for Excel to make easy to access records stored in SQL Server and output these data in an Excel sheet; keeping or not the link

vba_excel_sql

Tutorial about Visual Studio Code and tips and tricks

vscode_tips

Just like me, you write Excel macros and you want a simple way to export your code as text files to your hard disk so that you can manage versions and load the code into e. g. GitHub? My vba_excel_export_code script is made for you. From now on it also manages the export of your ribbon.

vba_excel_export_code

xyPlorer is a tremendous software; 10k time better than the prehistoric Windows Explorer. This repo to store and share own scripts

tools_xyplorer

Tips and tricks and small scripts for automation of the WinSCP FTP client (Windows).

tools_winscp

Some tips and tricks for your .htaccess file (Apache)

htaccess

vbs_classes

VBS scripts and classes that will help Windows users to collect a list of files based on extensions and utilities to work with Access, Excel and SQL Server

A set of php scripts that will probably be useful to you in your life as a webmaster, including, for example, check_db (for quickly check your Joomla's configuration), kill_db_tables for removing tables based on a prefix, ...

joomla_free

Small, stand alone and straight forward VBS scripts for working with emails, files, folder, ...

vbs_utilities

vba_access

MS Access snippets

PHP script to install on your site (preferably in localhost for better performance) to scan files for viruses. aeSecure QuickScan already RECOGNIZE MORE THAN 45.000 VIRUSES (November 2018) and use whitelist hashes to avoid to scan WordPress and Joomla native files (all versions). Thanks these hashes aeSecure QuickScan already detect more than 700.000 files as healthy.

aesecure_quickscan

Proof of concept - Encrypt markdown files and store encrypted version on github

markdown_encrypt

Tips and tricks when writing batch for MS DOS, mainly functions.

dos_batch_tips

Utility to convert .docx and .odt to markdown. Script for Windows.

marknotes_convert

How to call a web service in Excel VBA. The example is built using the European Union's VIES CheckVAT web service.

vba_excel_call_webservice

Easy interface for generating a hash for a plain text password. Type a plain text password and get his password_hash() hash.

php_password

Tips and tricks on how to write powerfull bash scripts

bash_shell_coding

Fork of the getjoomla script of BestProject (https://github.com/bestproject/getjoomla.php)

getjoomla

Quick HTML to markdown converter

marknotes_html2md

Very straight-forward script for formatting SQL statement.

sql_formatter

This script will allow you to scan files of your website and search for a specific pattern; f.i. a word or a sentence.

php_grep

Programmer's guide to creating a Ribbon for MS Excel

excel_ribbon

Get the list of repositories of someone and, repo by repo, check if a clone is already present on disk; if not, make a clone

github_clone_all

You've forgot your Joomla admin credentials but you 've access to your FTP? The log_admin.php script will allow you to connect in your administrator interface without the need to fill in credentials.

joomla_log_admin

Installation script for marknotes (https://github.com/cavo789/marknotes). Download the latest version of the tool, install it, finalize the installation and it's yours !

marknotes_install

Take a copy of the Chrome bookmarks on a Virtual Machine and copy them on your physical computer.

backup_chrome_bookmarks

phpmenu

My configuration files

Connect to SQL Server, iterate every tables and generate a .csv file by table containing the table's structure

vbs_sql_sp_columns

Tips and tricks and snippets for working with Git

git_tips

Script and utilities to make life with Git easier

tools_git_scripts

Encrypt/decrypt files using Docker and OpenSSL

docker_ssl_encrypt

Loop all images in a folder and insert them in a worksheet, one image by row

vba_excel_image_gallery

A very simple json beautifier

jsonlint

Excel raw table to markdown converter

marknotes_xls2md

Simple javascript base64_encode / base64_decode interface

base64

Tips and tricks and snippets of PowerShell functions

powershell_tips

Import code to an Excel workbook, import .bas, .cls and .frm files

vbs_xls_import_code

How to very easily load an Excel range into the ribbon as a dropdown

oh-my-zsh-tips

Somes tips for Oh-my-zsh

vba_excel_RibbonDropdown

CSV to markdown converter

marknotes_csv2md

Retrieve the list of references used in an Excel file (.xlam files f.i.) and display them on the console. Loop and process all Excel files in the current folder

vbs_xls_list_references

Improves the readability of Excel formulas. Display long formula into a nice HTML output

excel_formatter

mod_agency is a module for the Joomla backend and will display informations about the web agency who's responsible for the site. Name, URL, phone number, email, skype, ... of the person in charge of the daily maintenance of the site. mod_agency has been developped by the JUG Wallonie (http://www.jugwallonie.be)

joomla_mod_agency

On every Windows startup use a new background image directly downloaded from Unsplash

npm_unsplash_background

A few markdown tips and tools

markdown-tips

Remove VBA password required for viewing code in MS Office documents

vba_decrypt

Very fast way to remove every files in a folder (subfolders included)

kill_folders

Loop any SSIS packages and export the flatfiles connection managers to csv files. Very usefull for getting the description of files and add them, f.i., in your technical documentation.

ssis_export_flatfiles_spec

The idea of these scripts are simple: make easier to work with `.json` files.

json-tools

_skeleton

Project skeleton

Some helpers to develop faster in PHP 7

php_helpers

Some tips & tricks for Docker and docker-compose

docker_tips

Very straight-forward script for encoding string in JSON

json_encode

Some tips & tricks for bash

bash_tips

List of some software I use in software development

uses

vbs_transport

Transport DEV.xlsm to PROD.xlsm and update addins references

Visual Basic

folder_size

Do you know the size of your website? How many megabytes/gigabytes?

**Personal learning** application to understand VueJS using a step by step approach. Demo are available online.

test_vuejs

Export every code objects of a MS Access database (forms, macros, modules and reports code) to flat files, in a batch mode

vbs_access_export

Some tips & tricks and snippets for javascript

javascript_tips

docker_joomla

Support pour la session Docker lors du JoomlaDay FR 2022 (https://www.joomladay.fr/)

HTML

check_mod_rewrite

Simple script to check if mod_rewrite is enabled or not; not using php_info but a htaccess redirection.

Hack

php_obfuscator

Utility allowing to make a PHP code unreadable but leaving it perfectly executable.

VBA macro for trying to retrieve worksheets in a corrupt Excel file

vba_excel_import_sheets

Need a simple script to take an archive of your website. The repository contains a script to create a ZIP archive of a website (or part of it).

zip_unzip

VBS script for extracting every stored procedure from SQL Server databases into flat files on disk

vbs_sql_extract_stored_proc

Small demo on how to run a UPDATE query on a worksheet

vba_excel_dataquery_update

PHP class that encapsulates pandoc in order to convert a text in markdown format to doc/odt/pdf/txt/…

pandoc

Some useful commands to run in the PowerShell console

powershell_commands

docker_laravel

Easy instructions to install a fresh Laravel site and dockerize it

Dockerfile

avonture

My homepage website (https://www.avonture.be)

This is an Outlook macro for creating a rule to send emails to the trash (fight against spam)

vba_outlook_CreateRuleSendToTrash

Est-ce que mon site a été hacké ? Est-il propre ? Comment m'en assurer ? (French slideshow on how to check if our website is hacked)

aesecure_slides_hacked

CSS

vba_outlook_save_pdf

Do you need to export one or more emails to your hard disk as PDF files and remove these emails (or not) once done ? Here is my Outlook macro for this. My usage: take a copy of all important emails on my hard disk for archiving and backup on external disk. Once the backup is completed, the emails are deleted.

Interface that allows you to analyze the log of web access to your site's resources and highlight URL attack attempts. Originally, this script was only intended for my personal use; that's why the interface is not necessarily the easiest to use. The tool is intended to be an aid in log analysis to e. g. understand how a website was attacked, by whom and how.

apache_logreader

This script will establish a connection to a MySQL database, retrieve all tables and document them by creating `.csv`, `.md` and `.sql` files. If you're using [Marknotes](https://github.com/cavo789/marknotes), it'll also create the full documentation folder for Marknotes.

db_documentor

postgrest

Very straightforward script to dump a MySQL database and import it back; locally f.i.

db_dump

Collection of PHP tips and tricks

php_tips

Search for specific content in the wp_options table and allow to remove the value

windows_terminal_tips

Windows Terminal Tips

aesecure_clean_wordpress_options

A few hooks written in Bash for Git

bash_git_hooks

VBA code to enhance the use of Outlook and mainly fight against spam, automatically assign emails to categories, ...

vba_outlook_fight_against_spam

Visual Basic

composer-addon-vscode

This little utility will help you when writing and maintaining your composer.json file

vbs_xls2scv

Convert Excel worksheets to csv files in batch

Quick markdown to HTML converter: type your markdown, convert in HTML and copy in the clipboard, it's done.

marknotes_md2html

Find duplicated files on disk between folder A and B and remove them in folder B.

ps_remove_duplicates

Some tips & tricks for Dos

dos_tips

Scan the current folder, open every .txt files, count the number of lines and display a summary

vbs_count_lines

Various tools around the Markdown language such as a markdown to doc/html/pdf converter, from csv/html to markdown, ...

markdown

Présentations de la JUG Wallonie (https://jugwallonie.be)

slides_jugw

CSS

laravel_tips

Collection of Laravel tips and tricks, including some files like artisan command

Tips for optimizing an MS Access database without any migration to SQL Server

msaccess_optimize

**Personnal learning** Play with Python and Docker

docker_python

chmod

Reset folder's permissions to 755 and 644 for files, this for the folder where the script is stored and any subfolders

Some source code from the time when I was studying computer science and already spent a good part of my evenings and weekends behind the computer.

swag

Pascal

apache_log_concat

Read all apache logs and create a new file with only lines matching a given regex pattern

Tips on how to install Windows Subsystem for Linux

wsl_tips

100

wamp_tips

Some tips & tricks for wamp