S
spunkymuffmonkey
Hi there, thanks for looking at my question, which is about importing macros.
To explain, our users place client records in what we call a running record,
this is basically a word document with a table.
I was recently requested to create a macro that automatically inserts a few
lines in this table with some standard referral questions. This macro
basically adds 8 new rows and populates 4 of them with some standard
questions, with 4 spaces to answer these questions, no problem with this.
However, what I am seeking to do now is to find a way of updating old
running records documents with this new macro. Of course any new running
records created by our users will carry this new macro, but any old running
records will not of course.
I would like to make adding the macro as easy as is possible for our users,
I 'm aware that I could place the macro in a shared location and have users
manually update their running records but this is not something that I could
envisage working well as the knowledge level of some users is basic to say
the least.
I have tried adding a macro to a document programmatically, but hit the run
time error ‘6068’ (Programmatic Access to Visual Basic Project is not
trusted) which I understand is to prevent self replicating macros and
security risks, although this security can be relaxed by specifically
allowing access to VB projects, this of course presents obvious security
risks and is also out of my jurisdiction (this would be up to our Server
Technologies team, who probably wouldn’t cater for this request I imagine!).
So, I open it up to the floor for any bright spark to suggest another way in
which I can do what I desire and offer a thousand thanks in advance to
anybody who can give me a pointer or a solution.
Thanks again for looking.
To explain, our users place client records in what we call a running record,
this is basically a word document with a table.
I was recently requested to create a macro that automatically inserts a few
lines in this table with some standard referral questions. This macro
basically adds 8 new rows and populates 4 of them with some standard
questions, with 4 spaces to answer these questions, no problem with this.
However, what I am seeking to do now is to find a way of updating old
running records documents with this new macro. Of course any new running
records created by our users will carry this new macro, but any old running
records will not of course.
I would like to make adding the macro as easy as is possible for our users,
I 'm aware that I could place the macro in a shared location and have users
manually update their running records but this is not something that I could
envisage working well as the knowledge level of some users is basic to say
the least.
I have tried adding a macro to a document programmatically, but hit the run
time error ‘6068’ (Programmatic Access to Visual Basic Project is not
trusted) which I understand is to prevent self replicating macros and
security risks, although this security can be relaxed by specifically
allowing access to VB projects, this of course presents obvious security
risks and is also out of my jurisdiction (this would be up to our Server
Technologies team, who probably wouldn’t cater for this request I imagine!).
So, I open it up to the floor for any bright spark to suggest another way in
which I can do what I desire and offer a thousand thanks in advance to
anybody who can give me a pointer or a solution.
Thanks again for looking.