Data doesn't show up in output file

Question

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?

SophieTran1 · Answer

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

RolandSchubert · Answer

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