Results 1 to 3 of 3

Thread: Help Needed > Dynamic Web Query Date rate .ASP

  1. #1

    Help Needed > Dynamic Web Query Date rate .ASP



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    1. 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



    1. Querying the database directly (if this is possible)

    What would you guys advise ?

    Any help would be appreciated

    Thanks in Advance

    TWco !

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    I doubt that you'll be able to get access to the database directly, unless you can find the information you need at Windows Azure data market. So that pretty much means you need to go with option 1.

    Seriously... you want to go back to Feb 1, 2001?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Quote Originally Posted by Ken Puls View Post
    I doubt that you'll be able to get access to the database directly, unless you can find the information you need at Windows Azure data market. So that pretty much means you need to go with option 1.

    Seriously... you want to go back to Feb 1, 2001?
    I thought as much, will try and get cracking on the webqurey, if any one has any suggestions anything would be greatly appreciated.

    and yes unfortunately i do need to go all the way back to Feb 01

    TWCo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •