-
Read data from TXT files to import them in Excel environment
Visual Basic
24 views
posted 2 years ago by buglilorenzo
-
The following example of VB6 sample SMS code uses an expedient object, contingent on the HTTP API.
Visual Basic
6 views
posted 2 years ago by Broadnet
-
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 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.
Visual Basic
4 views
posted 3 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.
Visual Basic
4 views
posted 3 years ago by cueballrawn
-
Import CSV files into a named table in Access database. Use to bulk load tables.
Visual Basic
4 views
posted 3 years ago by cueballrawn
-
Lists all filenames in a directory if you need them for formulae or add into VBA.
Visual Basic
4 views
posted 3 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.
Visual Basic
9 views
posted 3 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.
Visual Basic
6 views
posted 3 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.
Visual Basic
5 views
posted 3 years ago by cueballrawn
-
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 by cueballrawn
-
VBA to unhide all worksheets in an Excel workbook.
Visual Basic
4 views
posted 3 years ago by cueballrawn
-
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
5 views
posted 4 years ago by bvwatson
-
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
7 views
posted 4 years ago by BDOGG32
-
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
6 views
posted 4 years ago by BDOGG32
-
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
7 views
posted 4 years ago by BDOGG32
-
Code to turn certain feature off and on for faster running of code in Excel
Visual Basic
saved by 1 person
10 views
posted 4 years ago by BDOGG32
-
'
'
' 1, Create your cex.io account from https://cex.io/r/0/rbillig/0/ ( mandatory )
' 2, Tranfer Bitcoins to you account
' 3, Under your CEX account, create a public and secret key
' 4, Modify the 3 vars below ( G_USERNAME, G_APIKEY...
Visual Basic
10 views
posted 6 years ago by rbillig
-
Example to change the selected item in a ComboBox, in code behind. For VB.Net
Visual Basic
4 views
posted 6 years ago by keidash
-
I wanted a time based gantt chart in excel. Robert's excel template was very useful. The hourly gantt chart was not useful to visualize my needs. I need something with 10 mins precision to analyse patterns in jobs that are running under 15 mins. So t...
Visual Basic
5 views
posted 6 years ago by mprabhuram
-
This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.
Visual Basic
1 views
posted 6 years ago by mprabhuram
-
lists sheets without opening the file
Visual Basic
3 views
posted 6 years ago by lolrenx
-
short loop to load a dictionary
Visual Basic
3 views
posted 7 years ago by lolrenx
-
Concatenate all text in cells with defined separator
Visual Basic
5 views
posted 7 years ago by lolrenx
-
quick way to get column headers formatted
Visual Basic
4 views
posted 7 years ago by lolrenx
-
consider currentregion as a 'datarange' custom class
Visual Basic
saved by 4 people
1 views
posted 7 years ago by lolrenx
-
Copy rows based on criteria to a new sheet or file
Visual Basic
4 views
posted 7 years ago by angelia
-
'Append data from multiple worksheet to single worksheet macro
Visual Basic
4 views
posted 7 years ago by angelia
-
Used to invoke a GetSaveAsFileName dialogue box
Visual Basic
3 views
posted 7 years ago by sjmoorecouk
-
Save the following code as a macro and then apply it to the fields you want to convert
Visual Basic
5 views
posted 7 years ago by kidmizere
