Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ehandler
I want Errorhandler1 to give the option to save the file to server3. As it is
now just ends. I can't seem to find the right code On Error GoTo ehandler1 'Revised saved order 6/09/08 quotenumber1 = InputBox("Please enter QUOTE file name to save to your C drive & Server3", _ "x Technologies LLC", NUMBERSAVE) QUOTE = "C:\Quick Quotes3\" & NUMBERSAVE & ".XLS" ActiveWorkbook.SaveAs Filename:=QUOTE On Error GoTo ehandler2 QUOTE1 = "\\server3\jobs\estimate1\Quick Quotes3\" & NUMBERSAVE & ".XLS" ActiveWorkbook.SaveAs Filename:=QUOTE1 ActiveWorkbook.Close 'End 6/09/08 revision Application.Goto Reference:="InPutForm" Range("AB2").Select MainMenu.Show vbModeless Exit Sub ehandler1: MsgBox "You cancelled the save or an error has occured connecting to the C:\Quick Quotes3\. Check your C: drive and try again ", vbCritical + vbOKOnly, "File not saved!" ActiveWorkbook.Close Windows(MasterSheet).Activate Sheets("Input").Select MainMenu.Show vbModeless Exit Sub ehandler2: MsgBox "You cancelled the save or an error has occured connecting to Server3. Check your connection and try again ", vbCritical + vbOKOnly, "File not saved!" ActiveWorkbook.Close Windows(MasterSheet).Activate Sheets("Input").Select MainMenu.Show vbModeless Exit Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ehandler
Sorry I double posted this because I got an error message that said the site
was not available and to try later "Oldjay" wrote: I want Errorhandler1 to give the option to save the file to server3. As it is now just ends. I can't seem to find the right code On Error GoTo ehandler1 'Revised saved order 6/09/08 quotenumber1 = InputBox("Please enter QUOTE file name to save to your C drive & Server3", _ "x Technologies LLC", NUMBERSAVE) QUOTE = "C:\Quick Quotes3\" & NUMBERSAVE & ".XLS" ActiveWorkbook.SaveAs Filename:=QUOTE On Error GoTo ehandler2 QUOTE1 = "\\server3\jobs\estimate1\Quick Quotes3\" & NUMBERSAVE & ".XLS" ActiveWorkbook.SaveAs Filename:=QUOTE1 ActiveWorkbook.Close 'End 6/09/08 revision Application.Goto Reference:="InPutForm" Range("AB2").Select MainMenu.Show vbModeless Exit Sub ehandler1: MsgBox "You cancelled the save or an error has occured connecting to the C:\Quick Quotes3\. Check your C: drive and try again ", vbCritical + vbOKOnly, "File not saved!" ActiveWorkbook.Close Windows(MasterSheet).Activate Sheets("Input").Select MainMenu.Show vbModeless Exit Sub ehandler2: MsgBox "You cancelled the save or an error has occured connecting to Server3. Check your connection and try again ", vbCritical + vbOKOnly, "File not saved!" ActiveWorkbook.Close Windows(MasterSheet).Activate Sheets("Input").Select MainMenu.Show vbModeless Exit Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|