C
CST
I have an Excel File (that contains VBA code) that gets created via
call on an ASP. The user can view this file as .xls, .pdf, or .html.
The file resides on the server and will get converted to either an
HTML File or PDF file. I have the proper mechanisms in place to
create these in my dll (basically opening the file and doing a save as
html or printout to acrobat distiller).
90% of the time, this works nicely, however there are times when an
unknown error occurs causing a dialog box to appear. In unattended
mode, this is a bad bad thing. I know that office automation on the
server is not good, but this seems to be the only way I know how to do
this. Ideally, my program would automatically see this dialog box,
close it, quit the respective Excel thread, then continue logging an
error. Any sample code I can "borrow" from you guys? I don't want to
reinvent the wheel as there have to be COM objects out there that do
exactly what I want. Any help would be appreciate.
TIA
call on an ASP. The user can view this file as .xls, .pdf, or .html.
The file resides on the server and will get converted to either an
HTML File or PDF file. I have the proper mechanisms in place to
create these in my dll (basically opening the file and doing a save as
html or printout to acrobat distiller).
90% of the time, this works nicely, however there are times when an
unknown error occurs causing a dialog box to appear. In unattended
mode, this is a bad bad thing. I know that office automation on the
server is not good, but this seems to be the only way I know how to do
this. Ideally, my program would automatically see this dialog box,
close it, quit the respective Excel thread, then continue logging an
error. Any sample code I can "borrow" from you guys? I don't want to
reinvent the wheel as there have to be COM objects out there that do
exactly what I want. Any help would be appreciate.
TIA