Snipplr

(Visual Basic) Excel spreadsheet to MySQL Table inserts - jeffreality

Thu, 24 Apr 2008 17:41:39 GMT

(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) Parse Command Line Parameters (VBScript) - ScryptKeeper

Mon, 18 Aug 2008 13:54:43 GMT

(Visual Basic) VBS Timestamp Backup Script - qrist0ph

Wed, 14 May 2008 15:55:42 GMT

copy to sendto folder

(Visual Basic) Access Plain Text Export - qrist0ph

Tue, 13 May 2008 05:07:49 GMT

(Visual Basic) browse folder/file - lolrenx

Wed, 27 Feb 2013 23:35:56 GMT

returns folder/file path as string

(Visual Basic) Datarange as Class - lolrenx

Thu, 20 Dec 2012 02:53:17 GMT

consider currentregion as a 'datarange' custom class

(Visual Basic) list of tables and queries using the Database Object - angelia

Sat, 01 Dec 2012 07:41:17 GMT

' create the list of tables and queries using the Database Object and its QueryDef and TableDef collections 'http://www.techrepublic.com/article/how-to-create-a-list-of-tables-or-queries-from-access/5047664

(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) 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) WhoIsLoggedIn.vbs - RobertHirabayashi

Fri, 10 Feb 2012 06:28:45 GMT

Run this script from a command prompt, and you'll be asked for the IP Address or Host Name. Script will first check if PC is ping-able and will return an error message on any unreachable host. If the computer is running, script will return with user details about the logged in user from Active Directory.

(Visual Basic) Nuova funzione con gestione errori - Ideandro

Tue, 08 Mar 2011 02:37:47 GMT

Per creare una nuova funzione completa di un gestore errori.

(Visual Basic) Excel Copy value from cell with custom format - abhisood

Wed, 16 Feb 2011 10:56:25 GMT

Excel macro to copy values from formated cells. For example: If you have a sheet that has huge numbers in millions for example 1,312,323 and you apply a format to the cell such that only 1.3 is displayed, if you want to copy 1.3 and put it in a database (without the format) use the following snippet. Select all the cells you want to apply this macro and run it. Note: this will convert the cell values to string

(Visual Basic) Check for duplicate record from many to many table - numeric - heislekw

Tue, 18 Jan 2011 16:03:31 GMT

(Visual Basic) Remove a specific character from the end of a Excel cell - TheJasonParker

Fri, 14 Jan 2011 22:09:35 GMT

Replace 'A1' with the cell and '-' with the character you want to remove.

(Visual Basic) Verificar y Crear Ruta - mayorga

Wed, 08 Sep 2010 19:56:19 GMT

(Visual Basic) Auto completar un textbox desde una BD - tanerliq

Wed, 14 Oct 2009 10:16:39 GMT

(Visual Basic) cmdSearch - mausus

Sat, 30 May 2009 23:47:51 GMT

(Visual Basic) vb6 - Age - Find Age from DateOfBirth - Joshnolan118

Wed, 25 Feb 2009 06:26:01 GMT

(Visual Basic) VBA Send Outlook Email - fostersolutions

Tue, 25 Nov 2008 15:04:07 GMT

To test this procedure, type the following line in the Debug window, and then press ENTER. SendMessage True, "C:\My Documents\Customers.txt" Note that a new message is displayed in Microsoft Outlook with an attachment. To send the message without displaying it in Microsoft Outlook, call the procedure with a False value for the first argument: SendMessage False, "C:\My Documents\Customers.txt" To send the message without specifying an attachment, omit the second argument when calling the procedure. SendMessage True REFERENCES For more information about using Automation in Microsoft Access, search the Help Index for Automation, or ask the Microsoft Access 97 Office Assistant. For more information about using Automation to control Microsoft Outlook, please see the following articles in the Microsoft Knowledge Base: 160502 ACC: Using Automation to Add Appointments to Microsoft Outlook 161012 VBA: How to Create a New Contact Item in Outlook with Automation

(Visual Basic) SSRS Color Every Other Row In Table - hoffstein

Mon, 03 Nov 2008 17:20:00 GMT

Set the BackgroundColor property to the following expression.

(Visual Basic) VBS Recordset - qrist0ph

Tue, 16 Sep 2008 04:25:12 GMT

(Visual Basic) VBS Datenbankzugriff - qrist0ph

Mon, 26 May 2008 02:21:39 GMT

(Visual Basic) VBS Filesystem Cheat Sheet - qrist0ph

Sun, 25 May 2008 16:23:03 GMT