Solved: Connecting Excel to PowerPoint

[morteza2006]

Hi all
Dear Friends
I was faced with a big problem
I have an Excel file that has 10 sheets
And all sheets are stored in a PowerPoint file with 10 slides
I want to write VBA code that will change when my Excel files, PowerPoint files as well as changes
Please please help me

[James Niven]

Welcome to this site!

Is the data within the Excel spreadsheet in the form of charts and graphs or data?

Thanks

[morteza2006]

Thank you so much
There is a chart in my files and data
I've attached a sample file

I have a module with the module all the sheets slide in a PowerPoint slide to save my file as
Thank you very much for the help

[James Niven]

Well since you have a chart and you wish to display within Powerpoint, what I have done in the past and should work for you is create the chart in Excel as you have done, then open your powerpoint presentation, select the slide you wish to place it in. If you already have a chart in place, delete the old one.
Copy the chart from within Excel and then on the powerpoint slide paste special and use the fourth icon under the paste options , it will say "Keep Source formatting and Link data".
Now everytime you update your spreadsheet chart, the powerpoint will update as well.

Hope this helps!
I could not open you VBA code as you mention, its asking for a password!

Good Luck