Getting a value from a web page to put in a userform
 

Hello -
I am searching feverishly for a way to accomplish an unusual task. Let me
start by what I want to accomplish and then what I have tried. I want a vba
form that can access ebay categories without storing (and updating) the
coplex xml file locally. Instead, I want to access an external Java Applet.
I have created an html with the Java Applet on it and a vba userform that
uses the "followlink" method to open it and Javascript to access the
userform using the "opener" method. The opener method does not seem to apply
to non-web openers (as I expected). The best I can do with my abilities is
to have the user copy the category ID from the html and paste it into the
userform. I want it to be better than that... Any ideas?
--
Thanks,
Mike

Getting a value from a web page to put in a userform
 

Not clear exactly where the HTML page is hosted.
In a webbrowser control? In IE via automation ?
Some (brief) sample code might be illuminating.

If the js in the HTML page is not able to access the userform then you may have to do it the other way round (access the HTML page
from your VBA)

You might also try "window.external" rather than "window.opener"

Tim


"Mike Archer" wrote in message ...
Hello -
I am searching feverishly for a way to accomplish an unusual task. Let me
start by what I want to accomplish and then what I have tried. I want a vba
form that can access ebay categories without storing (and updating) the
coplex xml file locally. Instead, I want to access an external Java Applet.
I have created an html with the Java Applet on it and a vba userform that
uses the "followlink" method to open it and Javascript to access the
userform using the "opener" method. The opener method does not seem to apply
to non-web openers (as I expected). The best I can do with my abilities is
to have the user copy the category ID from the html and paste it into the
userform. I want it to be better than that... Any ideas?
--
Thanks,
Mike