Control Containers to Create a New Workbook & Update Different Sheets on the same workbook

[vivaisun11]

Hello.

I am trying to create a workflow where a new workbook is created (in a shared network drive) with current date, and the same workbook has sheets updated with other parts of the workflow.

Recently came across Control Containers and thought it would do the job, but its been a hit or miss, where sometimes it runs without issues, but most of the time, I get the error that "The process cannot access the file because it is being used by another process."

Below is a sample of the workflow I am using.

Thanks.

[alexnajm]

It uses Run Command in the furthest down macro so as long as that is allowed on your Server, it shouldn't be a problem.