Export objects to single excel with caption.

[rajni_batra]

Hi Folks,

I have a requirement to export multiple objects in single excel which i am able to do with macro in attached file

but the issue is chart caption is also required with data.

Can anyone help me for this..

[ashfaq_haseeb]

Hi

Go to user preference and make sure you have following selections enabled.

Regards

ASHFAQ

[rajni_batra]

Hi Ashfaq,

Thanks for your reply,

I have tried this option but this only works for Image part not for Data part.

I am using "Export to Excel (Variant 3)" macro

Regards,

Rajni Batra