Automation!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 29 May 2005 00:59 GMT

Hi folks,

I need a big help for my power point project. I have an excel file
(worksheet) which have a chart on the top and data table at the bottom.

I want to copy the data table (the colume and the row may be vary.) and
chart to the power point and save to the name "PowerTest" automatically. And
the chart and the data need to shrink or enlarge to fit to a page.

Could anyone tell me how to do it? This is my first project to work with
power point and I spent a lot of time on it but I failed. Any help will be
deeply appreciated.

Thanks in advance.

Tim.

Reply to this Message

Jim Gordon MVP - 29 May 2005 15:50 GMT

Hi,

There are some complicated ways to approach this, but let me start with
the easiest suggestion I can think of.

When the Excel graph is selected the CHART menu appears in the Excel
menu bar. Choose CHART OPTIONS then click on DATA TABLE tab. Click the
checkbox "Show Data Table."

If that's not what you want to have, then please post a follow up.

Thanks.

-Jim

Signature

Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

> Hi folks,
>
[quoted text clipped - 12 lines]
>
> Tim.

Reply to this Message

Tim - 30 May 2005 04:30 GMT

Jim,

Thank you for your help. I need some code to copy about 20 excel worksheet
files (Chart and data table) to power point and save to files. One
spreadsheet save to one power point file.

Thank you very much.

Tim.

> Hi,
>
[quoted text clipped - 27 lines]
> >
> > Tim.

Reply to this Message

Mac Forum / Applications / PowerPoint / May 2005

Automation!!