Changing file properties through excel

**wilro85** · 09-02-2009, 06:37 PM

I've come across this site that tells me how to get the information out that I want, so I know what I want to do is possible.

http://vbadud.blogspot.com/2007/05/r...rties-vba.html

I would like to be able to have a textbox_change event (or maybe a textbox_exit event) that would change the comments on a closed workbook. I would REALLY like to avoid having to open the workbook to see/edit the comments if I can avoid it. Is this possible?

Ultimately, I'd like to be able to store notes about the workbooks in a folder, but I want the notes to follow the workbook that the notes relate to and not be set as hard values in cells in the workbook calling the code.

**shg** · 09-02-2009, 06:49 PM

avoid having to open the workbook to see/edit the comments if I can

No way I know of.

**wilro85** · 09-02-2009, 07:12 PM

Well I got it to work with using open and close, but it turns out it isn't quite what I was hoping for.

Using this:

Please Login or Register  to view this content.

I can see the message by going
Windows Orb -> Prepare -> Document Properties

what I really want is the properties that you get when you right click on the file thru Windows Explorer and go to "Properties -> details"