BC Excel Buffer Import - Capture Worksheet name for error handling

samantha73samantha73 Member Posts: 101
Hi All
I have created an excel buffer import to a new table in BC. All works except when users do not use the specified worksheet name, the system throws an error which is not end user friendly. Is there a way to capture the worksheet name and compare it against the predefined name in codeunit, then show a custom error. I know the issue here is technically the excel workbook can have multiple worksheets. So perhaps checking if a predefined name exist or any other options/suggestions?
Thanks
Sign In or Register to comment.