Snipplr

(Visual Basic) Dictionary loader - lolrenx

Fri, 04 Jan 2013 20:05:22 GMT

short loop to load a dictionary

(Visual Basic) Left of - lolrenx

Thu, 20 Dec 2012 03:03:52 GMT

Left of separator

(Visual Basic) Right of Last - lolrenx

Thu, 20 Dec 2012 03:02:57 GMT

Right of last instance

(Visual Basic) Range to String - lolrenx

Thu, 20 Dec 2012 02:59:14 GMT

Concatenate all text in cells with defined separator

(Visual Basic) Format Header Range - lolrenx

Thu, 20 Dec 2012 02:56:27 GMT

quick way to get column headers formatted

(Visual Basic) Datarange as Class - lolrenx

Thu, 20 Dec 2012 02:53:17 GMT

consider currentregion as a 'datarange' custom class

(Visual Basic) Copy rows based on criteria to a new sheet or file - angelia

Thu, 15 Nov 2012 05:57:12 GMT

Copy rows based on criteria to a new sheet or file

(Visual Basic) 'Append data from multiple worksheet to single worksheet macro - angelia

Thu, 15 Nov 2012 05:54:53 GMT

'Append data from multiple worksheet to single worksheet macro

(Visual Basic) Splitting the words in a TitleCase string without using regular expressions (for VBA) - warwick-datum-process

Thu, 28 Jun 2012 03:16:13 GMT

Using VBA (Visual Basic for Applications) in MS Access, I needed to convert TitleCase to lower\_case, but did not have the regex enqine that's available in VB Script. This solution, based on a simple state machine model, splits the words in the string (converting to lower-case is trivial after that). It treats a block of upper-case letters as a single word, but the last letter of that block is the first letter of the next word; e.g., "VBAIsLame" becomes "VBA Is Lame". Because of this behaviour, if you subsequently convert to lower-case, you cannot reliably convert back to the original (all-upper-case words are indistinguishable from title-case words). To resolve this potential ambiguity, you can supply an "upper\_case\_indicator" that will be inserted before each capital letter that isn't the start of a word. So `TitleCaseSplit("VBAIsLame", "_", "-")` returns "V-B-A\_Is\_Lame".

(Visual Basic) Access 2007 Query via Execute - jfherring

Tue, 19 Jun 2012 02:50:45 GMT

Running queries in Access to ignore warnings and get affected record count

(Visual Basic) Read a Text File Line by Line - joseamirandavelez

Sat, 09 Jun 2012 08:36:00 GMT

Basic commands for reading a text file one line at a time.

(Visual Basic) Speed Up Excel Macro Execution - joseamirandavelez

Sat, 09 Jun 2012 08:34:48 GMT

Turn off screen updating, formula calculation and events in order to prevent Excel from doing all of them and speed up macro execution.

(Visual Basic) Alternative Split Function - joseamirandavelez

Sat, 09 Jun 2012 08:31:47 GMT

Found in the internet. By default, it splits using all the characters in CHARS. Useful to get a list of words in a string.

(Visual Basic) Get LDAP Full Name from LDAP username - joseamirandavelez

Sat, 09 Jun 2012 08:29:35 GMT

This function is very rough and right now is hard coded to return the common name. This can be useful if, for example, you have a list of usernames in Excel and you want to get the name of the person. However, it can be used in any VBA application.

(Visual Basic) RemoveCharacters - hzarka

Tue, 11 Oct 2011 23:27:46 GMT

(Visual Basic) ConvertAccent - hzarka

Tue, 11 Oct 2011 23:22:15 GMT

(Visual Basic) Powerpoint - Split Text - kaze

Tue, 16 Aug 2011 10:07:30 GMT

**What It Does** Extracts the words out of a selected text shape in Powerpoint, and then creates separate shapes for them. **To use:** 1. Create your Text shape. Type your text. Format it, color it, etc. 2. Select the text shape. 3. Run macro.

(Visual Basic) MS Excel: Remove all images - mikaelpelle

Mon, 08 Aug 2011 19:55:03 GMT

VBA script to remove all the images present in the active sheet of the Microsoft Excel spreadsheet.

(Visual Basic) VBA: Export excel range as image and save as file. - win4me

Thu, 02 Jun 2011 06:36:10 GMT

PROBLEM: How to save Excel range into image file. VBA macro in Excel 2007. SOLUTION: Create an empty chart, paste range image into chart area, and Export as image file. Modify code to suite to your needs.

(Visual Basic) Change Highlight Color Excel 2007 - aianrnoens

Fri, 04 Mar 2011 03:27:14 GMT

Use this code to change the default highlight color for a cell in excel 2007. Right click on the sheet name and click view code, Paste this code into the module that comes up.