Hello,
I have some report tables in Excel and some charts already created in a PowerPoint file and I need a macro to copy data from Excel and paste it on to the datasheet of the PowerPoint chart. I do not want to "link" PowerPoint to Excel or have objects embedded. Nor do I want to create the charts in Excel and copy those to PowerPoint.
Fo example, my Excel spreadsheet has a sheet called '1'. I need to copy the entire sheet, go to slide 1 in PowerPoint, select a chart, access the datasheet (also called '1') and paste the values. How do I access the datasheet using VBA?
Any help would be greatly appreciated!
Thanks for your time.
I have some report tables in Excel and some charts already created in a PowerPoint file and I need a macro to copy data from Excel and paste it on to the datasheet of the PowerPoint chart. I do not want to "link" PowerPoint to Excel or have objects embedded. Nor do I want to create the charts in Excel and copy those to PowerPoint.
Fo example, my Excel spreadsheet has a sheet called '1'. I need to copy the entire sheet, go to slide 1 in PowerPoint, select a chart, access the datasheet (also called '1') and paste the values. How do I access the datasheet using VBA?
Any help would be greatly appreciated!
Thanks for your time.