Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
activate a page of a Multipage in Userform Jeff Excel Discussion (Misc queries) 1 February 8th 08 06:16 PM
Is it possible to disable a tab/page on a multipage Userform? Trefor Excel Programming 4 April 19th 06 05:24 PM
Userform into Web page Marcolux Excel Programming 0 March 3rd 06 07:20 PM
How to print a page of a multipage userform Jean-Pierre D via OfficeKB.com Excel Programming 3 August 15th 05 05:29 PM
Hide a page in a multi page userform Ian Mangelsdorf Excel Programming 1 October 27th 04 09:06 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"