Mathcad excel worksheet

[yogeshdeshpande]

I am importing data in Mathcad by reading excel file. I want to import worksheet names in listbox for selection. I am new to VB script but with help from various posts on this forum, I have now a script for doing this. But the program is not functioning properly. When I click on sheet 1 in listbox, it gives output as sheet 2 (if I remove +1 in the script for output, it gives error on GetText). Also I am not able to click on last worksheet name as well in list box. Can you please let me know what is the error? I have attached file for reference.

[Werner_E · Accepted solution]

The attached sheet should help. See also for a way to avoid rereading the excel file every time you move the cursor.

[yogeshdeshpande]

When I tried to opent the attached file, it gives VB Script error. See the attached screen grab

[Werner_E]

Obviously there is no excel file with the name test.xlsx in the current working directory.

[yogeshdeshpande]

my apologies, its working properly, thanks

[Werner_E]

No problem.

The last component (listbox with a Mathcad vector as input) was taken from Richards fine collection you might be interested in http://communities.ptc.com/docs/DOC-1071