or if anyone following this link, can look at the original sheet that I wrote and add in the code.
On Thursday, April 12, 2012 4:24:38 AM UTC-4, Ratedr wrote: > > is there a way you can add that code into one of the cells (like in , for > example k4, stating "(=if d4=d5)+(ife4=e5)+iff4=f5) and so on" of any of > those in the row 4 equal any of them in row 5...run that macro) in my > sheet, and then attach it into your reply? so I can see it in use? its > hard for me to picture it and I cant really see in that macro (not really > that familiar with macros) where the 123.xls would be opened, etC) > thank you so much in advance if you can do this > > > On 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? >> > On Thursday, April 12, 2012 4:24:38 AM UTC-4, Ratedr wrote: > > is there a way you can add that code into one of the cells (like in , for > example k4, stating "(=if d4=d5)+(ife4=e5)+iff4=f5) and so on" of any of > those in the row 4 equal any of them in row 5...run that macro) in my > sheet, and then attach it into your reply? so I can see it in use? its > hard for me to picture it and I cant really see in that macro (not really > that familiar with macros) where the 123.xls would be opened, etC) > thank you so much in advance if you can do this > > > On 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
