-
Re: Adding variables to header footer of excel?
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.
-
Re: Adding variables to header footer of excel?
That is an interesting idea. However some of our users have trouble with formulas in excel. The custom VBA doesn't scare me too much. I might be close to figuring it out through some excel forums.
-
Re: Adding variables to header footer of excel?
Yeah...looks like the code for pulling from the properties and pushing to teh header/footer is fairly simple.
Here's our Excel template for reference.
-
-
Re: Adding variables to header footer of excel?
Found the VBA Code in case anyone else is wondering this i
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Rev = ThisWorkbook.CustomDocumentProperties.Item("Revision")
ActiveSheet.PageSetup.LeftHeader = "Revision =" & Rev
End Sub
Now for the fun of formatting.
-