Macro for inserting multiple curves?

[rustynissan]

I have XYZ coordinates for several curves that represent cross-sections of a part I would like to loft through. Around 25 curves containing about 65 points each need to be imported. I could make separate text files for each curve, but is there a way to do it with one excel file (possibly with each curve definition on a new sheet)?

Is this possible? I am new to the SW API, although I have used VBA in Excel a little bit.

 

[handleman]

If you only have 25 curves it'll probably be quicker to import one at a time than to write a macro to do it automatically.

That said, if it's 25 curves for or five times a week then that might be macro territory.

-handleman, CSWP (The new, easy test)

 

[rustynissan]

Indeed. This is something that will have to be updated periodically and would benefit from use of a macro.

 

[takedownca]

This macro generates curves/surfaces in Excel and imports them into SW. It's not exactly what you're looking for, but you can use it as a starting point for your macro. Most of the code you'll need is already there: calling excel, reading spreadsheet values, creating curves, etc.