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?
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?