Excel Chart into Word VBA

[dhiraj.ch185]

Hi,

I have a macro in .XLSB format for which i do not have any source code. The purpose of this macro is to copy all the graphs from an excel workbook to word.
Now, my issue is, when i execute this macro, after copying last graph, an error -Object has been deleted is pop-up. So the word is not generated. Strangely, when i try to log-off from my machine, a pop-up message asking me to save the document is shown so i can save the word in which upto last graph is copied. This error may be due to some code issue in macro,
My main concern is where is this word saved file saved until then??? Why does it asks me to save only during log-off?? I checked %temp% and temp areas. Not there. Someone can help me to find this out please.

-Dhiraj.

[Admin]

Hi Dhiraj,

Could you post the code here ?

In the meantime, have a look at this http://www.excelfox.com/forum/f12/excel-chart-word-convertor-9/

you didn't give the feedback on this Collate Data from csv files to excel sheet (http://www.excelfox.com/forum/f2/collate-data-csv-files-excel-sheet-307-new/)

[dhiraj.ch185]

Thanks to Admin for Excel to word converter. As that macro is developed by someone else, i don't have code and also can't share macro.

[wedmasten]

When I try the code to Paste the Active Excel Chart at the Cursor in the
Active Word Document I get an error message that indicates that the command
is not available because the document is not open. However I do have a Word
Document open