How to insert criteria into the FILE-PROPERTIES box from cells in a workbook?

[DelMonte]

As the title suggests.

Is there a way for the File-Properties-Summary box to be filled with certain data from cells within a workbook?

Example, Book1, Cell A1, contains the Author Name, and what ever is in that cell will result in the Author Field in the File-Properties-Summary box being filled with that name?

I've had a good search (google and here) but can see how to do the reverse, but not this way round.

Thanks all.

Mike

[sglife]

open the excel file
Alt + F11
Click the tab " This workbook"
Paste the following code

Please Login or Register  to view this content.

save

Ok

Remember to make sure your security level is enable macro

[DelMonte]

I've checked and doubled checked, and it isn't working.

I also tried substituting Author with Subject (as my name automatically comes up (from the registry?). As the subject field is always empty by default, I thought I'd try that, but it doesn't work.

Any ideas?

Thanks

[Cheeky Charlie]

I would suggest putting this in a before save macro rather than an on open macro. This means the change will be visible more immediately, it also means the summary field would be populated if the workbook was sent to another who has security on high (as default).

Try this:

Please Login or Register  to view this content.

You may want to think about when you want this to run... when you change something on the sheet, when you open or close the workbook, when you save it... when you type "Gary is a big loser" in cell A14 on page 8... (all very easy to do!)

The built in document properties are easy to refer to by index number but I find it much easier to see what you've done this way.

Finally, check that your sheet is named "Sheet1" if not, amend as apt. The code I provide definitely works for me.

HTH

[DelMonte]

Excellent, thanks Charlie, and thanks sglife.

Works a treat.

Cheers

Mike