VBA - manage files and connect MS Office Applications

Open a text file in VBA, check for its existence, and write text data before closing the file, using print functions and streams.

Learn how to modify a text file in VBA using the find and replace function. Open the file for reading, replace targeted strings, and write the updated text back.

Learn to load a text file into a VBA array by splitting lines and semicolon-delimited fields, then populate a worksheet with the resulting data.

Learn method 2: a simple VBA routine to read a binary file using a read function, manage a byte buffer and buffer size, loop until end, and print each buffer.

Learn to read binary data in VBA and import it into Excel by opening a binary file, reading bytes, and saving results to a worksheet.

Learn to read and write binary files in VBA by identifying headers and records, applying read/write routines, and using binary lock to allow safe multi-user access.

Convert csv to excel with vba demonstrates connecting to a data source, using a provider, and querying a recordset to retrieve Sacramento records and associated zip codes.

Learn to export Excel worksheets (including two worksheets) to PDF using VBA, specifying the file name, sheet selection, and export options such as include properties and open after publish.

Use VBA to load html in a web browser control, select the default printer, and print or convert files to pdf.

Learn to automate and connect Microsoft Office applications with VBA by exporting data from Excel to Word, creating documents from rows, and using bookmarks and arrays to populate content.

Copy a specified Excel range (A1:H10) into a PowerPoint slide with VBA, handling errors and creating or opening PowerPoint. Paste as a metafile and position the shape.

Learn how to use VBA to copy charts or ranges from Excel and paste them into Word, including selecting the range and pasting the chart in a Word document.

Control PowerPoint from Access using VBA by creating the PowerPoint application object. Add a rectangle shape to the active slide and customize its position and fill.

Learn to automate Excel from PowerPoint with VBA by creating an Excel application object, making it visible, opening a workbook, writing to range 8, and running the process from PowerPoint.

Learn to copy text from a Word document into Excel using VBA by opening Word, reading the document range, and inserting the text without saving.

Learn how to control Excel from Word using VBA, set up the developer tools and Excel object library, and automate copying data from Excel to Word across sheets.

Use VBA to export an Access table to Excel, setting the table name and worksheet, and use the transfer spreadsheet action to move data into an Excel file.

Use VBA to connect to an Access database with Active X objects, run a select query, and copy the recordset into an Excel worksheet.

Master VBA techniques to import an Excel ListObject into Access with VBA, using a loop, a recordset, and string construction to transfer and insert data into an Access table.

Learn how to verify file or folder existence in Excel VBA by using a path string and basic checks with the file system object and the directory function.

Learn how to move folders in Excel VBA using the FileSystemObject's MoveFolder method, relocating entire folder structures to a destination while preserving tests and structure.

Learn how to use the dir function to list files and folders, distinguish them, and access attributes like path, date modified, and size with the file system object.

Learn to loop through immediate subfolders of a path in VBA, identify directories, print them with an index, and handle end-of-list while exploring first-level and second-level folders.

Learn to list all files in the current location and its subfolders using a VBA routine, build arrays of subfolders, and recursively print or collect absolute paths.

Master the path separator in VBA to build full or absolute folder paths, and use Excel's path separator property to adapt to Mac or PC.

Learn to locate and retrieve all Excel files in a directory using wildcards, then loop through each workbook and its worksheets, printing sheet names and accessing workbook properties.

Explore using the VBA file system object to locate files with GetFile, access absolute paths, and retrieve properties such as last modified date and file name for simple file management.

Learn to use the File System object and its create folder method in VBA to construct a folder path, create folders within a tree, and manage simple folder updates.

Learn how to copy all Excel files from one folder to another using VBA. Extract extensions with the left function, filter by Excel extensions, and create destination folders when needed.

Organize files by type using a VBA workflow that loops through a folder, creates subfolders named after file types, and copies each file to its corresponding type folder for access.

Learn to read and write csv files using the FileSystemObject in VBA by manipulating text files, accessing workbook worksheets, using used range, and saving and opening files.

Write to binary files using FileSystemObject in VBA by opening a file as a text stream, reading lines to the end, and joining the array to access binary data.

Learn to rename, move, and copy files using VBA's native file manipulation functions, with practical examples that demonstrate renaming test to test x 10, and copying and moving between directories.

Explore the file system object in VBA to manage files and directories, using methods like change directory, change drive, current directory, and dir.

Learn how to use the Excel VBA file dialog box to open or save files, select folders or multiple files, and apply filters and patterns to control what appears.

Learn how the save as dialog in VBA saves a file by selecting the file name and location. The lecture shows applying filters, like text files, during saving.