Automated Macros?

[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. >>

Using excel 2000

 

[Pete_UK]

You could have a macro in an Excel file which when run asks the user
to specify a (csv) file, which it could then open and print sufficient
labels from the data within that file.

Further, if the file was always in the same folder, then the macro
could record the file(s) it had dealt with in the past, so it would
know which file(s) would still need to be processed, and could do this
automatically with little user intervention. You could have some
naming convention for the files, eg including a datestamp within the
name, and use this to trigger the processing of the new files.

You would need to specify exact details of the csv files, and it may
be better to do so in a new thread posted in the .programming group.

Hope this helps.

Pete