When printing to PDF using C# + Excel Interop what is the best practice for detecting when the file has successfully printed or if there was a problem?
I need to know so that my app can take the generated PDF file, rename it, move it to a shared network drive, email it, etc. (Perhaps I should build a dedicated SSIS app to handle that part... hmmm... then I have an excuse to learn SSIS/BIDS)
Simply polling the directory until File.Exists() or we reach some maxTries cap is not a very satisfying way to handle it.
I am using VS 2008 Pro, Excel 2003 (11.0 Object Library), and Adobe Acrobat 7.0 Pro. Running on WinXP SP3.