Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Detect thread standard from thread.xls

GeorgK
Advisor

Detect thread standard from thread.xls

GeorgK
Advisor
Advisor

Hello together,

 

how could I get the thread standard from thread.xls? For example

 

oThreadStandard = "ISO Metrisches Profil" '"ISO Metric profile"

Sometimes I have the German or the english version. How could I distinguish it?

 

Thank you

Georg

0 Likes
Reply
Accepted solutions (1)
451 Views
3 Replies
Replies (3)

j.brodersen
Enthusiast
Enthusiast

Hi Georg,

 

if you try to get hold of a parameter from the excel file you have to use the English name for the Sheet since it's named like this in the file it self!

 

E.g.

Sub Main

Dim Path As String = "C:\..."
MultiValue.List("Test") = GoExcel.CellValues(Path+"\Thread.xls", "ISO Metric profile", "A4", "A10")

End Sub

will insert the Size in to the parameter "Test"

 

Hope that this helps you

 

regards

Johann

 

Sergio.D.Suárez
Mentor
Mentor
Accepted solution

Hello, try the following ilogic rule, maybe I can give light to your problem.

 

Dim oThreadTable As ThreadTableQuery = ThisApplication.GeneralOptions.ThreadTableQuery

For Each oType As String In oThreadTable.GetAvailableThreadTypes
	MessageBox.Show(oType)
Next

 I hope this can be useful, Regards


Please accept as solution and give likes if applicable.

I am attaching my Upwork profile for specific queries.

Sergio Daniel Suarez
Mechanical Designer

| Upwork Profile | LinkedIn

GeorgK
Advisor
Advisor

Thank you very much. I can use both solutions.

0 Likes