Developer

Video: Five simple rules for embedding strings in VBA code

In this TR Dojo episdoe, Bill Detwiler shares five things you should know about embedding strings in VBA code.

If you work with VBA, odds are you'll eventually struggle with embedded strings. It might be a simple task such as passing a string to a function or something more complex like creating a SQL statement on the fly. But when the time comes, you can avoid the struggle by remembering the five simple rules I share in this week's TR Dojo episode.

Check out the following links for more VBA resources:

For those who prefer text to video, click the View Transcript link below the video player windows or check out Susan Harkins' article, "5 rules for embedding strings in VBA code," on which this video is based.

You can also sign up to receive the latest TR Dojo lessons through one or more of the following methods:

About

Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop supp...

Editor's Picks