Inserting Proc-Call Into BeforeSave

[Trent Argante]

I need to insert a procedure call into the BeforeSave event handler of a file
that is the result of a programmic 'Save As'.
A procedure makes changes to a template, imports a module to the template,
then saves the template as another file. At this point, the user make
changes to the file, saves then closes it. I need those changes saved to a
data file, which the imported module does, but I need the BeforeSave event
handler to call the module's procedure.
TIA,
Trent Argante
[DC.J(168)]

[Trent Argante]

Chip Pearson's "Creating An Event Procedure"
(http://www.cpearson.com/excel/vbe.htm) ended up being the soultion for this.
But, when ran, focus is set to the VBE. How do I programmically reset focus
to Sheet1 of the active workbook?
Thanks,
Trent Argante
[DC.J(168)]


"Trent Argante" wrote:

> I need to insert a procedure call into the BeforeSave event handler of a file
> that is the result of a programmic 'Save As'.
> A procedure makes changes to a template, imports a module to the template,
> then saves the template as another file. At this point, the user make
> changes to the file, saves then closes it. I need those changes saved to a
> data file, which the imported module does, but I need the BeforeSave event
> handler to call the module's procedure.
> TIA,
> Trent Argante
> [DC.J(168)]