cueballrawn


Member since 10/29/2012

10 snippets

2090 profile views

0 Comment(s) Posted

View their favorites

their Tags


Profile

Achievement

first submission:submitting first snipplet popular snippet:having a snipplet with 20 favorites

cueballrawn's Recent Snippets



« 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 1167 posted 8 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 1184 posted 8 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 1238 posted 8 years ago by cueballrawn
Import CSV files into a named table in Access database. Use to bulk load tables.
0 1383 posted 8 years ago by cueballrawn
Lists all filenames in a directory if you need them for formulae or add into VBA.
1 1184 posted 8 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 4939 posted 8 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 1221 posted 8 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 1216 posted 8 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 998 posted 8 years ago by cueballrawn
VBA to unhide all worksheets in an Excel workbook.
0 1086 posted 8 years ago by cueballrawn
« Prev 1 Next »