how to export sheet in .bmp format

[#1]

Dear all

how to export sheet in . bmp format

please help--------------------

Regards

Ashish

[spsrk_84]

Hi,

Write a macro to export the sheet into .bmp format,meanwhile i will also try to post the code........

Rgds,

Ajay

[#3]

Hi,

Your macro should be as follow

ActiveDocument.Sheets("Main").ExportBitmapToFile
"D:\Documents and Settings\XXXXXXX\Desktop\New Folder\MyImage.bmp"

-Peterson

[#4]

it's a not working

[#5 · Accepted solution]

Hi,

Note code should be in same line.

ActiveDocument.Sheets("Main").ExportBitmapToFile "D:\Documents and Settings\XXXXXXX\Desktop\New Folder\MyImage.bmp"

What error are you getting?

-Peterson

[#6]

thank it's working

Regards

Ashish