I have built a bot for my employer which writes to a report file of the success/failure of each transaction and some details about any error messages that may appear. Somebody would manually go through the reports and check on any of the exceptions (“Failure”) the bot was unable to process.
The bot runs 24/7 and writes this as a daily file with today’s date.
However, if somebody has today’s report file open (.xls), the bot will crash or unable to write to file as it tries to “Read Range” to check the number of rows so it can write to “lastrow + 1” say.
How can I have the bot reading/writing to an excel file which may be open by another user at the same time?