Format values in memory and paste as Image: Possible?

Colleyville Alan

New Member
Joined
Sep 27, 2002
Messages
1
I have a VBA application that has values in an array, structured much the same as a spreadsheet, with rows and columns.

My desired goal is to create a formatted version of this data and be able to paste it as an image rather than as actual values in cells.

One option I have is to write that data to Excel, format it, select the range, and Copy/Paste|Special as an emf file, but I'd like to save the intermediate step.

Question: can I apply formatting (bold, italics, etc) to the values in the array using VBA commands, take the formatted array, and paste it as an enhanced metafile image?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi Alan,

Unfortunately I don't have time to give you code for this at the moment, but I just want to assure you that yes, it can be done, and actually fairly easily. If you are in a hurry I recommend you ask for a quote from MrExcel to do it for you. If you have the patience--and you may have to repost your question--you should get an answer. I know there are lots of MVPs who know how to do this.

Damon
 

Forum statistics

Threads
1,143,915
Messages
5,721,512
Members
422,369
Latest member
redinator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top