+ Reply to Thread
Results 1 to 6 of 6

MS Forms 2.0 library Macro

  1. #1
    Registered User
    Join Date
    06-03-2011
    Location
    chertsey, england
    MS-Off Ver
    Excel 2007
    Posts
    19

    MS Forms 2.0 library Macro

    I seek a macro that can hold 7 pieces of manually copied data (from a website) in clipboard for inserion at 7 specific points in an excel worksheet (It will actually paste the first and then add the other 6 at specific points to lengthen the table first pasted). As clipboard normally holds only one data per time, it is said that the way to do this is to use the Data.Object in MS Forms 2.0 library. I am new to all these and therefore need your help. Thanks in advance.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: MS Forms 2.0 library Macro

    Did you ever explore a webquery ?



  3. #3
    Registered User
    Join Date
    06-03-2011
    Location
    chertsey, england
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: MS Forms 2.0 library Macro

    Frankly, I do not know how to do web query. However, others on the web have said that it is not possible to do so given that the data is mainly delivered by java script and the site is made in AJAX (whatever that means). I hope they are wrong and will gladly accept any help in that direction.

    Quote Originally Posted by snb View Post
    Did you ever explore a webquery ?

  4. #4
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: MS Forms 2.0 library Macro

    Here is the URL he is trying to copy/query:
    http://www.racingpost.com/greyhounds/card.sd

    See this thread for more information (note that the linked thread was originally about cleaning up an existing macro, whereas the OP is now requesting, if possible, to replace the current method of manually copying the tables and the running a cleanup macro with a macro that draws the data directly from the webpage to eliminate the need for a cleanup macro):
    http://www.excelforum.com/excel-prog...-outputes.html

    I really don't know anything about Data.Object in MS Forms 2.0 library and so recommended he start a new thread in the hopes of attracting a more knowledgable forum member.

  5. #5
    Registered User
    Join Date
    06-03-2011
    Location
    chertsey, england
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: MS Forms 2.0 library Macro

    Thanks Whizbang...you trully understand my position. Could not have explained any better. Thanks.

  6. #6
    Registered User
    Join Date
    06-03-2011
    Location
    chertsey, england
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: MS Forms 2.0 library Macro

    While roaming the internet for inspiration about this problem of getting data from racingpost, I came across this code which gets some information from that website. While it is not exactly for greyhounds, I think it might inspire someone who understands codes, to help me. Thanks in advance.
    Please Login or Register  to view this content.
    Last edited by bertlogdi1; 06-15-2011 at 03:53 PM. Reason: code amendment due to incomplete copying last time

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1