Results 1 to 2 of 2

Thread: BOM Creattion using spreadsheet.

  1. #1
    Woo! Hoo! my 1st post
    Join Date
    2019-11
    Posts
    1
    Login to Give a bone
    0

    Default BOM Creattion using spreadsheet.

    Hello Guys, i am working on a contrat where the customer currently has an excel spreadsheet with their BOM on it. Currently they go through the spreadsheet and populate the boxes with their requirements. The items are always a specific number and they want to maintain this way of having the current BOM item numbers.

    They have only just decided to goto inventor from Visio so i am setting their drawings and system up.

    Have any of you guys had a similar situation or created a script that looks at the spreadsheet and assigns the BOM number to the particular part or assembly and then outputs a new BOM in excel for the current project ?

    Any help would be greatfully received

    Mike

  2. #2
    All AUGI, all the time Tharwat's Avatar
    Join Date
    2010-06
    Posts
    907
    Login to Give a bone
    0

    Default Re: BOM Creattion using spreadsheet.

    Quote Originally Posted by miketmechanic786267 View Post
    ...... created a script that looks at the spreadsheet and assigns the BOM number to the particular part or assembly and then outputs a new BOM in excel for the current project ?
    Hi,

    Can you explain a bit more what to do with the excel file after reading the data ?
    What is the extension format of your Excel file? csv, xls or xlsx ?

Similar Threads

  1. How to import text from a Excel spreadsheet to Acad (using ObjectDbx)
    By Michel.Levesque.ST522691 in forum VBA/COM Interop
    Replies: 0
    Last Post: 2014-03-20, 09:19 PM
  2. Replies: 0
    Last Post: 2009-10-26, 03:34 AM
  3. Using Parameters from Content Center Parts in BOM/Part Lists
    By Commissar Rod in forum Inventor - General
    Replies: 3
    Last Post: 2008-11-12, 12:08 AM
  4. Using spreadsheet object model and dynamic ranges
    By pfiroz in forum VBA/COM Interop
    Replies: 2
    Last Post: 2008-06-24, 10:16 AM
  5. What are you using for BOM
    By CADMama in forum ACA General
    Replies: 6
    Last Post: 2006-01-31, 11:39 PM

Posting Permissions

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