Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Importing BOMs

Status
Not open for further replies.

winja

Technical User
Jan 30, 2003
1
US
I am looking for a way to import my current BOMs into eEnterprise. They are currently in All Cad. I understand that the import feature does not link to the BOM screen. Is this true?
 
Hi winja,

Firstly I have never worked with manufacturing but I think you could use a macro to import the files but you do need some programming knowledge.

Macros work by record what the user is doing. When you record a macro you can replay it as many times as you like. What you need to do is to record a macro of yourself typing in an example of a BOM. Then using excel or similar you can create a macro file by using the example you recorded and replacing the values you entered with your import values.

Using VBA in excel it is very easy to read data held on datasheet and write it out to file. This file would be your macro file.

Hope this helps,
JMG



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top