Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

GSD_PointSplineLoftFromExcelL

Status
Not open for further replies.

jzecha

Aerospace
Jan 20, 2016
235
US
I love this Excel sheet, but I have one problem with it.
I work in Standard Unites, when I run the Excel sheet, found in Catia's installation directory, it divides all my values by 25.4.
So if I have point with these values: 1,1,1.
The Excel sheet will create a point with .0394, .0394, .0394.

I have side stepped this issue by multiplying all my input data by 25.4 to get the correct values.

But does anybody know how I can fix this so it is a direct import so I will not have to change my values before importing?
 
 http://files.engineering.com/getfile.aspx?folder=5faf8cf0-ea43-411e-b7b2-42facef99a90&file=GSD_PointSplineLoftFromExcelL.xls
Replies continue below

Recommended for you

in the code you find

Code:
'Conversion string -> double
    Chain2 = GetCellB(iRang)
    Chain3 = GetCellC(iRang)
    If ((Len(Chain) > 0) And (Len(Chain2) > 0) And (Len(Chain3) > 0)) Then
        X = CDbl(Chain)
        Y = CDbl(Chain2)
        Z = CDbl(Chain3)

you can include you multiplication here...

Eric N.
indocti discant et ament meminisse periti
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top