Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA modules needing to be in document, not in temp (2000/SR2)

    When a word docuemtn is derived from a template and the template has VBA code in it, only the textual content of the template is cloned and placed into the document and a reference is required to the template to maintain VBA functionally. Based on requirements I have to need to have some VBA code( the same code)be in each document that is created to handle some functionally if that diocument is sent to another PC and that PC does not have the same template on it. The inserting of VBA modules would need to be done behind the scenes not requiring any user action. Any suggestions. Are there any security risks doing this?

    My

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VBA modules needing to be in document, not in temp (2000/SR2)

    You could copy over a particular module in an AutoNew macro, I think. Would require a lot of testing. Are there security issues? You would need to train users to approve macros running every time they open the documents. This could be habit-forming. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •