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:
- Five tips for writing better VBA code
- 10 ways to screw up your VBA code
- Five tips for handling errors in VBA
- Use VBA to bring in the range
- How to use and define VBA enumerate constants
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:
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
Bill Detwiler is Managing Editor Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. He was most recently Managing Editor for TechRepublic Pro. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.