Copy webcontent to a document

elmnas · #1 07-14-2014, 05:53 AM

Hello all VBA Members

I am trying to auotmate a process of word

I get lots of different wordjobs, they always have a job number, for example 741443
we have a webpage where we can see all active jobs, as we see both job numbers (741443)
and also an EP-number (E7295_EP2586715)

I want to copy this part of the EP-number (EP2586715) to a word document.

the word document is always in the folder called 741443.

my problem is, when there are several different jobs with different EP-numbers,
the macro need to copy the correct EP-Code from the webpage to the document.

here is a picture

how it looks like

Attachment 116359

Do have someone a solution for this?

here is a sample I did,
but the pastemethod doesn't work

HTML Code:

Sub CopyWebContent()
 
    
Dim IE As Object
Dim rng1 As Range
Dim thisdoc As Document
Dim newdoc As Document
Dim st
Set thisdoc = ActiveDocument
Set newdoc = Documents.Add
Documents(thisdoc).Activate
           
 
    
    Set IE = CreateObject("InternetExplorer.Application")
    With IE
        .Visible = True
        .navigate "tsq/"
        Do Until .ReadyState = 4: DoEvents:  Loop
        End With
        IE.ExecWB 17, 0 '// SelectAll
        IE.ExecWB 12, 2 '// Copy selection
     
   
               Selection.Paste
 
    
   
       Set rng1 = Selection.Range
 
       '  IE.Quit
        
    End Sub

Thank you in advance all VBA Members

Cheers!

Daniel

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Toolbar Icons into tutorial document	GreenBoy	Word	2	06-22-2014 12:12 PM
Copy table to another location in the same document	Sektor	Word VBA	2	03-31-2014 09:28 PM
Anyway to copy a complete page full of objects into a new document?	MuffinStud	Word	1	12-20-2012 04:43 AM
Copy only Tables of a Document	Loretti	Word	1	11-12-2012 03:35 PM
Copy from one word document to another no identical	gmurphy	Word	3	09-07-2011 04:28 AM