Excel runs that VBA code, which then opens PowerPoint and copies all charts in the spreadsheet as images on individual slides in the new presentation. Advertisement. Article continues below this ad.

If you have a graphic file you insert often, automate the process using a VBA procedure (macro), as follows: In PowerPoint, launch the Visual Basic Editor by pressing [Alt]+[F11]. Choose Module ...

Visual Basic for Applications (VBA) gives you an additional option for embedding images in Excel. When you add an image through the VBA window, you can embed it into an Excel dialog box.