macro exports value

[xam99]

Hi to all
This macro doesn't work
Run-Time Error 438 Property or method not supported by the object

Please Login or Register  to view this content.

a help?
Thanks you
xam

[Bob Phillips]

Try this

Please Login or Register  to view this content.

[xam99]

Hi now error here

sh1.Range("R:R").Copy
sh2.Range("R:R").Paste '<<<<

[Bob Phillips]

Try replacing with

Please Login or Register  to view this content.

[xam99]

Erroer here

sh1.Columns("R").Copy
sh2.Columns("R").Paste '<<<<

[xam99]

This opens the workbook but I don't see it

Please Login or Register  to view this content.

then mistake here:

Please Login or Register  to view this content.

I enclose 2 examples to try

[xam99]

I corrected the attached file, the path was wrong.
But it doesn't open the file prova 2021 correctly and doesn't paste