Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
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.
Solved! Go to Solution.
The attached sheet should help. See also for a way to avoid rereading the excel file every time you move the cursor.
The attached sheet should help. See also for a way to avoid rereading the excel file every time you move the cursor.
When I tried to opent the attached file, it gives VB Script error. See the attached screen grab
Obviously there is no excel file with the name test.xlsx in the current working directory.
my apologies, its working properly, thanks
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