.Shapes.PasteSpecial(Link:=True) from Excel Range to ppt fails

[vichopalacios]

Hi everybody

I'm trying to copy a range from a worksheet, and paste it "Linked to the source".
I have a Power Point file with 2 blank slides named Test.pptx

The partial code I post here copies a first range and pastes it by default conditions, and goes OK
the second range, I try to paste and link to the source, but I only get error
I've tried diferent options I found over the web, but no one works.

It must be something simple I'm mistaking.

Please Login or Register  to view this content.

Your help will be very appreciated

[kev_]

Are you sure your code fails where you say?

This runs:

Please Login or Register  to view this content.

But this does not:

Please Login or Register  to view this content.

Perhaps amend the last line to:
either

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[vichopalacios]

Hi Kev

Thank you for taking the time...

Are you sure your code fails where you say?

Yes, I'm pretty sure, and you can see here in the image:

As I said in the original post, the first range fron Hoja1 is copied and pasted to Slide1 correctly.
So I don't need to change anything in this part, as it is not intended to be linked.
Then the range from Hoja2 is copied and it actually gets pasted, but the code goes on error and stops.
If I clear the error manually, the table IS in the ppt, and IS LINKED,
my problem is to understand where the error comes from, and how to solve it.

[vichopalacios]

Sorry, I'm having some problems uploading the image attachment
I hope here it goes now
if not, I'll try later to upload it

[vichopalacios]

Sorry, I'm having some problems uploading the image attachment
I hope here it goes now
if not, I'll try later to upload it

[kev_]

There should be an error number and description - what are they?

Put this in your code
the line before VBA crash

Please Login or Register  to view this content.

on line after VBA crash

Please Login or Register  to view this content.

What's does the message box say?

The above code (without MsgBox Err.Number & vbCr & Err.Description) should keep your VBA working and the macro should finish normally

[vichopalacios]

Hi Kev

The error shown is ( my system is in spanish):

Se ha producido el error '424' en tiempo de ejecución:
Se requiere un objeto

which translated into english means something like "an object is required".
When I put the message box, is the same 424 error, object required

And YES, of course I used the

Please Login or Register  to view this content.

to avoid the problem, but i was wondering where it comes from.

This little piece of code, actually belongs to a larger and more complex process, so I do prefer to SOLVE the errors, rather than COVER or HIDE them.
Again, thank a lot for your time, if you wish, keep with me trying to decipher the mistake.
I'll keep looking for a solution.

[kev_]

Try this code on its own and let's see what happens. Let me know

Please Login or Register  to view this content.

[vichopalacios]

Compile error:
Sintaxis error in

Please Login or Register  to view this content.

I went over this before, and tried using the possibilities that intelisense gives,
.aply
.select
there is no .paste
but no help at all

[kev_]

Sorry! Somehow I dropped off the .select - oops!!

Please run this amended code on its own
- will prove whether the problem is with this bit of code or elsewhere

Please Login or Register  to view this content.

[vichopalacios]

I also used

Please Login or Register  to view this content.

and some other variations working with the help of intelisense
no one solved.
this particular one did the same as the original

Please Login or Register  to view this content.

and again, went into the same error

[kev_]

we posted at same time!
I want you try my short code
see post#10

[vichopalacios]

I've been fighting with this for a few days, and all the tests tell me that the problem is in the

Please Login or Register  to view this content.

when trying to link to the source.

[vichopalacios]

yes
I saw and tested post 10
the same exact error

[vichopalacios]

when I put the same sintaxis but with false

Please Login or Register  to view this content.

there is no error

[xlnitwit]

Hi,

Do you still have the error with this

Please Login or Register  to view this content.

[kev_]

Can you try without VBA
Have workbook and presentation files open

Go into workbook and select Sheets("Hoja2").Range("B6:E15")
then {CTRL} + c (to copy)
Then select presentation, click on slide(2)
then on Home tab:
click "down arrow" on Paste
+ PasteSpecial
+ PasteLink
+ OK

Does it allow you to do that?
Can you now go into the worksheet and amend the values and see them change in the slide?

PP PasteSpecial Link.jpg

[vichopalacios]

Kev
Yes, As I said in the beginning it works manually.

xlnitwit ::::: YEAH !
It works !

I still cannot deal why, but it works
the only real difference, as I can see is .Item(1)
Do you have an idea of why ?

[kev_]

Well done @xlnitwit!

[xlnitwit]

I admit I do not know why the original fails but it is unnecessary to select the shape so it seemed expedient to avoid it.

[vichopalacios]

The mistery of MSOExcel !!
Thanks a lot xlnitwit

[vichopalacios]

The mistery of MSOExcel !!
And thanks Kev, too

If you guys, find a real explanation, please share with us

[kev_]

Agreed
- your original code works on my PC - where is the logic in that!!

[vichopalacios]

After all the research I've been doing, and considering my very short experience with VBA in Power Point, I shuold say the error depends on the PP version, and has nothing to do with Excel.
There are a lot of codes around the web, using that line, and almost nobody report that problem.
Anyhow, thanks for your time.....have a nice day

Vicho