Hi Ratedr, Almost all automation requires a macro to implement (I say almost because some features like conditional formatting, data validation, and comments that appear when the mouse hovers over a cell could be looked at as types of automation).
So this will will likely require a small macro. You could consider as an alternative to having the macro print these separate files, having the macro print separate worksheets in the same workbook (or even create or modify a single sheet that might be printed for sprockets, flanges, or whatever, and put the relevant text and data on it, print it, and then optionally delete or hide the sheet.) In any case, yes, please attach a sample file and your thoughts on my suggestions. Thanks, Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Wednesday, April 11, 2012 9:57 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ excel to open up another excel file? Please attached sample file Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ratedr Sent: Apr/Wed/2012 08:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ excel to open up another excel file? 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 -- 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 -- 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
