How to Use the File System Object in VBA

preview_player
Показать описание
The file system object library makes working with folders and files in VBA a breeze. In this video, we will explore how to use this object to parse file paths, loop through folders and files, and how to get different properties about the objects in folders.

Video Resources:
--------------------------------------------------
Resource: GitHub File

Resources:
--------------------------------------------------

Support Sigma Coding:
--------------------------------------------------

Related Topics:
--------------------------------------------------
Title: How To Programmatically Add Library References Using VBA

Title: How to Work With the Command Bar Object in VBA

Title: How to Work With the Command Bar Control Object in VBA

Title: How to Export Macros Using VBA

Title: How To Run A Python Script Using Excel VBA

Title: How to Use the Shell Automation Library in VBA | Part 1

Title: How To Control The Visual Basic Editor With VBA

Title: Web Scraping With VBA | Part One

Title: Web Scraping With VBA | Part Three

Title: Web Scraping With VBA | Part Two

Title: Web Scraping With VBA | Scraping Data Tables

Title: Making API Requests in VBA | JSON

Title: Making API Requests in VBA | XML

Title: How To Pull Data From Access Using VBA

Title: Importing Text Files In VBA

Title: How to Use the File System Object in VBA

Title: How to Build Windows Forms Applications in Python | Pt. 2

**Amazon Associates Disclosure:
--------------------------------------------------

Tags:
--------------------------------------------------
#Excel #VBA #FileSystemObject
Рекомендации по теме
Комментарии
Автор

Great stuff! Thank you for that, SigmaCoding! Got your prior mesg, but noticed this video before being able to respond earlier. Did not know there was a specific library for doing those files/folders iterations. Thankkk youu!

Now additionally I should be able to leverage this same library iteration commands, as you outlined above, and build out and insert codes to also:

(1) stop by each folder or file (or the designated folder I choose),
(2) select the excel workbook,
(3) open that file or excel workbook,
(4) copy and paste whatever object type from the workbook sheet or sheet(s),
(5) paste either a chart or table into whatever new excel workbook or Word doc, for example, I want to paste it into,
(6) close the excel workbook I copied the info from,
(7)continue the iteration to he next designated folder,
(8) open up the next and designated excel workbook in the iteration, for example.
And repeat the process again for all files or designated files and excel workbooks I choose.

We should be able to insert those additional code instructions within this library iteration commands to achieve that?

ignacioa
Автор

Thanks a lot for the video, excellent content. It will be nice if you do a video on building an app from scratch using VBA

scotolivera
Автор

I am using VBA with SeleniumBasic and trying to run an automated occurrence of Firefox. Due to my companies policies, location, and laws for the governing area, we cannot use Chrome to log into our systems because it is a US company, as Chrome is very easy to use this way.

Apparently in other programming languages, e.g. Java or C#, we can use the Firefox automation using the GeckoDriver.exe. We would achieve this by using some version of the following code:

System.setProperty("webdriver.gecko.driver",

Question: Is it possible using your method in order to run the Automated Firefox with newer versions of Firefox using the gecko.exe file path?

If you can answer this question, I am sure that many people would be very appreciative as this is a very common question on the internet these days!

jasonpopek
Автор

it says "runtime error 70 permission denied" when i move file between different drives

Sidkap
welcome to shbcf.ru