Automation!!

[Tim]

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.

 

[Jim Gordon MVP]

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

 

[Tim]

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.