Welcome To Snipplr


Everyone's Recent Visual Basic Snippets



« Prev 1 2 3 4
  1. FAV

    [vba-basic] convertir des nombres en lettres (french) V2

    convert numbers to letters (french) V2
    Visual Basic 55 views posted 6 months ago by martinbrait
  2. FAV

    [vba-basic] convertir des nombres en lettres (french) V1

    convert numbers to text (french) V1
    Visual Basic 53 views posted 6 months ago by martinbrait
  3. FAV

    [vba-excel] lister dossiers et sous-dossiers d'un répertoire

    How to list directories and subdirectories in an excel sheet ?
    Visual Basic 13 views posted 6 months ago by martinbrait
  4. FAV

    [vba-excel] lister tous les fichiers répertoires et sous-répertoires

    How to list files in directories and subdirectories ?
    Visual Basic 8 views posted 6 months ago by martinbrait
  5. FAV

    [vba-excel] lister fichiers avec détails, dans une feuille excel

    How to list files, with details, in an excel sheet
    Visual Basic 11 views posted 6 months ago by martinbrait
  6. FAV

    [vba-excel] lister fichiers dossiers, et sous-dossiers

    How to list recursively files, in an excel sheet ?
    Visual Basic 11 views posted 6 months ago by martinbrait
  7. FAV

    [vba-excel] lister le contenu d'un répertoire dans une feuille

    How to list files from a directory ?
    Visual Basic 13 views posted 6 months ago by martinbrait
  8. FAV

    [vba-basic] retrouver une valeur dans un tableau

    rechercher une valeur dans une variable tableau (Array) en VBA Find some value into an array
    Visual Basic 11 views posted 6 months ago by martinbrait
  9. FAV

    [vba-access] liste des requêtes d'une base access

    List of access database queries Pour tester, ouvre la fenêtre de Debug (CTRL G), et tapes-y 'ListeRequetes' et appuye sur la touche [Entrée].
    Visual Basic 12 views posted 6 months ago by martinbrait
  10. FAV

    [vba-access] Peupler un tableau avec le retour d'un recordset

    How to populate an array with recordset data
    Visual Basic 9 views posted 6 months ago by martinbrait
  11. FAV

    [vba-basic] Copier un fichier vers une archive existante

    Le code suivant vous permet de copier un fichier (par exemple un document Word ou un PDF) dans une archive existante. Cela implique que le fichier original sera ajouté à l'archive mais restera également dans sa forme originale (non-compressée) à l'en...
    Visual Basic 9 views posted 6 months ago by martinbrait
  12. FAV

    [vba-basic] Archiver/compresser un fichier avec VBA

    Il suffit d'indiquer le nom du fichier à archiver et le nom de l'archive. Par défaut, si l'archive mentionné existe déjà, la macro va l'effacer avant de le recréer. Archive / compress a file with VBA
    Visual Basic 9 views posted 6 months ago by martinbrait
  13. FAV

    [VBA-EXCEL] Lister les fichiers d\'un répertoire donné

    Comment lister tous les fichiers d'un répertoire dans un fichier excel ? Excel (VBA) list all filenames in a directory mastipro
    Visual Basic 10 views posted 6 months ago by martinbrait
  14. FAV

    Read data from txt files

    Read data from TXT files to import them in Excel environment
    Visual Basic 28 views posted 2 years ago by buglilorenzo
  15. FAV

    Example of VB6 Sample SMS Code - Messaging API

    The following example of VB6 sample SMS code uses an expedient object, contingent on the HTTP API.
    Visual Basic 33 views posted 2 years ago by Broadnet
  16. FAV

    Excel (VBA) worksheet password cracker (Ver 2010 & below)

    If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
    Visual Basic 13 views posted 3 years ago by cueballrawn
  17. FAV

    Excel (VBA) drop down list multiple values in single cell

    Selecting different values from a data validation drop down list will populate the same cell, i.e. it will create a concatenating list separated by commas. Amend the "If Target.Column" values to set the columns this applies to.
    Visual Basic 17 views posted 3 years ago by cueballrawn
  18. FAV

    Excel (VBA) Custom right-click menu to launch macros

    Create a custom right-click menu that will list and launch all macros in the DemonstationMacros module. Copy and past the code into the relevant object or module.
    Visual Basic 17 views posted 3 years ago by cueballrawn
  19. FAV

    Access (VBA) Import CSV files into database

    Import CSV files into a named table in Access database. Use to bulk load tables.
    Visual Basic 16 views posted 3 years ago by cueballrawn
  20. FAV

    Excel (VBA) list all filenames in a directory

    Lists all filenames in a directory if you need them for formulae or add into VBA.
    Visual Basic 13 views posted 3 years ago by cueballrawn
  21. FAV

    Excel (VBA) Hash string using SHA1 - pseudonymisation

    Create a bespoke Excel function that allows you to hash (anonnymise / pseudonymise) strings such as unique identifiers. Once you've inserted the VBA, use the function "=BASE64SHA1(cellreference)" to generate the hash.
    Visual Basic 45 views posted 3 years ago by cueballrawn
  22. FAV

    Excel (VBA) create list of all worksheet names in workbook

    This inserts a new column in the active worksheet and lists all the worksheet names, using a row for each name. Useful if you have lots of worksheets names that you want to reference accurately.
    Visual Basic 18 views posted 3 years ago by cueballrawn
  23. FAV

    Access (VBA) Open and run macro from an Excel workbook

    This code allows you to open an Excel workbook from an Access database and run macros within the target workbook. This could be used to format / clean data prior to import for example.
    Visual Basic 15 views posted 3 years ago by cueballrawn
  24. FAV

    Excel (VBA) hide specific worksheets

    Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
    Visual Basic 12 views posted 3 years ago by cueballrawn
  25. FAV

    Excel (VBA) unhide all worksheets

    VBA to unhide all worksheets in an Excel workbook.
    Visual Basic 13 views posted 3 years ago by cueballrawn
  26. FAV

    Generate SQL query for column matching

    Written as reply to question on ittoolbox.com:"I need to execute a query in vb which can find multiple value provided by the user to find from a single column of a table." [http://database.ittoolbox.com/groups/technical-functional/sql-l/query-to-fin...
    Visual Basic 12 views posted 4 years ago by bvwatson
  27. FAV

    Calculate the Center Moving Average

    Calculates the center moving average for a time period. The vA requires a range or an array of numbers and the iSteps takes the number of periods in the timeframe (4 for quarters, 7 for weekly, ect)
    Visual Basic saved by 9 people 13 views posted 4 years ago by BDOGG32
  28. FAV

    Extract text from a String

    Two functions that can extract text from a string. Must have the Option Compare Text at the top of the module.
    Visual Basic saved by 2 people 13 views posted 4 years ago by BDOGG32
  29. FAV

    StripCharacters

    Uses regular expressions to do string manipulation. Enter a regular expression into the required parameter and what you want the manipulation to do and it will process the string manipulation. For example if A1 contains John Doe1, Jane Doe2, John W...
    Visual Basic saved by 32 people 11 views posted 4 years ago by BDOGG32
  30. FAV

    SpeedOn and SpeedOff

    Code to turn certain feature off and on for faster running of code in Excel
    Visual Basic saved by 1 person 14 views posted 4 years ago by BDOGG32
« Prev 1 2 3 4