新聞財經娛樂♬資訊 News Economy

I have one stock placement order input form from bank account provided. I would  like to do VBA code
to access the placement html page  after login in my bank account from VBA automation programming.
After login, I navigate https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do?BV_UseBVCookie=Yes&sell=B%7C66921%7C1000%05123 in vba code
sell=B, where B means BUY or S mean SELL  for select radio button in the input form for stock order
66921 means for stock name number in the input form
1000 means for lot size for stock in the input form.

The edit of stock number of 66921 and lot size of 1000 is okay in URL bar  and no problem at all and it is shown in the
input form of placement order html page
But the question when I try to input stock price in URL address bar like 123 that is not shown in the form and
then I put %05 or %09 for simulating TAB key before stock price of 123 that is still not shown up too.
It is shown into lot size input box of the form  instead of price box like this as follows

OrderForm
========
Order TYPE :    o  BUY or  o SELL
Stock code: 66921
Stock Lots:   1000 123
Price:
Any suggestion for simulate TAB key code in URL bar ? And I am using IE7 in windows vista

Why, I'm NOT using DOM's  getelementbyName("price")=123 in vba because I could like to speed up
submit form speed instead of too much coding for  input each single input field in the input form like, ordertype,
stocknum, stocklotsize, stock prize.

Please advsie

Duncan

C++ is probably much faster than VBA; Java maybe/maybe not.
However, most of this will be controlled by the speed of your internet connection to the server, your ISP, and their server.  Using VBA to update the contents of a webpage will probably be quite fast unless it's a very complex page.

As for using the address to send the information, unless the hosting site supports it, it will never work.  If they simply don't accept the information you send, it will never get processed.

(I will be gone until Monday.  If you need additional help, you can try to add a low-point question and ask experts to look at this further.)

I don't think that's quite how it works.  The address link contains blocks of information that is arbitrarily interpreted by the code running behind the scenes.  In this case:

https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do?BV_UseBVCookie=Yes&sell=B%7C66921%7C1000%05123

is split into parts:
* secure http
* online-banking.com domain
* cgi-bin/ibnkprdhk/ist/order/orderPlacement.do program
* BV_UseBVCookie=Yes&sell=B%7C66921%7C1000%05123 parameters supplied to the program

typically the program will split it based on the "&" and take all the text next to it and put it into the field
so you get:
BV_UseBVCookie=Yes
sell=B%7C66921%7C1000%05123

In this case, it seems to be further splitting it on code 7C to get: a list of values: B, 66921, 1000?123

Assuming that the program will interpret your value, it should probably be separated by another %7C:
sell=B%7C66921%7C1000%7C123

If that doesn't work, the only way to rea;lly do this is to write a program to intercept the browser and grab the data out of the address and parse through the page to find the right place to put the data, then insert it--no easy task (as you apparently know)