Christophe Avonture

My blog as accessible on https://www.avonture.be

GitHub Profile page

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

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

Tutorial about Visual Studio Code and tips and tricks

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

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

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.

📝 You’re taking a lot of notes and need a solution to manage them i.e. put your knowledge base in one central place and being able to retrieve quickly information’s, display them nicely through the browser as a HTML page or a slideshow, export them in many file formats (docx, odt, pdf, txt, …). Sensitive information’s can be encrypted and notes can be edited online.

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

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.

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

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

MS Access snippets

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

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

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

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

Tips and tricks on how to write powerfull bash scripts

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

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

Programmer's guide to creating a Ribbon for MS Excel

Tips and tricks and snippets of PowerShell functions

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.

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

Very straight-forward script for formatting SQL statement.

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

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.

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

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