Message 1 of 2
Get comments from excel cells
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello together,
the small script show me that the comment property is nothing.
(defun c:GetExcelComment ( )
(setq ExApp (vlax-get-or-create-object "Excel.Application")
WrkBooks (vlax-get-property ExApp 'Workbooks)
Wrkbook (vlax-invoke-method WrkBooks 'Open FilePath)
ActSheet (vlax-get-property ExApp 'ActiveSheet)
)
(setq CellA1 (vlax-get-property ActSheet "Range" "A1"))
(vlax-dump-object CellA1 T)
(princ)
)
But the specified cell has a comment in my excel file.
General, how can I read the the comments or notes from cells like the values?
Best regards and thank you for your help!