VBA Excel Export Range Shape Chart as image file

preview_player
Показать описание
VBA Excel Export Range Shape Chart as image file
VBA Excel 範囲とかシェイプとかチャートなどイメージファイルにエクスポートします
VBA Excel Xuất Range Shape biểu đồ sang dạng file ảnh
Рекомендации по теме
Комментарии
Автор

Can you share the code or file please?

nikkimidnighttornado
Автор

sir high resolation 300dpi jpg format please tell me vba code

sahirarman
Автор

Doesn't work on my machine. thanks anyways !
I tried this and it worked.

Range("A1:M28").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Set cht = ActiveSheet.ChartObjects.Add(0, 0, Rng.Width + 0.01, Rng.Height + 0.01)
cht.Name = "tempchart"
cht.Chart.Paste

= msoFalse
= msoFalse

= msoFalse
= msoFalse
cht.Chart.Export strPath & "c:\filepath\imagename.jpg"

PradeepChauhan
Автор

Can you share the code or file please?

nikkimidnighttornado
join shbcf.ru