LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ON OPEN VBA Code input incorrectly now excel sheet wont open mmartin New Users to Excel 1 February 16th 11 11:33 PM
Excel 2003 sheet containing look ups won't open in Excel 2007 daftchickhanley Excel Discussion (Misc queries) 3 July 1st 09 02:08 PM
Excel Sheet Unviewable ~ able to open, but sheet proper all blue Bee Natural Excel Programming 1 August 18th 08 04:51 PM
How do I have Excel Macro write a open ended formula? [email protected] Excel Programming 0 January 9th 07 10:35 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM


All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"