CopyPicture font format issue

[cyrus2004]

I use the following code to make print screens of texts, tables and charts from one heavy Excel sheet to another Excel file. This, in order to send only Excel print screens and therefore makes file much lighter.

Sheets(Myarray(J)).Range(Current_Printarea).CopyPicture xlScreen, xlPicture

We have the following scenarios:
- when we use this command in our location no problem,
- when we send the file with print screens to another location no problem,
- when another location use this function and send us the generated file -> print screens are unreadable.

It is likely that their version of Windows and Office are different.
According to Excel help we can add the following parameters to the CopyPicture function:
- XlScreen
- XlPicture
- XlBitmap

I tried all three and have the results below:
- xlScreen -> unreadable
- xlPicture -> unreadable
- xlBitmap -> print screen blank

Should you have any idea it is welcome.

Thanks in advance for your kind help.

[Andy Pope]

What happens if they do this manually via the menus/ribbon, is the image still bad?