Comment Field of an xls file

[Guest]

Hi,

Thanks in advance.

Have a table Called File_Names

In table is 250 excel table names Name = FN_Name = Name & FN_Path = Path.

What I want to do is read the Comment field (Of the File) and put it in
Old_Comment & then update it with a string Var from New_Comment

Hope you can give me urgent help on this matter

Thanks

Trev

 

[Guest]

Use the Excel Comment object. To get info, open the object browser in the
VBA editor. Search the Excel libarary for Comment

 

[Guest]

Thanks,

But I want to do the file comment not a worksheet or cell comment in
addition I using access not excel.

Pehaps I wait and see if any one else replies.

Thanks anyway

Trev