Excel Pictures to Power Point with VBA

[andrealp4444]

Hello,

I hope I'm asking this in the right place.

I am brand new to using VBA/ Macros. I've tired all the code that I could find to accomplish my task, but nothing has worked so far.

I have a spread sheet with many tabs (tabs are all named uniquely). I wouldn't mind running the script tab by tab.

Each tab has a number of columns/ rows. Only one column has pictures. Each tab will have a different number of pictures in a single column (20-60 pictures).

I want to take the pictures in Excel and put each one on a separate slide in PowerPoint (a new PowerPoint presentation). (Wish list- save the PowerPoint presentation as the sheet/tab name).

I would like to run this VBA code for each tab in my spreadsheet.

Another wish list item- One of the columns on each tab in Excel, has information I'd like to put in the presenter notes in PowerPoint. The presenter notes in Excel match the images I want to copy from Excel to PP (Example, A1 presenter notes, match B1 picture, A2 presenter notes, match B2 picture, etc).

Thank you!

 

[Dan_W]

I've tired all the code that I could find to accomplish my task, but nothing has worked so far.

This is a useful starting point. What code did you try and why do you say it didn't work?