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
Bookmarks