Accessing Workbook Properities Without Opening

[MoonMullen]

Is there a way, through VBA, to access Excel workbook properties without opening the workbook first? If I go into Explorer, I can see the "Author or Title or Subject" information without opening up the file. Can I reproduce this information from within Excel's VBA? I would greatly appreciate any suggestions! I

 

[acron]

If you download a file called dsofile.exe from Microsoft and install it, you can set a reference in you VBA poject which will allow you to access some Office document properties. Check out KB article Q224351 at the following link.

http://support.microsoft.com/default.aspx

. Sorry I cannot seem to post the full url, but if you search for dsofile from there it should help.You should then be able to download the file and access instructions on it's use.

Hope it can assist.