Hi everyone,
First post on this helpful forum, so please accept my apologies if my request is not in a helpful format however my request is as follows:
I have two tabs within my spread sheet (attached) which are called Sheet A and Sheet B. They both have the same VBA button function that will transfer the selected ranges (Area 1 and Area 2) to there own PowerPoint slides in bitmap format.
However I would prefer once the PowerPoint is open in the first instance when I run the function (lets say within Sheet A) that when I run the VBA in Sheet B it will just make the additional slides to the existing PowerPoint rather than opening it's own separate PowerPoint application for each sheet.
I have found an existing example of VBA that identifies if PowerPoint is open then it will add the existing set of slides in the following link: http://www.vbaexpress.com/kb/getarticle.php?kb_id=370, however I cannot seem to incorporate it into the VBA within my spread sheet.
Please can anyone assist in solving my preference?
Cheers everyone
Bookmarks