TEXT 48
Excel VBA Outlook Microsoft Scripting Runtime Library By mike on 28th March 2021 03:53:23 PM
  1. https://trumpexcel.com/vba-filesystemobject/
  2.  
  3. When you create a reference to the Scripting Runtime Library, you allow Excel VBA the access to all the properties and methods of files and folder. Once this is done, you can refer to the files/folders/drives object from within the Excel VBA (just like you can refer the cells, worksheets or workbooks).
  4.  
  5. Below are the steps to create a reference to the Microsoft Scripting Runtime Library:
  6.  
  7. 1 In the VB Editor, click on Tools.
  8. 2 Click on References.
  9. 3 In the References dialog box that opens, scroll through the available references and check the ‘Microsoft Scripting Runtime’ option.
  10. 4 OK
  11.  
  12.  
  13. # This in order to enable library for Outlook DPR/MOM script

Hasta la pasta! is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.