Hi I’m trying to read the list of sheets from an Excel . But I’m getting the below COM error every time when I execute mu code.
Every instance of workbok_varible.getssheets is giving me COM error. my sheet doesn’t contain any charts or special data.
TestRishi.xaml (31.0 KB)
For security reasons I can’t share the Excel , please find the attached Xmal.