folks,
I found a write-up on the webbrowser control to use with excel vba, read it, just what I needed i thought.
I have it in a user-form, just learning, and I used the ‘initialize’ routine and then added a list box and a combo box. then i found a problem:
1. All the controls I put in work as intended
2. But if I close the excel workbook [using excel2016], excel ‘closes’ but after the workbook contents disappear, excel itself hangs forever [I need to kill excel in the TaskManager]
It occurs to me that maybe the webbrowser control ‘doesn’t exit’?
Not sure I am saying this correctly: but if I disconnect web access [unplug the lan cable to my home network], the workbook opens/closes just fine [of course, the website doesn’t appear in the user form].
Do I need to link some event so that the webbrowser control ‘exits’ before excel closes?
OR
is there some event on the user form closing or excel closing that i can make the webbrowser control 'exit' first and prevent the hanging? [assuming this is the cause of the hanging issue]
If yes, do you know what ‘event’ that might be and/or which event is preferred? I’ve been checking the web, but can’t find quite how to accomplish that. [i'm sure i butchered this explanation, but i am not trained as a programmer, so i code by the bumper-car method when i have to code. sometimes that doesn't work - this is one of those times]
thanks,
ron
I found a write-up on the webbrowser control to use with excel vba, read it, just what I needed i thought.
I have it in a user-form, just learning, and I used the ‘initialize’ routine and then added a list box and a combo box. then i found a problem:
1. All the controls I put in work as intended
2. But if I close the excel workbook [using excel2016], excel ‘closes’ but after the workbook contents disappear, excel itself hangs forever [I need to kill excel in the TaskManager]
It occurs to me that maybe the webbrowser control ‘doesn’t exit’?
Not sure I am saying this correctly: but if I disconnect web access [unplug the lan cable to my home network], the workbook opens/closes just fine [of course, the website doesn’t appear in the user form].
Do I need to link some event so that the webbrowser control ‘exits’ before excel closes?
OR
is there some event on the user form closing or excel closing that i can make the webbrowser control 'exit' first and prevent the hanging? [assuming this is the cause of the hanging issue]
If yes, do you know what ‘event’ that might be and/or which event is preferred? I’ve been checking the web, but can’t find quite how to accomplish that. [i'm sure i butchered this explanation, but i am not trained as a programmer, so i code by the bumper-car method when i have to code. sometimes that doesn't work - this is one of those times]
thanks,
ron
