export the sheet as image

[#1]

Hi,

I am trying to export the whole sheet as the image using macros. But i am getting the blnk image. But it is working sucessfully for the single object.

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.Sheets("dbs").ExportBitmapToFile "C:\stat.jpg"

Please suggest

[#2]

Hi,

Because you have a select the sheet before to export the sheet to image.

See to file.