How To Retrieve Content Created Date From Excel In UiPath?

How To Retrieve Content Created Date From Excel In UiPath?

Resolution

  1. Create a .txt file and add the below function:
Function GetCreationDate()

GetCreationDate=ThisWorkbook.BuiltinDocumentProperties("Creation Date")

End Function
  1. Add an Excel Application Scope activity and pass the file path (The Excel file path from which to extract the content created date).
  2. Add Invoke VBA activity inside the Excel scope and pass the .txt file path as input.
  3. Create an output variable in Invoke VBA to save the creation date.