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 ?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.