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