ppDisp to display popup into form2

I'd have replied to this over at Oz, but I can't post in the Hire section. I also answered you at EE - Hi again

Honestly, you're flogging a dead horse with this one. Excel VBA <> VB6 it's a stripped back version, all the guides you see out there assume VB5/6, Excel doesn't handle forms in the same way, so when you're using controls on a form that are really designed for use with VB6 you'll find they often lack some of the functionality they offer in a proper environment. As a further example with the webbrowser, you'll notice that you can't put it on a multipage control, when you switch pages and come back, it disappears.

It's just one of the things you have to work with since you are using controls that were designed for a different environment, some of them work well, others not so well and others not at all

I suggested Access on EE since the VBA is more rich and far closer to VB6, I think you'll have more luck there - Or maybe you could try VB6, or if you're feeling really adventurous, VB.NET?

VB would be less of a learning curve than .Net, although it looks similar, it's very different, but it would give you a whole load more control.

Did you try changing .object to .application in access?

The only thing I can suggest as a work around would be to have the 2nd webbrowser on the same form but off the side of the visible range, then just resize the form so that it is visible.

Are you talking about trying to catch the javascript onchange event?

Yes I did try changing it and it didnt work. I tried doing the second web browser on the same form, but once the popup closes, the web browser control closes entirely, so the new window event would need to create the control each time the event happens. As well, the two popups that can occur are: data entry and links. the links dont have a way to "cancel" the popup once clicked, so you cant make them go away without the ability to close. the data entry ones are fired by javascript onchange. Lets say html looks like this:

Please Login or Register  to view this content.

This way, I would look for the ID of where the onchange occured (say status0) and I would write the data back to comments0, because the two fields will always be related, e.g. firing onchange on status3 will always write to comments3, and that could be handled by a userform instead, that was the other idea, which would maybe make more sense

new window event would need to create the control each time the event happens

Have you tried doing that, but creating a new browser on the form each time?

the links dont have a way to "cancel" the popup once clicked, so you cant make them go away without the ability to close

If you can get the previous working, you can add a button to close the browser to your form.

I'd try doing the above before the javascript approach since it's less fiddly

how would I go about creating a new web browser control each time? I can only find things on creating one inside the spreadsheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The above works for me, scroll down to one of the links in the thread, the popup opens in the dynamically added browser

You'll need to add a class to handle events of the created webbrowsers

ppDisp is actually nothing, but to understand why that is, you need to understand a bit about how events work.

Events are raised by procedures like normal functions, in VBA you'd do this with the RaiseEvent statement. These events then create subs in the parent object, so you see:

Please Login or Register  to view this content.

So conceptually, what's actually happening within the WebBrowser1 object:

Please Login or Register  to view this content.

So the above code raises the event, which manifests in your WebBrowser1_NewWindow2 sub which you then assign values to its parameters e.g

Please Login or Register  to view this content.

These values are then passed to the calling sub which raised the event and used in its own code as shown above, it's not massively helpful since you can't check the values of ppDisp since it's nothing, but you can at least understand why.

You're therefore going to need to figure out a work-around, but I can't really suggest anything since I don't know how the actual new windows are being raised

since we are creating an instance of explorer shell, is it possible to include something like:

Please Login or Register  to view this content.

in order to add a close button (that adds the two others but is for sake of example)

Not for the Webbrowser, you'd need to create a button to close.

To get the location of a webbrowser:

Please Login or Register  to view this content.

You can only use it after the page has navigate so not in your NewWindow2 sub

Originally Posted by Kyle123

Not for the Webbrowser, you'd need to create a button to close.

To get the location of a webbrowser:

Please Login or Register  to view this content.

You can only use it after the page has navigate so not in your NewWindow2 sub

So I will be unable to test the URL until the page has loaded, which will not do. Right now I set:

Please Login or Register  to view this content.

Commandbutton code:

Please Login or Register  to view this content.

Say I generate a popup, I dont click the button to close and I let the webpage close the control out, then generate another popup again, the button wont work because it doesnt know how to remove that new control, since it is named different. I think I need to capture the names of the controls thats generating. Do you know how the naming conventions generate?

works like a charm! I hope I can gain the knowledge you have one day! Thanks so much!