AnsweredAssumed Answered

Create multiple reference planes from file

Question asked by Jason McCrory on Jun 26, 2020
Latest reply on Jun 29, 2020 by Jason McCrory

Wondering if anyone has a macro that will read a spreadsheet or csv file and create 30+ reference planes from data in the file (or at least the foundations of one). I've done some VERY simple VBasic stuff in excel, but I'm not as well versed in the SWX API and can't seem to find my footing.

Background - I work in aviation, and anytime we have to model a new aircraft, we set up a "template" file for everyone to use that has the fuselage stations set up in reference planes. Each fuselage station is measured from 0, and we name each plane with the station number and sometimes a frame label. There are sometimes 100 or more frame stations to create depending on how large the aircraft is and it is time-consuming, tedious work (that we usually pass off to an intern). This file is then used by everyone on the design team so that when we bring everything together it will all snap into place. 

It'd be nice if I could create a file with each reference plane's distance from 0 and the label I want to give it, than import that file via a macro and have all of my reference planes created... any ideas?

Outcomes