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:
- 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: