How to Use the Shell Automation Library in VBA Part 1

YOUR LINK HERE:

http://youtube.com/watch?v=Hqt1rs1bth8

The Microsoft Shells Control library makes working with system operations a breeze. With this library, we can execute a wide variety of scripts, grab system settings and information, and grab system folders. In this tutorial, we will explore some of the fundamentals of using the Shell library and how to interact with different system settings. • Video Resources: • -------------------------------------------------- • Resource: GitHub File • Link: https://github.com/areed1192/sigma_co... • Resource: Microsoft Shell Folder Constants • Link: https://docs.microsoft.com/en-us/wind... • Resource: Microsoft Shell Object • Link: https://docs.microsoft.com/en-us/wind... • Resource: Microsoft Shell Settings • Link: https://docs.microsoft.com/en-us/wind... • Resource: Microsoft System Info • Link: https://docs.microsoft.com/en-us/wind... • • Resources: • -------------------------------------------------- • Facebook Page: / codingsigma • Facebook Group: / sigmacoding • GitHub Sigma Coding: https://github.com/areed1192/sigma_co... • Support Sigma Coding: • -------------------------------------------------- • Patreon: / sigmacoding • Amazon Associates: https://amzn.to/3bsTI5P ** • Related Topics: • -------------------------------------------------- • Title: How To Programmatically Add Library References Using VBA • Link: • How To Programmatically Add Library R... • Title: How to Work With the Command Bar Object in VBA • Link: • How to Work With the Command Bar Obje... • Title: How to Work With the Command Bar Control Object in VBA • Link: • How to Work With the Command Bar Cont... • Title: How to Export Macros Using VBA • Link: • How to Export Macros Using VBA • Title: How To Run A Python Script Using Excel VBA • Link: • How To Run A Python Script Using Exce... • Title: How to Use the Shell Automation Library in VBA | Part 1 • Link: • How to Use the Shell Automation Libra... • Title: How To Control The Visual Basic Editor With VBA • Link: • How To Control The Visual Basic Edito... • Title: Web Scraping With VBA | Part One • Link: • Web Scraping With VBA | Part One • Title: Web Scraping With VBA | Part Three • Link: • Web Scraping With VBA | Part Three • Title: Web Scraping With VBA | Part Two • Link: • Web Scraping With VBA | Part Two • Title: Web Scraping With VBA | Scraping Data Tables • Link: • Web Scraping With VBA | Scraping Data... • Title: Making API Requests in VBA | JSON • Link: • Making API Requests in VBA | JSON • Title: Making API Requests in VBA | XML • Link: • Making API Requests in VBA | XML • Title: How To Pull Data From Access Using VBA • Link: • How To Pull Data From Access Using VBA • Title: Importing Text Files In VBA • Link: • Importing Text Files In VBA • Title: How to Use the File System Object in VBA • Link: • How to Use the File System Object in VBA • Title: How to Build Windows Forms Applications in Python | Pt. 2 • Link: • How to Schedule a Macro to Run at Cer... • • **Amazon Associates Disclosure: • -------------------------------------------------- • I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. • Tags: • -------------------------------------------------- • #Excel #VBA #ShellObject

#############################

New on site