G
Guest
All,
I'm working on a Powerpoint automation project that I'd like to work like
this:
I've created a Powerpoint presentation that serves as a base "template."
This .ppt contains a number of vba macros
I have a seperate application that pulls in data from a db, and passes that
data to the PPT template using vbscript running in the windows script host.
This script also executes the macros in the PPT to format all the data.
Once the data is passed and formatted, the PPT template should "save as" a
copy of itself under a new name - this file is the finished report. The
template itself remains unchanged, for the next time I run the application.
Last, I'd like to remove the macros from the finished report.
Here's the problem I've run into: because the PPT uses macros, the
automation failed (the security warning requires a user response, and I want
the app to run without user intervention). So, I tried to solve this problem
by signing the vba, and requiring users to trust the signing certificate.
This works great, EXCEPT...
when the user runs the app, the step in the program that removes the macros
fails, b/c they're digitally signed, and the user doesn't have the signing
key.
So, bottom line - is there any way to distribute an application that BOTH:
- uses signed macros to elimiate the security warning
- allows the macros to be removed?
Many thanks in advance for your advice and expertise!
Cheers,
Matt Stuehler
I'm working on a Powerpoint automation project that I'd like to work like
this:
I've created a Powerpoint presentation that serves as a base "template."
This .ppt contains a number of vba macros
I have a seperate application that pulls in data from a db, and passes that
data to the PPT template using vbscript running in the windows script host.
This script also executes the macros in the PPT to format all the data.
Once the data is passed and formatted, the PPT template should "save as" a
copy of itself under a new name - this file is the finished report. The
template itself remains unchanged, for the next time I run the application.
Last, I'd like to remove the macros from the finished report.
Here's the problem I've run into: because the PPT uses macros, the
automation failed (the security warning requires a user response, and I want
the app to run without user intervention). So, I tried to solve this problem
by signing the vba, and requiring users to trust the signing certificate.
This works great, EXCEPT...
when the user runs the app, the step in the program that removes the macros
fails, b/c they're digitally signed, and the user doesn't have the signing
key.
So, bottom line - is there any way to distribute an application that BOTH:
- uses signed macros to elimiate the security warning
- allows the macros to be removed?
Many thanks in advance for your advice and expertise!
Cheers,
Matt Stuehler