Posts in the 'VBA' category, page 1 of 33

VBA

VBA is a generic category which includes programming code for any of the VBA-aware programs such as Excel, Outlook, Word, Access and more. Any subject is fair game in this category.

Updated code to trim all text fields in a MS Access database

December 11, 2012 by JP

Comments

This is a guest post from Eric @ http://ventre-a-pattes.net/.

I loved your TrimAllTextFieldsAllTables [Editors note: See original post], but it fails if some tables have no text fields. Attached is a slightly modified version that fixes the issue.

Thanks again.

Continue Reading »

Filed Under: Access, VBA

Tagged With: SQL, trim

A comparison of string cleaning methods

September 24, 2012 by JP

11 Comment(s)

While looking at a few methods for parsing a string I came across a method for removing unwanted characters from a string. It involves looping through a string and using the Like Operator to determine if any given character is wanted.

Continue Reading »

Filed Under: VBA

Tagged With: parse, speed, string

Make your workbooks talk like a pirate

September 19, 2012 by JP

2 Comment(s)

talk like a pirate day

Happy Talk Like a Pirate Day!

Continue Reading »

Filed Under: Excel, VBA

Tagged With: API, MSXML, XMLHTTP

Useful Array Functions for VBA, Part 5

September 17, 2012 by JP

1 Comment(s)

In my last blog post I promised to continue bombarding you with more custom functions for dealing with arrays. And I know you are excited to read more!

Continue Reading »

Filed Under: VBA

Tagged With: array, intersect, unique

Useful Array Functions for VBA, Part 4

September 13, 2012 by JP

Comments

PHP has a function for adding values to the beginning of an array. Let's look at a few functions that let us append and prepend values to an array.

Continue Reading »

Filed Under: VBA

Tagged With: append, array