VBA - manage files and connect MS Office Applications

About this course

In this course you will learn how to manage files and how to exchange data between files and between different Microsoft Office applications using VBA.We will start giving some fundamental information e.g. VBA files and folder functionsVBA files and folder attributesVBA data structuresVBA typesAdvanced Data Structures in VBAVBA - StringsVBA - Date and TimeVBA - ArraysVBA Excel ObjectsVBA ClassesVBA filesFunctions needed to write files in VBAThe StringBuilder  classSome important information from   the Application object (RecentFiles, defaultPath)    This information is the basis to continue in this course.In details we will then learn:VBA and text files: how to read and write to text files, how to modify a text file, how to append text to an existing text file, how to load an Array variable with data from a delimited text file. We will also see how to read and write to CSV files in VBAVBA and binary files: how to read and write to binary files, how to read from binary file and import into Excel, how to create a Binary File from Text File and Read to Excel, how to append to binary fileFile Converters in VBA: VBA – Convert File Formats, how to convert  CSV to Excel with VBA, how to convert Excel to CSV with VBA, Excel to PDF exporter, how to convert html to text file, how to convert text file into excel, how to convert html to PDFConnect MS Office applications: Controlling One Microsoft Office Application from Another, copy data from Excel to Powerpoint, activating Other Applications with Excel VBA, Using VBA to Paste from Excel to Word and PowerPoint, Controlling Powerpoint and Word from Excel using VBA, Export the text of a presentation to a CSV/Excel file, export Wo