Results 1 to 1 of 1

Thread: [Excel] Creating new set of parameters from Catia model

  1. #1
    New Member
    Join Date
    May 10
    Posts
    1

    [Excel] Creating new set of parameters from Catia model

    Hello everybody,

    I'm a student whose pretty fresh with programming. I have a task right now to create an entirely parametrized sailboat in Catia v5. Every parameter should then be controllable through an excel interface.

    Now, I've created tables for all existing parameters and assigned them space in my excel sheet. So far so good. But then I came to a part which has several parameters to control and which the number of parts are individually controlled. Please see attached jpeg. My question concerns the sheets and ribs (however, if one is solved the same solution could of course be applied to the other).

    How and what vb code is needed to make my excel sheet modify according to number of parts to control the positions of every sheet when the number of sheets varies? I.e the number of sheets could be 4 and then I want 4 "blocks" in excel where I can change their parameters and if the number is 2 then I only want 2 blocks in excel to change parameters. Each and every block contains parameters to change i.e. the sheet height, width, position etc.

    Thanks a lot in advance!

    Daniel
    Attached Images Attached Images  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •