11-05-2019
01:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-05-2019
01:39 AM
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
Solved! Go to Solution.
11-05-2019
02:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-05-2019
02:15 AM
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 Subwill insert the Size in to the parameter "Test"
Hope that this helps you
regards
Johann
11-05-2019
03:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-05-2019
03:12 AM
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
11-05-2019
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report