That test code works fine for me in xl2010.

Try some tests.

First try using the LoadPicture command on a gif file that you know is valid.
Then try the ChartExport and use paint to check the file produced is valid.

Also try jpg rather than bmp.