How To Retrieve Content Created Date From Excel In UiPath?

News Knowledge Base
1

How can I retrieve content created date from excel in uipath

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

GetCreationDate=ThisWorkbook.BuiltinDocumentProperties("Creation Date")

End Function

  1. 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.