Adding code right after the "Save As" dialog box
 

I have created an excel application whose footer has -apart from other
things- the full path and file name where the excel workbook resides.

I would like this information (fullpath + file name) to be reflected in the
footer when my user clicks on €œSave as€�. How can I invoke an event and make
decisions €“change the footer- based upon what my user has entered in Save As?

Adding code right after the "Save As" dialog box
 

The ThisWorkbook module has a BeforeSave event for ThisWorkbook where you
should be able to do that in.

--
Rick (MVP - Excel)


"Jess" wrote in message
...
I have created an excel application whose footer has -apart from other
things- the full path and file name where the excel workbook resides.

I would like this information (fullpath + file name) to be reflected in
the
footer when my user clicks on €œSave as€�. How can I invoke an event and
make
decisions €“change the footer- based upon what my user has entered in Save
As?

Adding code right after the "Save As" dialog box
 

Wouldn't it make more sense to use the _beforeprint event?

Jess wrote:

I have created an excel application whose footer has -apart from other
things- the full path and file name where the excel workbook resides.

I would like this information (fullpath + file name) to be reflected in the
footer when my user clicks on €œSave as€�. How can I invoke an event and make
decisions €“change the footer- based upon what my user has entered in Save As?

--

Dave Peterson