Wise Owl Answers How do I save a shape as a picture in Excel VBA

By Andrew Gould

Annoyingly, there's no quick, built-in way to save a shape object as a picture in Excel VBA, even though you can use a context menu option to do this easily in Excel! This video shows a slightly messy workaround in VBA which involves copying the shape into a temporary chart to make use of its Export method!

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
   / @wiseowltutorials  

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Chapters
00:00 The Question
00:51 Copying a Shape as a Picture
02:12 Creating a ChartObject
04:15 Pasting a Picture into a Chart
05:38 Saving the Chart as a Picture
07:27 Saving Other Shapes as Pictures

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!