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:

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

Рекомендации по теме

Комментарии

Very pedagogical video, step by step, as usual. You make me loving Excel VBA. Thanks.

mortimerconstant

Thank you. Very nice. Can I do it without background?

csakegybolond

Great Andrew like always.

I have other questions describing below

I have 3 signatures in outlook

Sign1
Sign2
Sign3

How to pick signature dynamically based on user input?

And signature contains image /gif aswell.

I found some code in google but it is not adding image and image/gif is not loading its giving error.
Your idea will be greatly appreciated... TIA

baludevunipalli

Thank you very much for your video Andrew
I am having one doubt regarding embedded objects
When i am going to insert tab and inserting the object browse the file and attached the file how to fetch embdedd file name using vba is there any possiblity
Thanks in adavance

maddinenirajeshbabu

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

Wise Owl Answers - How do I hide all but the selected sheets in Excel?

Wise Owl Answers - How do I list all properties of a file using VBA?

Wise Owl Answers - How do I refer to an open Word document in Excel VBA?

Wise Owl Answers - How do I scroll down a web page in Chrome with Selenium for VBA?

Wise Owl Answers - How do I loop through sheets in multiple closed Excel files?

Wise Owl Answers - How do I add a Select All option to a VBA list box?

Wise Owl Answers How do I group a pivot table by a numeric field using VBA?

Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?

Oliver the Wise Owl 🦉✨

Wise Owl Answers - How do I refer to a field name with a dot in ADODB?

Wise Owl Answers - How do I get data from a closed Excel file using VBA?

Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?

Wise Owl Answers - How do I add a filename to the results of an ADODB query?

Wise Owl Answers - How do I get data from multiple closed Excel files using VBA?

Wise Owl Answers - How do I unzip files using VBA?

Wise Owl Answers - How do I refer to a parent element in Selenium for VBA?

Wise Owl Answers - How do I find a folder with a partial name in VBA?

Wise Owl Answers - How do I draw a line in a cell in Excel VBA?

Wise Owl Answers - How do I pass Japanese text to a stored procedure parameter in VBA?

Wise Owl Answers - How do I populate an array with an ADODB recordset?

Wise Owl Answers - How do I copy data without using copy and paste in Excel VBA?

Wise Owl Answers - How do I refer to the previous column in a matrix in SSRS?

Wise Owl Answers - How do I copy Word tables into Excel using VBA?

Wise Owl Answers - How Do I Control Different Cells with One Spin Button in Excel VBA?