copying excel cells with link via macro

I

ikeriba

Hi!
(Powerpoint 2000)
I have to copy some cells from an Excel table in my
PowerPoint presentation. I know how to do it manually,
copying the cells in the Excel window and pasting
with "paste special" in the PowerPoint window, but I want
to do it with a macro in an automatic way.

I use "record new macro" and I do it manually, but
afterwards, when I run the macro, doesn't work. It seems
to be that Powerpoint is not able to open a new window
with Excel to copy the cells from. How can I program this
in a macro?

Thanks!
Iker
 
S

Steve Rindsberg

Hi Iker,

PowerPoint's macro recorder only records actions that you perform within
PowerPoint, never anything you do in Excel, MSGraph, OrgChart or any of the
external "helper" applications that come with PowerPoint ... though I'd get
lynched in the Excel newsgroup for calling it that <g>.

This links to Excel MVP John Peltier's site, which'll give you a good start on
automating Excel:

Driving Excel from PowerPoint. Driving PowerPoint from Excel. And so on.
http://www.rdpslides.com/pptfaq/FAQ00368.htm

Hi!
(Powerpoint 2000)
I have to copy some cells from an Excel table in my
PowerPoint presentation. I know how to do it manually,
copying the cells in the Excel window and pasting
with "paste special" in the PowerPoint window, but I want
to do it with a macro in an automatic way.

I use "record new macro" and I do it manually, but
afterwards, when I run the macro, doesn't work. It seems
to be that Powerpoint is not able to open a new window
with Excel to copy the cells from. How can I program this
in a macro?

Thanks!
Iker

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top