How do I copy some cells(including formatting) and save as image fileusing VBA?

  • Thread starter Thread starter LunaMoon
  • Start date Start date
L

LunaMoon

How do I copy some cells(including formatting) and save as image file
using VBA?

Ultimately, I want to do that via COM or ActiveX server. Yet I think
VBA is the starting point.

So lets start from VBA.

How to do that in VBA?

I know how to open and close the Excel sheet.

But what's the command in VBA/COM/ACTIVEX to copy a few cells
(rectangular shape, including formatting), and save as image?
 
How do I copy some cells(including formatting) and save as image file
using VBA?

Ultimately, I want to do that via COM or ActiveX server. Yet I think
VBA is the starting point.

So lets start from VBA.

How to do that in VBA?

I know how to open and close the Excel sheet.

But what's the command in VBA/COM/ACTIVEX  to copy a few cells
(rectangular shape, including formatting), and save as image?
Click to expand...

Within a VBA environment, I would use PowerPoint. Make an Excel macro
to:

1. launch PowerPoint
2. copy the section as picture
Range("A1:B2").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
3. paste into PowerPoint
4. save the PowerPoint as .jpg, for example
 
Back
Top