TL DR version: what errors should I specifically look for in a error handler with an excel vba running a word template and saving as word doco and pdf.
For the first time, I am actually giving a macro spreadsheet to someone excel literate, but macro illiterate.
This spreadsheet basically opens a bunch of word templates, changes some bookmarks, saves as a word document and as a PDF.
I cannot afford for this spreadsheet to fail, which brings me to error handling.
I haven't really pushed into error handling too much previously. But I have come up with a list of possible errors the 3rd party could run into
Invalid Inputs (various)
Cannot find word templates
Cannot find bookmarks
Cannot Save As Word (various reasons)
Cannot Save As PDF (various reasons)
Not having Microsoft Word 16.0 object library
Is there any other errors I should be catching?
how do I deal with the Not having Microsoft Word 16.0 object library
?