Hi Guys,
I am quite new to VBA but am a quick learner what I am looking for her is just:
a) some validation on what I am trying to do is possible
b) Some guidance on how to best go about it.
Basically what I am trying to do is build a price database of J-34 cotton from the webpage http://www.caionline.in/spot_rates.asp since inception.
my two initial thoughts were
Any help would be appreciated
Thanks in Advance
TWco !
I am quite new to VBA but am a quick learner what I am looking for her is just:
a) some validation on what I am trying to do is possible
b) Some guidance on how to best go about it.
Basically what I am trying to do is build a price database of J-34 cotton from the webpage http://www.caionline.in/spot_rates.asp since inception.
my two initial thoughts were
- run a webquery for the whole price table then sort the data using another macro which would require it navigating the drop down menu
or
- Querying the database directly (if this is possible)
Any help would be appreciated
Thanks in Advance
TWco !