Ok. This is a very VERY crude example of what I am talking about, but it
will give you the idea. This is the sheet the factory will get every day.
The "style" that they need, the
"size" they need to make them in...how many we are making ("pcs made"), and
then how many we actually need ("pcs needed"). Every time that one of the
parts break, they will make a notation, lowering the # in the "pcs made"
cell. If enough pcs are no good, I need to initiate a new workorder< so
basically< when the # IN "pcs made" EQUALS THE # IN "pcs needed", I want
it to be able to open and print a workorder. each style you see there
(123, 456, etc) will have an excel sheet with the same name on that same
computer. What I want is, when one of the pcs made in style 123, for
example, equals the # in pcs needed, it will open up "123.xls" and print
it. IT will do the same for if the # in style 456, 789 and so on. I hope
I explained myselfOn Wednesday, April 11, 2012 11:07:28 AM UTC-4, Ratedr wrote: > > Is there a fomula or a macro or something, within excel, that will allow > it to open up and print another excel file? > > What Im saying is, for example: > I am making sprockets. I print out an order sheet for 100 sprockets. I > have a spreadsheet open stating 100 sprockets. Each time 1 sprocket is no > good, I am going to make a notation on that spreadsheet (with a -1). Once > that # gets BELOW 95, I want it to print out a work order. I already have > a file called "sprockets.xls"...so basically what I want it to do, is open > and print out that file "sprockets.xls" when it gets below that 95. On the > same workorder I might have 100 flanges, when it gets below 95, I want it > to open up a file called "flanges.xls" Is there any way to do this? > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
