Copy specific column in Excel and paste in another Excel

[andepujitha065]

Hi Team,

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

Exception : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)).

How to solve pls help

[Ernest1]

Hi

Make sure you have both Excel files open (source and destination) and in the 'Copy & Paste' action you only provide the file name (i.n. "Excel 1.xlsx"and "Excel.xlsx"), not the full path to the file.

Try this and let me know if it works.

Many thanks,

Marcin