FrigidDigit
Board Regular
- Joined
- May 10, 2005
- Messages
- 203
Hi All
I have an Excel VBA procedure with which I loop through several folders on my hard drive and extract portions of the names of the pdf files contained in the folders to cells in the workbook.
This works perfectly but now I would like to access the comment property of each pdf file (in windows explorer right click->properties) and write that into a cell in the workbook next to the file name.
Can anyone please point me in the right direction?
Thanks
FD
I have an Excel VBA procedure with which I loop through several folders on my hard drive and extract portions of the names of the pdf files contained in the folders to cells in the workbook.
This works perfectly but now I would like to access the comment property of each pdf file (in windows explorer right click->properties) and write that into a cell in the workbook next to the file name.
Can anyone please point me in the right direction?
Thanks
FD