Thank you, Jane, for this suggestion.  It's certainly on the right track.  I'm having a few practical problems, however.
 
I admit that I'm a novice at Word macros, but I don't believe there is any way to force one macro to run immediately after another one finishes.
 
The best plan I can come up with is to code my own mGenerateReport macro stored in the document that will override the one included in SoDA.  In my own version of mGenerateReport, I could invoke SoDA's version and then invoke my own macro.
 
The problem with this plan is that SoDA does not seem to expose the signatures of its macros.  I don't know what parameters mGenerateReport needs, and I can't seem to guess.
 
Further, I'm not sure how to invoke SoDA's mGenerateReport because the structure of the Sodamacros template is hidden from me.  I don't know what module it's in.
 
Finally, I'm not completely sure I'll be able to override the SoDA menu to invoke my version of mGenerateReport when I select Generate Report, since I can't see how it's called from the SoDA menu.
 
Is there any help available on these points?


>>> "Troxel, Jane" <[EMAIL PROTECTED]> 10/02/02 10:24AM >>>
Hello Vincent,
 
SoDA exposes a whole list of macros which you might consider using in this case.  For example, look at the  mGenerateReport macro and see if you could include your macro...or maybe the mGenerateBatch macro.  Something like that.

Jane Troxel
SoDA Technical Support Engineer

-----Original Message-----
From: Vincent Kenyon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 9:14 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: (SoDA) How to fire Word macro automatically after report generation

Greetings to all.
 
I have a Word macro that I run against a report generated from SoDA.
 
Ideally, I'd like the macro to run automatically every time I generate the report from the template.
 
Does anybody know how to make this happen?
 
Thank you for considering this issue.

Reply via email to