Open Excel file from batch script and return message to batch script after closing it again

Question

I open an Excel file from the command line, using statement like this in batch file:

start /wait excel "myWorkbook.xlsb" /e/parameters

Inside the workbook, there is an auto-open macro which does something. In case of any errors I want to close Excel and send an error message back to the batch file. How to achieve that? Is it possible to quit the application with an error code or something like this?

into your auto-open macro, you can improve all error with: On Error GoTo ErrorHandler and then ErrorHandler: here you can put the code for display error message, send one mail with the error,... and then exit from excel — Fabrizio
– Fabrizio, Commented Jun 26, 2015 at 10:36

ChipsLetten · Accepted Answer · 2015-06-26 10:41:07Z

1

I don't think you can return an actual errorcode from VBA but to the batch file.

As mentioned by @Fabrizio you can add error handling code to your VBA. If you want your batch file to check if Excel was successful or not, then have the VBA error handler create a text file with details of the error and have the batch file check for the existence of the file. If the file exists, then batch file can rename it. This way you will also have a record of what the error was.

answered Jun 26, 2015 at 10:41

ChipsLetten

2,9531 gold badge15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Open Excel file from batch script and return message to batch script after closing it again

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related