Getting a Word VB Macro to execute when sending Individual Report to document server
I have a VB Script that does some colouring in on an Individual Report, which is more complex than the colouring that SIMS can do. When I set up the Individual Report template, I put the code into the Private Sub Document_Open() bit.
This works when you run the report for preview or print, because word actually executes and the macro runs. However if you send the report to the document management server to store with the pupil's record, then the code never runs. If a user opens that file, the code will run then, but that's dependent on having their macro settings correct, which you can't guarantee.
Is there any way of getting around this? Does Word execute at all when you save an individual report or does SIMS do all the XML merging itself? If it does run, is there another Sub that I can put the code into?
If I go down the road of PDFing files (I see there are some threads on this), is there an easy way of Bulk Uploading to the student record? The file name by default has the student name and admissions number on it so it should be possible?