View Single Post
 
Old 10-03-2018, 11:48 AM
R Mohan R Mohan is offline Windows 8 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 15
R Mohan is on a distinguished road
Default Exporting selected cells to PowerPoint via VBA

Hi,

I am trying to create a macro, which goes through the following steps.

1) Ask the user to select a certain group of cells within the current spreadsheet (via input box)

2) Export the selected cells in the form of an image to a specific PPT file within the same parent folder. (I am not sure whether I can use current project. path here.)

3) Also curious - if there is any way to auto-adjust the exported image within the dimensions of the slide.

I may need some help with VBA here. It would great if someone could help !

Regards,
Mohan
Reply With Quote