How To Retrieve Content Created Date From Excel In UiPath?
Resolution
- Create a .txt file and add the below function:
Function GetCreationDate() GetCreationDate=ThisWorkbook.BuiltinDocumentProperties("Creation Date") End Function
- Add an Excel Application Scope activity and pass the file path (The Excel file path from which to extract the content created date).
- Add Invoke VBA activity inside the Excel scope and pass the .txt file path as input.
- Create an output variable in Invoke VBA to save the creation date.