cueballrawn


Member since 10/29/2012

10 snippets

5 profile views

View their favorites

their Tags


Profile

All time reputation: 82

Achievement

first submission:submitting first snipplet

cueballrawn's Recent Snippets



« Prev 1 Next »
  1. 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 5 views posted 3 years ago cueballrawn
  2. 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 4 views posted 3 years ago cueballrawn
  3. 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 4 views posted 3 years ago cueballrawn
  4. 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 4 views posted 3 years ago cueballrawn
  5. 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 4 views posted 3 years ago cueballrawn
  6. 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 9 views posted 3 years ago cueballrawn
  7. 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 6 views posted 3 years ago cueballrawn
  8. 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 5 views posted 3 years ago cueballrawn
  9. 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 2 views posted 3 years ago cueballrawn
  10. FAV

    Excel (VBA) unhide all worksheets

    VBA to unhide all worksheets in an Excel workbook.
    Visual Basic 4 views posted 3 years ago cueballrawn
« Prev 1 Next »