How can I retrieve content created date from excel in uipath
- Create a .txt file and added the below function
Function GetCreationDate() GetCreationDate=ThisWorkbook.BuiltinDocumentProperties("Creation Date") End Function
- Add an Excel Application Scope activity and passed the file path (The Excel file path from which to extract the content created date)
- Add Invoke VBA activity inside the excel scope and passed the .txt file path as input.
- The total sequence extracted the content date.