Friday, August 30, 2013

Referencing Microsoft Scripting Runtime for FileSystemObject class in VBA IDE

From Visual Basic for Applications IDE, do Tools | References... then look for Microsoft Scripting Runtime or browse for C:\Windows\System32\scrrun.dll.

Microsoft  Scripting Runtime provides the following classes:

  • Dictionary
  • Drive
  • Drives
  • Encoder
  • File
  • Files
  • FileSystemObject
  • Folder
  • Folders
  • TextStream

No comments: