Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Automated Macros?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
omitedentity - 31 Mar 2008 15:54 GMT
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 - 01 Apr 2008 00:36 GMT
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

On Mar 31, 3:54 pm, omitedentity
<omitedent...@discussions.microsoft.com> wrote:
> 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
[quoted text clipped - 14 lines]
>
> Using excel 2000

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.