MacroWizard
11-19-2015, 10:05 AM
I have a template in VBA that has quite a bit of functionality. It has images that are embedded in it as quickparts and a few macros. So the issue is that users will use this template, but when they do a "Save As," they will no longer have access to the images in the template. The problem is that this is a portable document and needs to be usable after a save as. My thoughts are that the code used to reference the template could check to see if the template is the current document. If it is, the template referenced is SELF, if not, the document can reference the template (which will be in the same directory as the document).
Or, possibly even better, if the template isn't the active document, is there a way to allow a user to browse for the template so that the quickparts will work?
Or... if they keep the template open along side the document, is there a way to keep things working from there?
Thanks in advance guys :)
Or, possibly even better, if the template isn't the active document, is there a way to allow a user to browse for the template so that the quickparts will work?
Or... if they keep the template open along side the document, is there a way to keep things working from there?
Thanks in advance guys :)