How to check if a sheet exist in the excel
hi there, trying to find a solution on how to find a sheet exists in an excel file. Goal is if the sheet doesnt exist, then it will create the sheet in the excel else it should append to the existing...
Forum Discussion
Hi Manohar,
Have you tried trapping it in the error view??? its basically doing a try catch… put a router if $error “Sheet with the name does not exist” then create the sheet…
If it didn’t error then sheet is already n the excel
Thanks,
M
