Hi, I’m testing out a new process for one of the departments here at my place of work and I’m running into a rather stupid problem that shouldn’t be happening in any scenario.
Basically the whole process starts by reading in 1 file, and not a large one. Maybe about 60 rows in this report today. I started the process and it went along just fine but at some point it failed (most of it is interacting with an AS400 terminal so it was likely the cause of the stop). This isn’t a problem as I can just restart it and the bot can pick up where it left off.
Only problem is that when the bot tries to read in the file, of the same workbook/sheet name (running locally now), it just throws that generic syntax error and gives me no other details. I debugged and checked the properties and both the workbook name and sheet name are correct and visible to the bot, the file itself contains no formulas (it may have contained formulas on the first run, but is has since been written back to so I assume they just disappear and leave the values behind), and the file hasn’t even been moved.
If anyone can help be understand why this type of thing happens I would greatly appreciate it as this has happened to me before with another process. Thank you.