Description
NOTE
  • 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
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

See documentation for other methods.

Join our newsletter to stay up to date

Click the button below to sign up for our advanced platform. Get started now and see the benefits for yourself.

EN | VI