none
copying data from excel to word its taking too much time excel 2016 version RRS feed

  • Question

  • Hi All,

    i have written macro, copying huge data(200 to 300 sheets) from excel to word its taking time and also working fine in excel 2010 version.

    after upgraded excel 2016 version in my laptop, when i run the macro still its loading and also not copying data from excel to word

    code

    sumrng.Copy
    Set myDoc = WordApp.ActiveDocument


    Application.DisplayAlerts = False
    myDoc.Sections(2).Range.PasteExcelTable _
        LinkedToExcel:=True, _
        wordFormatting:=False, _
        RTF:=False
    Application.DisplayAlerts = True

    Please give me the solution.

    Thanks

    Ramesh 

    Thursday, December 1, 2016 10:07 AM