Any way to import fields in an excel document?

[gregulator]

I am trying to import file property fields (like subject/author/date/keywords etc) into an excel spreadsheet but I cannot do it? Word does it fine, any way in excel? Thanks.

 

[Thyme]

Do you want properties of the current spreadsheet or of a specified file?

If it's the former, look for someone asking about posting last modified and see if you can use that code.

If it's the latter, I don't have any idea.

 

[gregulator]

well I did find this code to get me started and plugged it into a text box (dont mind my manipulations). But I really need to get the Windows summary information out of the file. How do I do that? I need "keywords" "subject" "title" information that you see in properties. I have found information about some DSOfile DLL that helps in visual basic but I dont want to have to have every user have this DLL, and I am only using the VB editor within excel. Thank!

 

[Thyme]

Ah, good idea. Look up the Windows API docs and see if there is anything there. I believe anything in them can be used in VB.