Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activate a page of a Multipage in Userform | Excel Discussion (Misc queries) | |||
Is it possible to disable a tab/page on a multipage Userform? | Excel Programming | |||
Userform into Web page | Excel Programming | |||
How to print a page of a multipage userform | Excel Programming | |||
Hide a page in a multi page userform | Excel Programming |