+ Reply to Thread
Results 1 to 4 of 4

VBA Excel: Writing to URL and Copying Data

  1. #1
    Registered User
    Join Date
    06-06-2016
    Location
    USA
    MS-Off Ver
    13
    Posts
    6

    Question VBA Excel: Writing to URL and Copying Data

    Hello

    Basically I have a folder full of .txt. files. I would like to take each of those files' contents, and paste it into http://free-article-spinner.com/. I would be fine with entering the CAPATCHA, but I believe there is a way to easily extract the CAPATCHA and solve it (since its a simple math problem, vba? or is there a way to use java in vba?). If so the program would then paste the CAPATHCHA answer, if not possible, then program would prompt me to enter CAPATCH.

    Then it would take the "output text" and paste it into an excel cell. It would do this for all the files.

    Is this possible/can someone point me in the right direction.

    Thanks
    Last edited by sawvba; 06-06-2016 at 03:47 PM. Reason: title change

  2. #2
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Help with creating VBA program

    Hello...

    You should change your thread's name... The MODs will ask you to do it

    Check here: http://www.excelforum.com/forum-rule...rum-rules.html

    Rule 1
    If I have solved your question, please mark the thread as [SOLVED],
    And consider adding reputation

    ?Simplicity is the ultimate sophistication? (Leonardo Da Vinci)

    Regards,
    F?bio Gatti

    https://www.youtube.com/pulodogatti
    https://www.linkedin.com/in/fabiocgatti/
    https://instagram.com/pulodogatti

  3. #3
    Registered User
    Join Date
    06-06-2016
    Location
    USA
    MS-Off Ver
    13
    Posts
    6

    Re: VBA Excel: Writing to URL and Copying Data

    Okay I will clear it up

    I have finished most of my program. However, I am having issues. I am using this website http://free-article-spinner.com/

    1. I want to copy my text to the input text.
    2. Solve the CAPATCHA (it is someone easy and i can do it in java but not familiar with how to retrieve it in VBA)
    3. Enter CAPATCH (if 2, is not possible, I will be fine with manually entering the CAPATCHA)
    4. Click "Spin Text"
    5. Copy "output text" back to excel document

  4. #4
    Registered User
    Join Date
    06-06-2016
    Location
    USA
    MS-Off Ver
    13
    Posts
    6

    Re: VBA Excel: Writing to URL and Copying Data

    Okay, update: my only issue is trying to get my output text back from the output text textarea.

    Can someone point me in the right direction?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating a house points scoring program
    By 167notout in forum Excel General
    Replies: 6
    Last Post: 09-29-2015, 08:22 PM
  2. Creating a complex program...
    By VolInsp-Imp in forum Excel General
    Replies: 6
    Last Post: 05-09-2012, 07:49 PM
  3. Creating a program around a workbook
    By redkilner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2012, 09:14 PM
  4. Creating a selector program - help creating the dropdown menus
    By MattP299 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2011, 03:19 PM
  5. Creating a executable VB program
    By fabb2004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2010, 05:53 AM
  6. Help creating a program
    By fragle123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2008, 06:37 AM
  7. [SOLVED] help creating labour program
    By bpman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2005, 03:06 AM

Tags for this Thread

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