https://community.blueprism.com/t5/Product-Forum/Copy-specific-column-in-Excel-and-paste-in-another-Excel/m-p/114503#M51057 <P>Hi Team,</P><P>I want to copy specific column from one excel and paste in another excel. Tried using" Copy and paste worksheet Range" but getting error as shared below eventhough I used same handle, different work book names. Please help</P><P>Exception : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)).</P><P>How to solve pls help</P> Fri, 27 Sep 2024 09:37:46 GMT andepujitha065 2024-09-27T09:37:46Z https://community.blueprism.com/t5/Product-Forum/Copy-specific-column-in-Excel-and-paste-in-another-Excel/m-p/114503#M51057 <P>Hi Team,</P><P>I want to copy specific column from one excel and paste in another excel. Tried using" Copy and paste worksheet Range" but getting error as shared below eventhough I used same handle, different work book names. Please help</P><P>Exception : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)).</P><P>How to solve pls help</P> Fri, 27 Sep 2024 09:37:46 GMT https://community.blueprism.com/t5/Product-Forum/Copy-specific-column-in-Excel-and-paste-in-another-Excel/m-p/114503#M51057 andepujitha065 2024-09-27T09:37:46Z https://community.blueprism.com/t5/Product-Forum/Copy-specific-column-in-Excel-and-paste-in-another-Excel/m-p/114507#M51058 <P>Hi</P><P>Make sure you have both Excel files open (source and destination) and in the 'Copy &amp; Paste' action you only provide the file name (i.n. "Excel 1.xlsx"and "Excel.xlsx"), not the full path to the file.</P><P>Try this and let me know if it works.</P><P>Many thanks,</P><P>Marcin</P> Fri, 27 Sep 2024 10:30:01 GMT https://community.blueprism.com/t5/Product-Forum/Copy-specific-column-in-Excel-and-paste-in-another-Excel/m-p/114507#M51058 Ernest1 2024-09-27T10:30:01Z