ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SHdocVw event problem (https://www.excelbanter.com/excel-programming/407764-shdocvw-event-problem.html)

JU

SHdocVw event problem
 
Hi,

There is a webbrowser component as a part of my app. I need it to run without any user interaction (no dialog boxes, msgboxes, runtime errors). What it does (or should do :) is getting link collection, process them in underlayed Excel sheet (compare, filter and so on) and then visit each of the linked page, grab the content, parse some data, process and display.
The problem is:
I'd like to avoid even attempt to open files such as doc, pdf, ppt, etc. which cause displaying dialog box (Open, Save, Cancel) thus need user attention.
Event object.Filedownload never fires. It is supposed to fire before that dialog box is displayed and theoretically can trigger sub to handle it e.g. Cancel = True.
Any tips?

Regards,
Jarek


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com