Run Time Error '1004' PasteSpecial method of worksheet class failed

[Nelson78]

Hello everybody.

I'm grasping datas from a website via vba, but I'm struggling with the

Run Time Error '1004' PasteSpecial method of worksheet class failed

This is the impacted part of the code:

    IE.ExecWB 17, 0            ' SelectAll
    IE.ExecWB 12, 2            ' Copy selection
    ActiveSheet.PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False
    Range("A1").PasteSpecial

The code selects all correctly (I see the highlighted page).

The error is, of course, on the following line:

ActiveSheet.PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

Any ideas?

 

[mole999]

so what does Activesheet point to when due to paste, 1004 usually indicates something is missing, you have NO range identified !

 

[Nelson78]

In this way the same error:

Workbooks("Cartel1").Worksheets("Sheet 1").PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

Could it be a problem of a large amount of datas?

 

[Nelson78]

Removing the line with the error, it seems to work.
But I don't know if I can remove link and images.

    IE.ExecWB 17, 0            ' SelectAll
    IE.ExecWB 12, 2            ' Copy selection
    
    Range("A1").PasteSpecial

 

[mole999]

what would
Workbooks("Cartel1").Worksheets("Sheet 1").range("a1").PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

Do

 

[Nelson78]

Above the attempts:

1)

Workbooks("Cartel1").Worksheets("Sheet 1").Range("a1").PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

Run Time Error 1004 'Application Defined or Object Defined Error'

2)

Range("a1").PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

Compile error: can't find predefined argument
(or something like this, I haven't found the exact translation in english)
highlighting on

Format:=

3)

Range("a1").PasteSpecial

This is ok but with the legacy of links and images.