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
|