Hi,
Is it possible to just copy one Excel sheet to another workbook?
I have built some basic workflows in the online version, but this is my first time with Power Automate Desktop.
Why am I thinking about this option? because I need the whole sheet, not just a selection of cells or a table.
Any ideas? Thank you!!!
Hi @JeanPaul ,
Please try this
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test1.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test2.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance2
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.CopyCellsFromExcel.CopyAllCells Instance: ExcelInstance
Excel.AddWorksheet Instance: ExcelInstance2 Name: $'''tempSheet''' WorksheetPosition: Excel.WorksheetPosition.First
Excel.PasteCellsToExcel.Paste Instance: ExcelInstance2
Excel.CloseExcel.Close Instance: ExcelInstance
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance2
Best Regards,
Wearsky
stampcoin
45
Michael E. Gernaey
25
Super User 2025 Season 1
Chriddle
21
Super User 2025 Season 1