In our excel files we have variables in specific cells, however I would like to add them to the header and the footer. So they are not in the way when we update the formats of files.
Is this possible? Do I need to use a macro, just as we do for adding the variables to a word documents' header or footer?
Thanks,
Laura
Custom VBA will be required to retrieve the properties and then write them to the header/footer. Our Excel template we have a Main sheet and then a sheet called "Data" which contains the named cells that the custom properties are linked to. Then on the main sheet where the document information resides the user simply makes the cell they to show the PDM revision letter "=Revision". And then "=Description" and "=DrawingNumber", etc. That way the user has very little to try and format.