Unable to get Modern Write Range Workbook to work

Help Studio
1

I am receiving a write range workbook: being used by another process error. The excel file i am trying to write to is not open. I have used Task Manager to ensure it is all excel applications are closed prior to running the bot. I think it has something to do with the fill being called out in both Use Excel File and Write Range Workbook activities.

Any advice?

image
image1333Ă—1040 70.2 KB

2

Hi @Waterfowl_Waterfowl_hunte

Don’t combine Excel activities and Workbook activities

Use this activity

image

3

Giving that a try now…

1 Like
4

That seems to work much better. thank you very much. i have one final issue.

The Write DataTable to excel Destination is only letting me write to a sheet (seen below) which defaults to A1

image

I need the data inserted into B2 but i receive the below error. I have no idea what that means

image
image844Ă—262 11 KB

5

@Waterfowl_Waterfowl_hunte

Excel.Sheet(“YourSheetName”).Range(“B2”)

8

Thank you very much, This worked. I have been trying and researching this since Friday morning. i appreciate your time

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.