Range of named cells in Excel

[Domp]

Hello,
I have a CVI application in which I use Excel's activeX (Excel2000.fp). Everything works normally but I can't get the list of all the named ranges in my Excel document in code. I searched in the examples as well as on the forum but I couldn't find the solution.
I am under Win10 64 bits with CVI 2019 and Office 2019.
Can someone help me?

[Shezan.Nabiel]

Hi,

Could you try using a macro in Excel which reads the Named Range cells and saves the value as a String, and then have CVI run that macro? The CVI example Excel2000.fp has a example which demonstrates how to run a macro from CVI to excel.

That would be my first option as I haven't used CVI to receive the Named range cells yet. I will give it a try and get back to you, in the meantime maybe the macro could be a work around?

Thanks,

Shezan Nabiel