Replicate macro to other documents
Results 1 to 4 of 4

Thread: Replicate macro to other documents

  1. September 22nd, 2004, 03:04 PM #1
    CeeBee
    CeeBee is offline
    Registered User CeeBee's Avatar
    Join Date
    Nov 2002
    Location
    USA
    Posts
    2,494

    Replicate macro to other documents

    Here's a tough one.. hope someone comes with a solution.
    I have a macro that has to be copied to some Office documents (Excel). The VBA project is digitally signed to allow execution even with security set to high. Inserting it manually is out of question, there are THOUSANDS of documents that should end up containing the macro (all listed in a file).
    Suggestions anyone???
    Reply With Quote Reply With Quote
  2. October 5th, 2004, 10:49 AM #2
    NooNoo
    NooNoo is offline
    Driver Terrier NooNoo's Avatar
    Join Date
    Dec 2000
    Location
    UK
    Posts
    31,824
    about the clearest explanation I have found
    Reply With Quote Reply With Quote
  3. October 5th, 2004, 11:00 AM #3
    CeeBee
    CeeBee is offline
    Registered User CeeBee's Avatar
    Join Date
    Nov 2002
    Location
    USA
    Posts
    2,494
    That would take care of the new documents.. what about the existing ones that contain no macro, but should end up containing one? Looks I need to write some kind of "macro virus" that automatically opens and "infects" the list of files.. but then would the "infected" document still have the digital signature?
    Reply With Quote Reply With Quote
  4. October 6th, 2004, 05:28 PM #4
    NooNoo
    NooNoo is offline
    Driver Terrier NooNoo's Avatar
    Join Date
    Dec 2000
    Location
    UK
    Posts
    31,824
    As I understood that and similar articles, you can take the existing template those documents where created with and then add the macro to it. You then redistribute that template so that when the document is opened, the macro is available.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Documents folder for another user
    By SirWise in forum Windows XP
    Replies: 5
    Last Post: August 31st, 2004, 01:06 PM
  2. help needed with excel macro
    By shaltar in forum Microsoft Office
    Replies: 3
    Last Post: November 24th, 2003, 05:01 PM
  3. [RESOLVED] Error opening documents...
    By Seoirse in forum Microsoft Office
    Replies: 2
    Last Post: July 16th, 2002, 08:10 AM
  4. [RESOLVED] WIndowsMe and Windows Explorer with My documents????
    By paul62bf in forum Windows 95/98/98SE/ME
    Replies: 6
    Last Post: January 14th, 2001, 01:03 PM
  5. [RESOLVED] my documents shortcut changes when given administrator privledges
    By between us in forum Windows NT/2000
    Replies: 0
    Last Post: October 2nd, 2000, 12:47 PM

Bookmarks

Posting Permissions

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

Forum Rules