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
