Asked by duncanb7
at 2024-09-14 05:37:38
Point:500 Replies:15 POST_ID:828366USER_ID:11059
Topic:
Java Programming Language;Visual Basic Programming;Microsoft Excel Spreadsheet Software
I've purchased one stock price streaming data software with monthly fee. The software doesn't provide the data to be stored
into excel format. Now I only know the live price data is coming from Java Applet frame after looking into the software web page
original HTMl code. And I know I could not use Web Query table
to extract the data. My question is there is any method to extract the Java Applet live data into my excel file by VBA from Java .
SInce the live data is allowed to send to my computer with the license, I should be able to collect it by VBA programming. IS it easy
and possible ?
Please advise
Duncan
into excel format. Now I only know the live price data is coming from Java Applet frame after looking into the software web page
original HTMl code. And I know I could not use Web Query table
to extract the data. My question is there is any method to extract the Java Applet live data into my excel file by VBA from Java .
SInce the live data is allowed to send to my computer with the license, I should be able to collect it by VBA programming. IS it easy
and possible ?
Please advise
Duncan