Results 1 to 4 of 4

Thread: Excel Chart into Word VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Sep 2011
    Posts
    14
    Rep Power
    0

    Question Excel Chart into Word VBA

    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.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Dhiraj,

    Could you post the code here ?

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

    you didn't give the feedback on this Collate Data from csv files to excel sheet
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Sep 2011
    Posts
    14
    Rep Power
    0
    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.

  4. #4
    Junior Member
    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0
    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

Similar Threads

  1. Replies: 7
    Last Post: 08-24-2015, 10:58 PM
  2. Replies: 1
    Last Post: 10-16-2012, 01:53 PM
  3. Speed up excel to word VBA
    By bcostin in forum Excel Help
    Replies: 3
    Last Post: 05-22-2012, 10:49 AM
  4. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  5. Excel Chart To Word Convertor
    By Excel Fox in forum Download Center
    Replies: 1
    Last Post: 04-04-2011, 06:21 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •