If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
Download files here www.wiseowl.co.uk/videos/excelvba/join-and-concatenate.htm
www.wiseowl.co.uk - This video explains how to join or concatenate strings in VBA. You'll learn about to different operators you can use to do this, and why one is better than the other. You'll also learn how to use the Join function to take the contents of an array and concatenate them into a single string. The final part of the video shows a couple of practical uses for these techniques with an example that writes data to text files.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!