Skip to content

Microsoft Office : Microsoft Excel | Excel VBA Files Folder Handling Series 4

Microsoft Excel Courses & Training, Microsoft Office Courses & Training, Buy Microsoft Excel Spreadsheet


Simpliv LLC

Summary

Price
Save 80%
£10 inc VAT (was £50)
Offer ends 31 December 2022
Study method
Online, self-paced
Access to content
Lifetime access
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

1 student purchased this course

Add to basket or enquire

Overview

About this Course
We are earning to deal with every type of file and folders data - Using one of the important library in VBA called SCRIPTING.
Use of Filesystem object class, text stream class, folder and file classes are discussed in this series from basic to advance.
How to go inside a folder and pick the needed files and then do the things like compiling data from them or modifying the files or moving them or deleting them.
Learn how to use the file-dialogs so that user can choose any folder of his or her choice and work accordingly.
Not just folders or Excel files -we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using scripting library, Very useful especially when you are dealing with big data.
Skip the files while running loops which you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. save as dialog, folder dialog and also why and where we can use them.
Customization of file dialog buttons, titles to how to open multiple files with them to make more user friendly and robust program which can be run in any machine irrespective of the drives or folder paths they have.
Learn to manipulate text files using scripting library. We have everything discussed here from basic level to advance level when it comes to file and folder manipulations.
Introducing the Collection Loops used to deal with text file data or hundred of folders or thousand of files.
Use if conditions and collection loops in the two amazing projects to show you the real use of libraries and loops.
Assignment are added so that you can practice and check your score . Doubts will always be answered if asked.

Basic knowledge
Knowledge of Loops,Collection loops, IF Functions , Variables , range and cells commands with offset use is must

Description

What you will learn
You will be able to understand the science behind how to work with different different folders and go inside those folders and access your excel or text files. you can compile the data from 100 excel files in one file and put that in other folders . Giving the chance to users to select the folder and not by hard-coding the folders paths. You will learn how to pop-up file-dialogs and use the files selected by user from there. This is intermediate and advance level VBA.


File & Folders

Who is this course for?

Students who know access VBA pretty well and now want to work with files laying under folders or want to see how we create folders or open the files from folder and import them one by one in access. If you want to see how we use the file dialogs and user can choose any folder or file from there this is the right tutorial for you.
if you want to handler errors gracefully then you must know error handlers . On error resume next and on error go to err . These are the error handlers we are going to explore in detail.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.