Paste Link code (Excel to PPoint)

[noboffinme]

Hi

I'm trying to replicate the Paste Special method in Excel where you can choose to 'Paste Link' (as an MS Excel Worksheet Object) into Powerpoint using VBA code.

Manual method;

Copy the object in Excel (table, chart), Open Powerpoint, select Edit >> PasteSpecial >> Select the 'Paste Link' radio button & the MS Excel Worksheet Object option is highlighted.

In the Object Browser, ther's almost everything apart from the option to Paste Link.

Also, I then want to break the links after this is done for each loop.

The reason I need this particular methos is that it presents the object very clearly on the slide whereas other methods are not as good.

Any ideas/links welcome, Thanks

 

[dfenton]

Is DoCmd.RunCommand acCmdPasteAsHyperlink what you want? It's not clear from your question what the context is.

 

[noboffinme]

Thanks dfenton

I'll give it a try to see if it's similar to something I've been trying that does replicate the format I need.

I tried ,in the pasting formats available, the below;

PPSlide.Shapes.PasteSpecial(ppPasteOLEObject).Select

I think this is the code I need as it pastes as an object linked to the PPoint Presentation & appears exactly the same on the slide as if I did it manually.

I then want to break the link created after pasting the object while in the same For.. Next loop, I have some code that I need to adapt;

'objWorkbook.BreakLink xlLinkTypeExcelLinks

If you have any ideas about breaking linked files, I'd appreciate your views, Cheers

 

[dfenton]

I just noticed that your subject heading says "Excel to PPoint". I read this site under the assumption that since it's doman name is "access-programers.co.uk" it's a site devoted to Access, so when a post doesn't involve Access, I might give an inapplicable answer, as in the case, i.e., citing a constant that exists in Access, but I have no idea if it exists in PowerPoint (which I don't use; I also know no one who uses it and don't understand why anyone would).

If you want to get anwers about Powerpoint on an Access site, perhaps you need to add some neon flashing signs to your post (something other than a laconic parenthetical in you post subject).

 

[noboffinme]

Hmmmm, not sure how much clearer I can make it apart from declaring this in the heading......

Thanks for your help anyway.

Btw, an Access type answer would have also been useful as it probably would have beeen the same.

 

[dfenton]

Hmmmm, not sure how much clearer I can make it apart from declaring this in the heading......

You're perhaps assuming too much about the context in which people read your posts. I run a search on particular search terms, and tend not to notice the actual subject headings (particularly parentheticals). I have also noticed that it's just a good idea to repeat any crucial parameters that you mention in the subject heading in the text of your post as well.

Btw, an Access type answer would have also been useful as it probably would have beeen the same.

My answer *was* an Access one, but I wouldn't assume that the named constants are the same between different Office programs. Had I noticed the question was about Powerpoint, I simply would have moved on to something else, since I wouldnt' have anything to offer, and hence avoid wasting everyone's time!

 

[noboffinme]

dfenton

As I recall, this all began when you didn't read the above question & heading correctly.

Since then you've been trying to justify (argumentatively) why you're right & everyone else is wrong.

Don't bother & I'll get my answers from forum users that CAN read a question & heading without the drama..........

Btw, If your input doesn't include a reference to the question posed, you shouldn't be posting anything.

 

[dfenton]

I'm not trying to justify anything. I'm attempting to give you ADVICE on how to get the best answers. The people who are going to help you are human, and they can miss details just like I did. I was not intending to say it was unreasonable for you to have posted that way, just that there are better ways to post that increase the chances of getting good answers.

But if you want to get in a snit instead of saying "thanks for the advice," that's OK, too.

 

[vbaInet]

Hi

I'm trying to replicate the Paste Special method in Excel where you can choose to 'Paste Link' (as an MS Excel Worksheet Object) into Powerpoint using VBA code.

Manual method;

Copy the object in Excel (table, chart), Open Powerpoint, select Edit >> PasteSpecial >> Select the 'Paste Link' radio button & the MS Excel Worksheet Object option is highlighted.

In the Object Browser, ther's almost everything apart from the option to Paste Link.

Also, I then want to break the links after this is done for each loop.

The reason I need this particular methos is that it presents the object very clearly on the slide whereas other methods are not as good.

Any ideas/links welcome, Thanks

There's an Excel section on the site. Ask your question on there and I'm sure someone with expertise on Excel related issues will be able to help.