3 Replies Latest reply on Sep 5, 2013 3:20 PM by Jeff Thomas

    Can EPDM variables be linked to an Excel footer?

    Jeff Thomas

      We have Excel documents that are going to be revision controlled within the EPDM Vault. When the document goes to the released state I want the transition to update the RevDate, Rev and RelDate. I have done this sucsessfully with Word files however it appears that it is not possible to add custom property links to the footer of a Excel Document. Has anyone found a way to do this? Our work around was to set the top row of the spread as a row that will repeat on all pages. We would prefer to add this information in the footer of the document.


      Also when I try and link a date variable to a named cell in the spreadsheet the date variable is deselected in the data card. I have tried to set the date variable as a date type on the card, but this did not work either. The work around was to use an edit field and manually type the date in as text. Not sure why this is happening.


      Excel properties are not nearly as friendly as Word properties. Sucks!


      Thanks for all the help!


      Jeff Thomas

      Seanic Ocean Systems

        • Re: Can EPDM variables be linked to an Excel footer?
          Laura Whittle

          See this thread for more https://forum.solidworks.com/message/365837#365837


          I got it to work with VBA code, you can do it before print or after save.


          I used after save command which meant that the variables would not update till someone opened it and saved it.  Which could work depending on your situation, but unfortantely it did not work for us.


          There is probably another way to do it, but I decided to take an easier path and just make our excel templates have the revision info on the first row and everything else goes below.

          • Re: Can EPDM variables be linked to an Excel footer?
            Jennifer Bahnsen

            I agree with you - Excel doesn't play as well with custom properties as Word does.


            I don't believe there is a way to add an EPDM variable to the header or footer in Excel.  In Excel, you can link a cell to a property by giving the cell a name that is the same as the custom property then linking the value of the custom property to the contents of the cell.  The problem with the header or footer is that the content is not linked to a column/row location that can be named.  It looks like you can link to things like the filename, sheet name, current date, etc. but that may be all.


            You could do a search for Excel help on the web.  There are a lot of resources from users that are really familar with Excel. 


            Jennifer Bahnsen