Printable View
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???
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?
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.