sparky2205
Well-known Member
- Joined
- Feb 6, 2013
- Messages
- 507
- Office Version
- 365
- 2016
- Platform
- Windows
Hi folks,
I am using a document control application which gives me instructions on how to use Named Ranges to populate cells in Excel with data from Custom Property Fields.
I can see the Custom Property Fields in a spreadsheet which is downloaded from the application; File > Info > Properties > Advanced Properties. The docnumber is the one I'm after.
The instructions tell me the Name of the range is to be the same as the custom property name i.e. docnumber and Refers to: is the cell where I want to place the document number in the spreadsheet.
Then save and close the document and the next time the document is opened from the application the actual document number will be displayed in the Refers to: field.
This, however, is not working. The cell remains stubbornly blank.
This may be a real shot in the dark as you obviously don't have the application I am using to test anything.
Just though I'd ask in case anyone has come across this type of thing or indeed if anyone has used custom fields in Excel in this way.
I am using a document control application which gives me instructions on how to use Named Ranges to populate cells in Excel with data from Custom Property Fields.
I can see the Custom Property Fields in a spreadsheet which is downloaded from the application; File > Info > Properties > Advanced Properties. The docnumber is the one I'm after.
The instructions tell me the Name of the range is to be the same as the custom property name i.e. docnumber and Refers to: is the cell where I want to place the document number in the spreadsheet.
Then save and close the document and the next time the document is opened from the application the actual document number will be displayed in the Refers to: field.
This, however, is not working. The cell remains stubbornly blank.
This may be a real shot in the dark as you obviously don't have the application I am using to test anything.
Just though I'd ask in case anyone has come across this type of thing or indeed if anyone has used custom fields in Excel in this way.