Hi everyone,
I posted a question earlier today. I had a look over the link which was provided, but I dont think it was really what I was after.
I would like a program that operates from PowerPoint. On the heading line in the respective PowerPoint slides I would have the Graphs names, for instance: Hours vs Output. The ideal (probably unrealistic) program would then go to the active Excel workbook and loop through all the sheets. It would locate the correct graph and the copy paste the graph as a picture. The reason I need the graph to be pasted as a picture is that when I use the link feature in PowerPoint the file size is about three times bigger.
As said earlier, I tried to record a macro to learn the process but that only shows the copy paste action and doesn’t detail anything about my actions in Excel.
Ideas or further suggestions are greatly appreciated. Many thanks!
I posted a question earlier today. I had a look over the link which was provided, but I dont think it was really what I was after.
I would like a program that operates from PowerPoint. On the heading line in the respective PowerPoint slides I would have the Graphs names, for instance: Hours vs Output. The ideal (probably unrealistic) program would then go to the active Excel workbook and loop through all the sheets. It would locate the correct graph and the copy paste the graph as a picture. The reason I need the graph to be pasted as a picture is that when I use the link feature in PowerPoint the file size is about three times bigger.
As said earlier, I tried to record a macro to learn the process but that only shows the copy paste action and doesn’t detail anything about my actions in Excel.
Ideas or further suggestions are greatly appreciated. Many thanks!