excel macro and java applet

[juanabreu]

hello I've been programing excel macros for about 3 years now and i
have come upon a real stumper. I have the a situation where i want to
loop through a worksheet and write the cell contents to a oracle web
form. My issue is that if it is a straight HTML form then it could be
done easily however this time what happens is that i end up with a
forms on a java applet. The only thing that i have been able to figure
out to get this done is using sendkeys, however it is a very
unreliable process since you cant shift focus of the form or it will
start sending the keys to window you have open.
Any thoughts or help would be appreciated.
Thanks
juan

 

[Tim Williams]

Is the applet sending data directly or via a <form> on the page?

If you want to see what's being passed via HTTP I'd suggest trying:
http://www.fiddler2.com/fiddler2/

Fantastic tool for debugging this type of problem.

Tim