Copy one sheet to another workbook with same format

Hello Experts
I want to copy a range of Excel file to another file keeping the cell format.

I tried to with this Macro:
Sub CopyPast ()
Windows (“File 1.xlsx file”). Activate
Sheets (“File 1”).
Range ( “A1: F4”) Select.
Windows (“File 2.xlsx file”). Activate
Sheets (“File 2”).
Range ( “D5”). Select
End Sub

the macro goes wrong at the line: Windows (“File 2.xlsx file”).Activate
Thanks for your help

Why ?

Hello @wahid,

To copy the sheet to another workbook. you can use this activity.

To get the activities from UiPath Go.


1 Like