Copy one sheet to another workbook with same format

[wahid (mustapha)]

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.
Selection.Copy
Windows (“File 2.xlsx file”). Activate
Sheets (“File 2”).
Range ( “D5”). Select
ActiveSheet.Paste
End Sub

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

[wahid (mustapha)]

[wahid (mustapha)]

Why ?

[balupad14 (Balamurugan)]

Hello @wahid,

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

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

To get the activities from UiPath Go.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards
Balamurugan.S