I have several same exact workflow, however, 2 of the workflows do not output any data to excel at all. All other output work perfectly.
I am using a macro provided from PwC (attached below) and this particular workflow keeps getting stuck at the output step
Then I got this error
There is nothing different that I made for all these workflow except the input. Can someone please help?
Hi @SophieTran1 ,
the two most common problems causing this error are an incorrect filename or an already opened file. I would suggest to add something like MsgBox( strFilepath) to check, if the name causes the problem. Does it happen always with the same output files? Is there a specific name?
Best,
Roland
I am writing the data to an existing file. So the output is linked to that specific file. I have 5 identical workflows with just different input data. This works for 3 out of 5. So I am not sure what the issue is
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |