keen1598
01-28-2014, 06:15 AM
Hi all,So I have created a small two page form using content controls in Word 2010 and saved it as a macro enabled template. I have added all the necessary vba code to essentially save all the data from the content controls to an external excel file, paired with the template set-up which should allow multiple users to access the file. The problem is this; when the file opens in a version-ed copy of thew template, the file opens in a compatibility mode and the content controls revert just rich text objects rather than controls. My transposing VBA code works fine, I just can't figure out how to save the file such that I can open it as a version and have the content control objects function. If you open the file direct from the desktop shortcut to the file it opens as a version with no working controls. If you open the Word, then open the file through Word, it opens as a version but without working content controls. I've also tried using a helper file, which opened as a standard Word document from the same location as the form template, and used VBA to capture the pathway to associate later with the template. I used documents.add which opens the file as a version with non working controls, and documents.open which opens the file as the template itself and not a version but with working controls. I've encountered similar problems when working with template files in Excel, but using a helper file solved those issues for me.Can anyone help?