Combobox

ptc-4260912 · ‎Oct 05, 2011

Hello,

when a mathcad sheet has a combobox, and I try to open it, i get an error message" an unknown runtime error occured, existing". what do i need to do to be able to open any mathcadsheet with combo boxes? Thanks!

VladimirN · ‎Oct 06, 2011

Hello!

Which version of Mathcad you are using and what OS is running?

ptc-4260912 · ‎Oct 11, 2011

I have Mathcad14, and Windows XP. Thanks!

ptc-4260912 · ‎Oct 11, 2011

I have Mathcad14, and Windows XP. Thanks!

ptc-4260912 · ‎Oct 11, 2011

I have Mathcad14, and Windows XP. Thanks!

VladimirN · ‎Oct 12, 2011

SAM FARES wrote:
Hello,
when a mathcad sheet has a combobox, and I try to open it, i get an error message...

Could you also to attach a Mathcad worksheet?

Here's a tip how to attach a file:

1. Step

2. Step

ptc-4260912 · ‎Oct 13, 2011

Attached is the mathcadsheet you requested. Thanks!

RichardJ · ‎Oct 12, 2011

Please post an example worksheet.

ptc-4260912 · ‎Oct 12, 2011

Hello Richard,

when i am replying to you, how could i attach the mathcadsheet?

RichardJ · ‎Oct 12, 2011

At the top right it says "Use advanced Editor". Click on that, then you will be able to attach files.

The advanced editor used to be the default. I don't know why they changed it.

ptc-4260912 · ‎Oct 13, 2011

attached is the mathcadsheet with comboboxes!

Thanks!

RichardJ · ‎Oct 13, 2011

Some of the list boxes try to access an Excel file, AISC 13th Edition.xls. Can you post that file?

ptc-4260912 · ‎Oct 13, 2011

Attached is the AISC 13TH edition. Thanks Richard!

RichardJ · ‎Oct 13, 2011

With the spreadsheet in the correct location (M:\Database) your worksheet opens fine for me. Since you can open the basic listbox worksheet I posted I suspect your problem is with Excel, not the listboxes. Do you have the worksheet in the correct location? What version of Excel are you using? What happens if you open the worksheet directly in Excel?

ptc-4260912 · ‎Oct 13, 2011

when you opened the mathcadsheet before you recieved the excel sheet, did the mathcadsheet open all the way ? meaning , were you able to see the information inside the mathcadsheet? i have excel 2007.

how do i open the worksheet directly in excel?

RichardJ · ‎Oct 13, 2011

when you opened the mathcadsheet before you recieved the excel sheet, did the mathcadsheet open all the way ? meaning , were you able to see the information inside the mathcadsheet?

Yes.

how do i open the worksheet directly in excel?

Sorry. A brain short circuit. I meant spreadsheet.

ptc-4260912 · ‎Oct 13, 2011

As he mathcad sheet is trying to open, the error message pops on the screen before i get to see anything inside the mathcad sheet.

RichardJ · ‎Oct 14, 2011

Can you open this one?

ptc-4260912 · ‎Oct 14, 2011

No I am not able to open the attachment you sent.

could you change inside the mathcadsheet so that it looks for the AISC 13TH EDITION Excel sheet to be on C drive instead of M: then send it to me just to see if this would help? Thanks!

RichardJ · ‎Oct 15, 2011

Changing the path will make no difference. In the worksheet I just posted I disabled all the listboxes that access the Excel spreadsheet.

ptc-4260912 · ‎Oct 13, 2011

when you opened the mathcadsheet before you recieved the excel sheet, did the mathcadsheet open all the way ? meaning , were you able to see the information inside the mathcadsheet? i have excel 2007.

how do i open the worksheet directly in excel?

VladimirN · ‎Oct 14, 2011

The file "AISC 13th EDITION.xls" located on your computer in folder "M:\Database\AISC 13th EDITION.xls"?

RichardJ · ‎Oct 13, 2011

Do you get an error when you open the attached Mathcad file?

ptc-4260912 · ‎Oct 13, 2011

yes i am able to open it.

ptc-4260912 · ‎Oct 13, 2011

yes i am able to open it.

jsheehan · ‎Oct 14, 2011

All seems to work fine if your path to AISC 13th EDITION.xls is set properly. I would recommend making filename a variable in your worksheet such as filename = "AISC 13th EDITION.xls" and pass it to each of your combo-boxs which open the Excel worksheet. Or you coudl simply add into each combo-box script

filename = Worksheet.Getvalue("filename")

If the path to your file i snot correct you'll get a runtime error from the following line

Set objWorkbook = objExcel.Workbooks.Open("D\jsheehan\support\2011\AISC 13th Edition.xls")

ptc-4260912 · ‎Oct 14, 2011

Thanks John!!

in the attached mathcadsheet, i have to type in the code, beam, support, which is a bit inconvient. how would you setup a list box or a combo box i am not sure the difference between the two so that al i need to do is scroll down and select the beam size , or support size which are looked up in the table inside Beam and support data area. as far as the code eithe "ASD" or LRFD"?

RichardJ · ‎Oct 15, 2011

Does your positive reply mean that if you put the Excel spreadsheet in the correct path it works? If so, that's surprising, since you said you could not open the worksheet I posted above that does not access the spreadsheet.

i am not sure the difference between the two

They are listboxes. Mathcad does not offer comboboxes as controls.

how would you setup a list box or a combo box i am not sure the difference between the two so that al i need to do is scroll down and select the beam size , or support size which are looked up in the table inside Beam and support data area. as far as the code eithe "ASD" or LRFD"?

I'm confused. Isn't that what the listboxes in your other worksheet already do?

ptc-4260912 · ‎Oct 15, 2011

The mathcasheet that you were able to open, and i was not has listboxes. i was not able to open for some reason . This is why i posted my question few days ago. Few months ago i had some one remove remove all the listboxes from it so i can open it, and i was able to open it after removing the list boxes. the inconveience that i have now is that i have to type in the beam size, support size,,,,,, all the fields highlighted in yellow in the attached mathcadsheet that i sent you earlier named"Listbox".

what is the procedure on how to insert a listbox that will read for example the beam sizes from the Excel sheet, similarly the other input info highlighted in yellow in the mathcadsheet. Thanks!

jsheehan · ‎Oct 15, 2011

Hi Sam,

Your worksheet is using listboxes properly for the worksheet your original worksheet Double Angle-Welded NSL. There is a problem with the script in your listbox Angles.All values are returning zero. Unfortunately I am not on your platform, I am running Window 7 on a 64bit machine. So you may be seeing other issues.

I am looking into the scripting error.

Are you able to get back values from your first 3-4 listboxes or do you get an error right away?

More specifically .. can you run richard's "very basic listbox.xmcdz" example?

John