Results 1 to 2 of 2

Thread: Web Scrapping - Download PDF after submitting Policy
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Web Scrapping - Download PDF after submitting Policy

    I want to download the PDF file after pressing "Continue" with below code...

    ================================Code=========================
    Sub automaticformfilling()

    Dim ie As Object

    Set ie = CreateObject("internetexplorer.application")

    '1 GoTo website

    With ie
    .Visible = True
    .navigate "https://www-400.aig.com/vl/emarine/home1?ACTION=home"
    'Wait for loading
    Do While .busy
    DoEvents
    Loop

    Do While .readystate <> 4
    DoEvents
    Loop
    For Each continuebuttonfilled In ie.document.getElementsByTagName("input")
    If continuebuttonfilled.getAttribute("value") = "Continue" Then
    continuebuttonfilled.Click
    Exit For
    End If
    Next continuebuttonfilled

    Do While .busy
    DoEvents
    Loop

    Do While .readystate <> 4
    DoEvents
    Loop
    =================================code===============================

    I want to download PDF file and save it to activeworkbook's folder.

    If anyone can suggest how to execute the code for download, I can proceed further.
    =====================================Internet Explorer====================================





    ****** http-equiv="Content-Type" content="text/html" charset="iso-8859-1">
    ****** name="GENERATOR" content="Mozilla/4.72 [en] (WinNT; I) [Netscape]">
    Display Quote PDF
    ******** language="JavaScript" type="text/javascript" src="/escreens/js/aig_stylesheets.js">*********>









    ****** bgcolor="#FFFFFF"><br /> <br /> </body>

    =====================================Internet Explorer====================================

  2. #2
    New Member
    Join Date
    Oct 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Web Scrapping - Download PDF after submitting Policy

    FULL PAGE SOURCE AS BELOW



    ****** http-equiv="Content-Type" content="text/html" charset="iso-8859-1">
    ****** name="GENERATOR" content="Mozilla/4.72 [en] (WinNT; I) [Netscape]">
    Display Quote PDF
    ******** language="JavaScript" type="text/javascript" src="/escreens/js/aig_stylesheets.js">*********>









    ****** bgcolor="#FFFFFF"><br /> <br /> </body>

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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