Results 1 to 2 of 2

submit to website after file is created

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    submit to website after file is created

    I am trying to create a VB that will automatically submit a file (Sanger.txt) to a website, and save the data to an email address. Below is a code to try this. Any ideas? Thank you .

     Sub Login_OutputFile()
        Dim IE As Object, strURL As String
        Set IE = CreateObject("InternetExplorer.Application")
        strURL = "https://mutalyzer.nl/batch-jobs?job_type=position-converter"
        IE.Navigate strURL
         'Wait until page is loaded.
        While IE.ReadyState < 4 ' READYSTATE_COMPLETE = 4
            DoEvents
        Wend
        IE.Visible = True
         
        IE.Document.all("batchType").Value = "Position Converter"
        IE.Document.all("batchAssembly").Value = "Homo sapiens - GRCh37 (hg19)"
        IE.Document.all("batchEmail").Value = "cmccabe@luriechildrens.org"
        IE.Document.all("batchLoad").Value = "C:\Users\cmccabe\Desktop\annovar\Sanger.txt"
        IE.Document.all("batchFile").Click
        IE.Document.Forms(0).submit
         'Wait until page is loaded.
        While IE.ReadyState < 4 ' READYSTATE_COMPLETE = 4
            DoEvents
        Wend
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Submit options from dropdown menu and get data from website
    By zahoor1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2014, 06:31 AM
  2. VBA code to select dropdown value from a website form and submit
    By prabs_message in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:34 AM
  3. Help: Submit form to website (PHP System) and retrieve response in Excel
    By AMRayner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 10:53 AM
  4. Trying to submit a filename to a website form for upload.
    By mctabish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2010, 11:59 PM
  5. Creating macro that will submit email address on a website
    By thomasmale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2009, 10:10 AM

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