How do I trap dsofile method errors with VB or VBA?

B

brzezij

I am using dsofile to collect MSword and MSExcel summary properties and save
them in an ACCESS .mdb. Generally it works fine but on older excel and word
files, I get an summaryobject method error, which I have been unable to trap
with on error goto errorhandler. I can go to debug but have to manually set
the next command to the first command line in the error handler since the
goto doesn't happen automatically.

Is there a way to trap the error programmatically and not end up with
interrupts that need manual intervention?
 
Top