| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Save In" dialog (dialogue) issue | Excel Discussion (Misc queries) | |||
| "Save As WebPage" dialog box missing | Excel Discussion (Misc queries) | |||
| Excel "Save as" dialog - when file already exists | Excel Programming | |||
| How do you turn off "Save a copy/Overwrite changes" dialog box | Excel Discussion (Misc queries) | |||
| Getting "Save as PDF File" Dialog at end of printing to PDF using PDFwriter | Excel Programming | |||
Linear Mode
