From the course: Excel VBA: Managing Files and Data
Join today to access over 24,900 courses taught by industry experts.
Manage files and data using Excel VBA
From the course: Excel VBA: Managing Files and Data
Manage files and data using Excel VBA
- [Instructor] Hi, thanks again for your interest in this course. Before I get started, I wanted to give you an overview of what I assume you know before you start. First, know that I will be referring to properties and methods within the Excel object model. So I assume that you are familiar with objects-oriented programming in general and know a bit about the Excel object model. Second, you should know how to assign values to variables. And finally, if you have experience creating if statements which are integral to this type of operation, then you will be well ahead of the game. We are working with Excel macros and most of the workbooks that are included in the exercise files collection already have macros in them. And there have been some recent changes to Excel macro security and actually macro security overall in Windows and Microsoft Office so I'm going to explain what we're going to do and then show you how to do it inside of File Explorer. First, of course, with macros, you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.