VB handling on mdi print error code 1004

I am attempting to automatically print an mdi format file from Excel. When
the save menu asks for a name or cancel option, my visual basic program fails
with error code 1004 even though I have an on error statement. How do you
trap the cancel selection from the menu to avoid the vb program from quiting
with an error. When I use the On Error when attempting to print a PDF file
and the user selects cancel, it traps the error and the vb program continues
on to the GoTO address.

Thanks for any help.

>>When I use the On Error when attempting to print a PDF file and the user
>>selects cancel, it traps the error and the vb program continues on to the
>>GoTO address.

Every error handler must have a Resume statement associated with it. So (if
I understand you) when the user cancels your code jumps to your error
handler. In the error handler you have a Goto. That won't fly. Use Resume
instead of the Goto:

On Error Goto ErrHandler
''Potential error causing code
''other code
ResumeHere:
''other code
Exit Sub
ErrHandler:
''do stuff
Resume ResumeHere

--
Jim
"Walter L. skinner" <[email protected]> wrote in
message news:[email protected]...
|I am attempting to automatically print an mdi format file from Excel. When
| the save menu asks for a name or cancel option, my visual basic program
fails
| with error code 1004 even though I have an on error statement. How do you
| trap the cancel selection from the menu to avoid the vb program from
quiting
| with an error. When I use the On Error when attempting to print a PDF file
| and the user selects cancel, it traps the error and the vb program
continues
| on to the GoTO address.
|
| Thanks for any help.