Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save before printing
In my project i have a before_save event with many contions and then if
all conditions are met i make a folder and name the file with info from cell A1 ( if the file exist then it overwrites it). Then i have a before_print event and i woulld like to save the file before printing it. My problem is that how do i get it to go to before save event to check the conditions then save. Currently if i want to print it, it saves the file without the conditions met. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)(works fine) if condition 1 then cancel = true if condition 2 then cancel = true else make directory save file with value in cell A1 End Sub Private Sub Workbook_BeforePrint(Cancel As Boolean) if condition 1 then cancel = true (same cindition in before_save) if condition 3 cancel = true else activeworkbook.save (it saves without going to before_save but it saves with the name in A1 if the file has not been saved before) End Sub I am using excel 2003 Any help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save excel file before printing | Excel Worksheet Functions | |||
How do I save printing option for all in a shared Excel workbook? | Excel Worksheet Functions | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) | |||
Getting "Save as PDF File" Dialog at end of printing to PDF using PDFwriter | Excel Programming |