Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
One way is to use the Hyperlink function.
Create a hyperlink for each part in the sprocket assembly. Clicking on the hyperlink opens the file. From the Excel help file for the Hyperlink function... "... opens the file 1stQtr.xls in Microsoft Excel...that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10: = HYPERLINK("D:\FINANCE\1stQtr.xls", H10) -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (List Files XL add-in: finds and lists files/folders with hyperlinks) wrote in message news:32920078.187.1334156927636.JavaMail.geo-discussion-forums@vbw10... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
thank you for your reply. my question would then be, can something be written to make it click the hyperlink, or run that huperlink formula, based on an outcome? meaning, if cell a1<1, run that hyperlink?
On Wednesday, April 11, 2012 12:07:42 PM UTC-4, Jim Cone wrote: One way is to use the Hyperlink function. Create a hyperlink for each part in the sprocket assembly. Clicking on the hyperlink opens the file. From the Excel help file for the Hyperlink function... "... opens the file 1stQtr.xls in Microsoft Excel...that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10: = HYPERLINK("D:\FINANCE\1stQtr.xls", H10) -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (List Files XL add-in: finds and lists files/folders with hyperlinks) wrote in message news:32920078.187.1334156927636.JavaMail.geo-discussion-forums@vbw10... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
Yes, but it would require more hand-holding than I am willing to provide. You might consider using Excel's built-in Conditional Formatting to highlight items needing attention. '--- Jim Cone wrote in message news:22699305.520.1334216051975.JavaMail.geo-discussion-forums@vbdn7... thank you for your reply. my question would then be, can something be written to make it click the hyperlink, or run that huperlink formula, based on an outcome? meaning, if cell a1<1, run that hyperlink? On Wednesday, April 11, 2012 12:07:42 PM UTC-4, Jim Cone wrote: One way is to use the Hyperlink function. Create a hyperlink for each part in the sprocket assembly. Clicking on the hyperlink opens the file. From the Excel help file for the Hyperlink function... "... opens the file 1stQtr.xls in Microsoft Excel...that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10: = HYPERLINK("D:\FINANCE\1stQtr.xls", H10) -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (List Files XL add-in: finds and lists files/folders with hyperlinks) wrote in message news:32920078.187.1334156927636.JavaMail.geo-discussion-forums@vbw10... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
would you be willing to get paid to hold my hand?
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
You can send a copy of the workbook with a complete description and examples of what you need.
Remove any confidential information from the copy ! Include... the Excel versions it will be used on the operating systems it will be used on if you intend to distribute the workbook to others any special security requirements if the workbook will be Shared (a specific Excel term) any special company or personal requirements Please be very specific and to what is required/needed. Also, please identify yourself and your company. I will take a look and provide an estimate to you of what it might cost. Send the above to XX (remove the XXX parts) '---- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (free and commercial excel programs) wrote in message news:22543822.233.1334252049040.JavaMail.geo-discussion-forums@vbsf4... would you be willing to get paid to hold my hand? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
Anyone? Please help. Basically, what I would want is a formula that did something like this
if A2 <= B2 then it would print c:\sheets\file1.xls, otherwise it would do nothing if C2 <= D2,then it would print c:\sheets\file2.xls, otherwise it would do nothing and so on and so on down the line Once I got one of the formulas, I assume that I could duplicate them for the row information and printed file information Thats really it. Is there a way to do that? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or macro in excel, to open another excel sheet?
Note, if the price is reasonable...I will pay someone for their time in creating this formula, or leading me towards creating it
On Wednesday, April 18, 2012 8:43:29 AM UTC-4, wrote: Anyone? Please help. Basically, what I would want is a formula that did something like this if A2 <= B2 then it would print c:\sheets\file1.xls, otherwise it would do nothing if C2 <= D2,then it would print c:\sheets\file2.xls, otherwise it would do nothing and so on and so on down the line Once I got one of the formulas, I assume that I could duplicate them for the row information and printed file information Thats really it. Is there a way to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Excel 2003 sheet containing look ups won't open in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel Sheet Unviewable ~ able to open, but sheet proper all blue | Excel Programming | |||
How do I have Excel Macro write a open ended formula? | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |