Custom Properties
This is how you can create a Custom Property in an Excel Workbook to save information. Go to File->Property (as in pic).
Here is the code to read and write to the Custom Property.
Sub SetProperty() ThisWorkbook.CustomDocumentProperties("EmpName") = "Vishesh" End Sub Sub GetProperty() MsgBox ThisWorkbook.CustomDocumentProperties("EmpName").Value End Sub
»
- Vishesh's blog
- Login or register to post comments
- 22117 reads
Recent comments
5 years 47 weeks ago
6 years 33 weeks ago
6 years 45 weeks ago
6 years 48 weeks ago
6 years 49 weeks ago
7 years 2 weeks ago
7 years 10 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago