Automated macro for unique csv files

[Omitedentity]

The problem where we are having problems is this: The design team creates a
product. Each product has a list of parts : 2 of this 3 of that. No product
is the same. The list is then converted to a .csv file, which would then be
needed to be converted into labels for each individual part. We would need a
macro that would read the quantity of parts requested, make an individual
label for each part, but at the same time we would be able to use this macro
automated to crate labels for each unique csv file created.

Is there anyway that we can "drag and drop" the csv file into a macro and it
automates the correct amount of labels from the quantity listed from each
unique csv file created for a product?

It is very important to have a way to simplify the steps to do this since
this is being created for individuals who have never used word or excel.

Any assistance is appreciated.

 

[Bob Buckland ?:-\)]

What you're looking at would be the equivalent of printing out a label 'form'. Just as a handwritten paper parts list would would
have spaces for you to write in the information for each assembly/part (part number [p/n], description, qty used, drawing reference,
etc) a computer form would have the same information fill-in spaces or fields.

What you are then doing is 'merging' into a copy of your blank 'form' the information from the .csv (comma separated values) field,
in lieu of you manually writing or typing that information. A label is also a form, just extracting information for each part
rather than a parts list, and if the information on the quantity is in in the .CSV file then you (or a macro) can use that
information for printing the number of copies as well.

While you can do this is MS Office apps - Word, Excel, Access, Publisher, if the only requirement you have for this is the one
listed the Excel would likely be a good choice. If you have the need to do other manipulation with the product/parts information
(different reports, forms, labels) then you may want to use MS Office Access.

You may want to use the link below to followup in the MS Office Excel discussion group and include when posting there information on
the versions of Excel/Office you are using.

==============
The problem where we are having problems is this: The design team creates a
product. Each product has a list of parts : 2 of this 3 of that. No product
is the same. The list is then converted to a .csv file, which would then be
needed to be converted into labels for each individual part. We would need a
macro that would read the quantity of parts requested, make an individual
label for each part, but at the same time we would be able to use this macro
automated to crate labels for each unique csv file created.

Is there anyway that we can "drag and drop" the csv file into a macro and it
automates the correct amount of labels from the quantity listed from each
unique csv file created for a product?

It is very important to have a way to simplify the steps to do this since
this is being created for individuals who have never used word or excel.

Any assistance is appreciated. >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com