DOCUMENT VBA

Assistant

14/12/2024

1 min read

Description

Provides access to a computer’s file system.

NOTES

Reference to AUExpress.Cells library.

Syntax

  Dim doc As New AUDocument
  doc.SearchOption = SearchOption.SearchOption_TopDirectoryOnly
  doc.SearchMode = SearchMode.SearchMode_File
  doc.FileSizeUnit = FileSizeUnit.FileSizeUnit_B
  doc.FolderSizeUnit = FolderSizeUnit.FolderSizeUnit_B
  
  'do something
  ...
 
  Set cls = Nothing

EXAMPLE 1

Get the names of all files from a specified path:

  Dim x() as String
  x = doc.GetList("C:\Users\admin\Downloads\")

EXAMPLE 2

Extract File or Folder information from a specified path:

  Dim y as AUDocumentInfo
  Set y = doc.GetItem("C:\Users\admin\Downloads\Example.xlsx")
  Debug.Print y.Size
  Debug.Print y.Author
  Debug.Print y.Name