Profile
Achievement
cueballrawn's Recent Snippets
- All /
« Prev 1 Next »
If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
0
4092
posted 9 years ago by cueballrawn
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.
0
4356
posted 9 years ago by cueballrawn
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.
0
4359
posted 9 years ago by cueballrawn
Import CSV files into a named table in Access database. Use to bulk load tables.
0
4330
posted 9 years ago by cueballrawn
Lists all filenames in a directory if you need them for formulae or add into VBA.
1
4276
posted 9 years ago by cueballrawn
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.
0
8862
posted 10 years ago by cueballrawn
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.
0
4286
posted 10 years ago by cueballrawn
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.
0
4200
posted 10 years ago by cueballrawn
Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
0
3865
posted 10 years ago by cueballrawn