Excel Range as Figure

[lostruler]

Hi Guys,

I need a Macro to convert an Excel range to a figure file.

I'd like to convert the Range C3:E8, from the file C:\Base.xlsx, to a .png file (C:\Figure_A).

It would be great If it could 'Refresh All' the workbook before export as figure, and also save right after that.

Thanks a lot for helping.

[Gintaras]

What code for it would be in VBA (Excel macro)?

[lostruler]

Understood!

I'll have to create a VBA Macro to export as figure. Then use QM to open the file run the macro, save and close.

Thank you.