I wish to automate the population of the field called Title in the workbook's File Properties. For the avoidance of doubt I mean click on file > properties > title.
The narrative I wish to populate is already in cell B8 of a sheet called "header". So my long hand, non vba route is to
1) click on sheet "header"
2) click on cell B8 and ctrl+C
3) click File > Properties > Title
5) return to main screen
This is my novice attempt...
I can see this will not work, but don't know how to fix. Any charitable assistance would be gratefully received.
Many thanks for reading this.
PS I intend to place this in a loop to run this routine over a series of workbooks, but I should be OK to do that part.