Get yourself trained on VBA – manage with this Online Training VBA – manage files and connect MS Office Applications.
Online Training VBA – manage files and connect MS Office Applications
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 CSVfiles 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 Word tables to Excel sheets, Import/Export to Access from Excel, update Access with Excel data with VBAFolders and File Handling in Excel VBA: Check if Folder Exists, opening, moving, deleting and creating folders using VBA Excel, making File Read Only in VBA Excel, copy all Excel Files from One Folder to Another in VBA Exceldir function: iterate though all the folders inside a path (immediate child folders only), iterate though all the files present at a location. (No need to list files under subfolders), list all the files inside a current location and its subfolder, search filesExcel VBA File Management Using The FileSytemObjectAll the methods, copy Files With a Specific File Type, copy All Excel File Type, organize Files Based on File Type, organize Files Based on File Name, retrieve file information, read and write from/to text and binary files using FileSystemObject in VBA, rename, move and copy files, delete a fileFile Dialog: Opening /Saving Files Using File Dialog Box in Excel VBA, customize File or Folder Dialog Box in VBA Excel, filters of Dialogs, the Dialogs collection, the Dialog objectOneDrive and VBA: What is OneDrive, Excel’s fullname property with OneDrive, VBA download a File from OneDrive, SaveAs in OneDriveMacros disabled when opening workbooks in OneDrive, Select a Workbook from OneDrive, How do I open files saved in Microsoft Onedrive using vbaVBA and JSON files: JSON file data into a VBA Dictionary, The JSON VBA libraries already available and ready to useImport/Export JSON to/from Excel, export Excel to Nested JSONVBA and XML files: reading an XML file with XPath in VBA, save to XML file, reading XML file in VBA ((XML structure, XML DOM nodes, XML file)VBA and HTML files: reading an HTML file, create HTML Tables with Excel VBA, export Excel to HTML, reating HTML using a Builder Pattern from Excel Table in VBA, using Excel Cell StyleElements to Style HTML DocumentADODB Stream: ADODB Streams to read and write files, convert ADODB binary stream to string vba, Save and read Binary and Text Data, use the ADO recordset, record and stream objects to open documentsVBA and String Encoding: Unicode Strings and the Windows API, save text file UTF8 without BOM encoded, read/write UTF-8 files with VBA, Convert UTF-8 to ANSI , ANSI-String in UTF8-Format, ISO-Text in UTF8-Format, ISO-8859-1 String encoding, VBA XML and encoding, write to UTF-8 text file with Excel VBARemote files and VBA: WinHttpRequest (XMLHTTP, ServerXMLHTTP) and remote filesData Migration: Data Import/Export in Excel, automation to transfer data cell by cell, to Transfer an Array of Data to a Range in a Worksheet, to transfer an ADO Recordset to a Worksheet Area, to create a Query Table in a Worksheet, use the Clipboard to transfer data in VBA, transferring data to a worksheet with ADO, import text file into Excel with QuerytablesManage compressed files in VBA: compress a file, unzip File Through Excel VBA Code, create a zip file from a folder, Unzip a zip file to a folder, create Zip Files with VBA using 7-Zip, create a ZIP archive with the Windows Shell, zip and encrypt a directory from VBA, save excel file to zip file, compress/extract files with WinRarFTP and VBA for file exchange with remote servers: use FTP in VBA, Download / Upload File using VBA and FTP, Asynchronous File Downloads using VBA, alternative methods to Upload file via FTP from Excel VBA, FTP a text file to a server using VBA in Excel, use VBA to export CSV from webpage
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.