Read Excel and Write to New Worksheet
I am reading an excel file. When everything passes the edits, it is then written to a database. However, if any cell in the row fails an edit, I would like to write a new worksheet (called Errors) containing all of the information from the row which failed.
Any help would be greatly appreciated.
Re: Read Excel and Write to New Worksheet
Re: Read Excel and Write to New Worksheet
I am getting it to write, but was coming up with a box everytime asking if I want to overwrite the existing file.