Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder

About this tutorial: Video duration: 9:32 Use the DIR function in Excel VBA to check if a file or a folder exist. You can then decide what to do if they exist. For example you can open the Workbook to copy values from and then close the workbook. I will also show you how you […]

how to archive emails using outlook 2013

About this tutorial: Video duration: 2:1 how to archive emails using outlook 2013

MS Excel VBA Tutorial – Introduction to VBA Part 1

About this tutorial: Video duration: 8:24 How to program in Ms Excel VBA (Visual Basic for Applications) Part 1. Visual Basic for Applications (VBA) is a programming language developed by Ms Excel for it’s users to enhance the use of excel. In this Video we highlighted the importance of VBA and wrote a sub procedure […]

How to use Excel formulas in VBA | Excel VBA Programming Tips n Tricks # 2

About this tutorial: Video duration: 4:36 In this excel vba programming tips and tricks tutorial # 2, we will be learning how to use the built-in Excel formulas in VBA. And we will be using two methods that are: 1: Range(“A17″).formula=”=sum(a1:a16)” 2: Range(“A17”).value = Application.worksheetfunction.sum(Range(“a1:a16”)) Keywords: excel vba tips n tricks #1 excel vba tips […]

(Promo) Unlock Excel VBA and Excel Macros Course – Now available

About this tutorial: Video duration: 4:58 Link to complete course ► This is the promo video for my online Excel VBA & Macros course which will take you from beginner, all the way to VBA Expert. This course will take you from Beginner to VBA Expert and teach you everything you need to know to […]

Excel VBA Tips & Tricks | How to Stop VBA Code Entirely

About this tutorial: Video duration: 1:46 In this Excel VBA tips and tricks tutorial, I’ll be teaching you how to stop the execution of excel vba code entirely. For this I’ll be using the VBA End Statement. Link to article : ***************************** Courses: Excel VBA for Absolute Beginners : Mastering Excel VBA Userforms : *****************************

Excel VBA tutorial for beginners: Object Properties & Methods

About this tutorial: Video duration: 13:9 Understanding Objects, Properties and Methods in VBA is really important if you’d like to write your own Excel VBA code from scratch or update the VBA code you find on forums. This Excel VBA tutorial for beginners, includes two lectures from my “Unlock Excel VBA and Macros” course which […]

Excel VBA Programming Basics Tutorial # 1 | Introduction to VBA | Writing Our First Macro

About this tutorial: Video duration: 6:29 http://LLTtutorials.com In this Excel VBA Programming Basics Tutorial # 1 , we’re going to be writing our first macro and also getting to know vba. http://LLTtutorials.com Http://Facebook.com/LLtutorials Http://Twitter.com/LLTtutorials http://www.pinterest.com/LLTtutorials/ Keywords Excel vba Excel vba tutorial excel vba programming excel vba tutorial for beginners excel vba introduction part 1 advanced […]