I’m attempting to create an Excel macro which allows me to select any range with an Excel file and export that selection to PowerPoint while matching the size of a selected PowerPoint shape/object. Sometimes this data will be only data tables but sometimes it will be selection of charts and accompanying data tables (hence the decision to export as an Enhanced Meta File).

I need to get a range form an excel sheet and use in this code to copy and paste it on a powerpoint presentation. I think the range doesnt work like that anymore but I dont have any idea on another way of doing that, any tips?

I found some VBA code which would update all links in my PowerPoint. The objects are cells and charts in my password-protected Excel Workbook which is saved in the same folder on my laptop. The code works to update all links. However, whenever i open the PowerPoint and run the VBA, after updating all links, i would get a pop-up from Excel asking for password. The number of times varies. Subsequent runs of the VBA would not have this problem. It seems to occur for the first VBA run since opening the PowerPoint.

I found some VBA code which would update all links in my PowerPoint. The objects are cells and charts in my password-protected Excel Workbook which is saved in the same folder on my laptop. The code works to update all links. However, whenever i open the PowerPoint and run the VBA, after updating all links, i would get a pop-up from Excel asking for password. The number of times varies. Subsequent runs of the VBA would not have this problem. It seems to occur for the first VBA run since opening the PowerPoint.

I found some VBA code which would update all links in my PowerPoint. The objects are cells and charts in my password-protected Excel Workbook which is saved in the same folder on my laptop. The code works to update all links. However, whenever i open the PowerPoint and run the VBA, after updating all links, i would get a pop-up from Excel asking for password. The number of times varies. Subsequent runs of the VBA would not have this problem. It seems to occur for the first VBA run since opening the PowerPoint.

Basically, I should be able select the chart in excel, run the macro, the macro will open a new instance of PowerPoint, insert a new chart (with the same chart type as the one in excel) and update the ppt chart backend data with the data from the excel chart