Skip to main content
Raiko17-Peridot
17-Peridot
September 30, 2011
Solved

Gettext method in listbox

  • September 30, 2011
  • 7 replies
  • 3317 views

Hello Folks,

I have this annoying problem in a listbox. I'd like to read in data from an excel sheet. For this I have found a nice routine (thanks again for that) in this forum that provides me all files of a given directory which I then can choose from a listbox. Works like a charm!

Now I'd like to select via a similar mechanism a certain sheet in this Excel file. The problem now is that I can't extract the text of this selected element via the GETTEXT method; MathCad claiming it to be an invalid operation. This method however, works fine with a simple Listbox.

Hope somebodya can find a solution for that (see attached sheet)

Thanks in advance

Raiko

Best answer by Raiko

Hello Andy,

thanks for the reply. Unfortunately this doesn't do the job I'd like to see. My code accesses the files in a directory just as your one does (your's faster!) but I cvan't get it running when I'm trying to access the data of a specific worksheet in a chosen excel file.

Cheers

Raiko

7 replies

AndyWesterman12-Amethyst
12-Amethyst
September 30, 2011

Hi Raiko,

Not sure why the list box.gettext method doesn't work (it is listed in the help files)

Attached is a very old sheet from the old collab forum.

Should do all you want (I hope)

Regards

Andy

Raiko17-PeridotAuthor
17-Peridot
September 30, 2011

Hello Andy,

thanks for the reply. Unfortunately this doesn't do the job I'd like to see. My code accesses the files in a directory just as your one does (your's faster!) but I cvan't get it running when I'm trying to access the data of a specific worksheet in a chosen excel file.

Cheers

Raiko

AndyWesterman12-Amethyst
12-Amethyst
October 3, 2011

Hi Raiko,

Attached seems to work for me - only change was to add back the default Addstrings calls for 'one' 'two' & 'three'.

Perhaps the get textcall crashes if there is a NULL list.

I've looked at the Excel & other data import wizards & haven't seen any way to include a variable name into the field.

I have tried to do that for a couple of applications but at the moment I have it hard coded into a reference mathcad sheet,

I would be grateful to know if you succeed.

Regards

Andy

Terms & ConditionsAccessibility statement