Threads Replies Last Post 8 Pages: 1  2  3  4  5  6  7  8   Print all excel files from a folder Can someone point or guide me in how to print all excel files from a folder. I want to print 2 copies from all Excel files in a particular folder then I want to move the files to another folder. Can this be done in a macro and how? Any suggestions or website to visit will be appreciated. Thank you in advance. ... 3 30.09.2006 02:11:59 add auto page break after specific # of cells I need to add an auto page break after a specific # of cells after doing an autofilter. Is this possible?... 1 29.09.2006 19:18:02 Capture RS232 data Hello, I work with a system that prints out receipts on a dedicated little printer whenever there is a transaction. I want to be able to capture the information onto a laptop that I plug in instead of the printer, and end up with it all in an Excel spreadsheet. The printer connects to a multi-pin socket that looks like a COM port. The data comes out (and I don't know what any of this me... 4 27.09.2006 16:28:32 Spreadsheet printing in Landscape WinXP, Service Pack 2, MS-Word 6.0 I am longer able to print in Landscape format. Error message: Out of Memory, close open files or applications. Nothing else is running. Landscape printing of *.doc files works fine. I have uninstalled & reinstalled Word 6.0 several times with no results. What can I do? Thanks for any help. Gerry ... 1 25.09.2006 23:47:15 Printing problem in 2007 I'm having a really strange problem in Excel 2007. When I try print chart on a sheet, they print out larger than I want and in different locations on the page tha I planned, even though they look ok on the sheet. Has anyone else had this? Is it a bug of sorts with the beta?... 2 21.09.2006 21:20:43 Team Explorer and Excel Printing Problem I have recently installed VS 2005 Team Foundation Server Team Explorer, and the print function of Excel seems to have stopped working properly. Either several blocks of rows will simply not print, or several blocks of rows at the beginning seem to repeat (but the blocks towards the end still does not print). I have tried the print button, the Ctrl+P short cut, File->Print, as well as ... 4 21.09.2006 16:40:15 How do I skip the first page when printing front and back I'm trying to print a spreadsheet thats two pages wide by 20 long. I'm trying to get it so that I can bind the pages in a note book so that when my nearly blind boss opens it up he can read it from left to right. I need to make the thing print page one of the spreadsheet on the back of the first piece of paper Please help.... 1 18.09.2006 16:48:02 Print Selected Portions of Spreadsheet Hallo Group, I use a workbook with 5 different worksheets to prepare the work roasters of my staff. Each Worksheet has a common header (the first 5 rows of the sheet), and is separated into different category levels by a row with the category name. Then, each staff uses 2 Row, the name of the staff in a merged cell in Col F. Staff are separated by a blank Row. What i need to do is to... 2 17.09.2006 11:12:39 Printing Gridlines Excel will not print default gridlines. If any other type of line is selected it will print. Uninstalled and reinstalled Office 2003 with no change. Draft Mode in printer properties are not selected. Tried selecting gridline option in printer properties but that makes no difference. Tried creating a new profile for user...no change. Tried printing from different types of printers o... 2 17.09.2006 10:31:11 Click Print Preview: Print Dialog Box Pops Up Instead I am using Excel 2003 on my week-old computer and am running into a strange problem with the print preview function. When I click on print preview, the print dialog box pops up as if I had clicked "File", then "Print". If I then click on the "preview" button on the bottom left, or click "okay", it will take me to the normal preview screen. Also, in the "Print what" subsection in the dial... 1 09.09.2006 02:10:13 Printing a workbook I often have to print a workbook. How does one set up the worksheets so that they look consistent. Eg. some worksheets have 10 rows and others have 20 so. How does one get the whole set looking coherent? What formatting tips and tricks are there> Help appreciated. Thanks, Janev... 2 08.09.2006 19:09:56 Printing only a portion of page For some reason, my worksheet is not printing in its entirety. It appears as though it is printing selection instead of sheet - but the "selection" option is NOT checked. Is there some hidden setting that I may have set accidently that I should check? TIA Papa... 2 07.09.2006 10:52:00 Printing Unprotected Cells Only Does anyone know if there is a way to print only the unprotected cells in a worksheet that includes both protected and unprotected cells?... 1 06.09.2006 20:19:02 Report Manager I’m using Excel 97. Report Manager is installed. I have a spreadsheet that has 4 areas, which I would like to print out in a report. I have set up the print areas, etc. and printed the report. If I make a copy of the sheet, updating the reporting data, but not changing anything to do with the views, print settings, etc., substitute the new sections in the report manager window, it do... 1 06.09.2006 19:40:02 Excel file not printing numbers Hello, I have some excel files that can't print numbers (or text) on one of our network printers. There is only layout and borders, but with empty cells. However, when we print the same file on our other printer, it's all OK. There are also some other excel files that don't have such a problem. Can somebody advise what to do? Thanks, Mark ... 2 04.09.2006 14:11:02 Set print area will not fit on 1 page I have a table set up and selected as my print area. Print preview shows that it slightly fits over 1 page at 100% adjustment. The page is in Landscape setting. When I try and fit to 1 page wide by 1 page tall it syas it cannot fit as it can not reduce it by more than 10%. It says that the margins do not fit the page size - yet I have put the margins to zero as well. It SHOULD fit o... 3 01.09.2006 10:11:24 Page Break / Margins I have a worksheet in Excel. The left & right margins are set to 0. When I print the worsheet it prints 1 page, no problems. I have other users who print and it prints on 2 pages. In Page Break preview it pushes the last column off the page. I can go in and manual adjust each time it does this. Is there a way to get it to always print on 1 page no matter who is pulling it up. We are run... 2 30.08.2006 15:33:14 Curious Printing problem I am running Office 2000 on Win2k. Yesterday I noticed a very strange problem. I have a workbook with 9 similar worksheets and one unique worksheet. I made minor edits to the unique worksheet, consisting of formating certain rows to have strikethroughs and to modify the formula in another cell. When I printed the worksheet (in landscape mode) it was displayed in the upper left corner ... 5 25.08.2006 23:25:33 HELP NEEDED... Hi There I NEED HELP: I have a over 3000 hyperlinks that are stored in fields (A1 to A500,B1 to B500 and so on). I want to automate a hard copy print run and PDF print run. Manually repeating clicking on the link, followed Ctrl+P in IE and then clicking print again 3000+ each times will take an age and give anyone repetitive strain injury! I have looked at http://www.ureader.com/me... 1 22.08.2006 20:19:59 Printing different sets of data on same worksheet seperately I have a financial model with 12 months of 2006 data and 12 months of 2007 data side-by-side. I would like to print the 2006 data all the way down the sheet together (and there are several sheets like this) and then the 2007 data together. With all of the sheets I need to print, it is a painstaking process to set and reset the print area each time I want to print. Does anyone know of a way... 4 21.08.2006 07:56:02 Bug in printing graphs with trend lines in Excel 2003 Hi All, I seem to have found a bug in Excel 2003 when printing a graph with trend lines. I made a scatter plot of some data and added two linear trend lines. They were plotted seemingly correctly on screen. The trend was slowly downward, but neither trend line reached a value of 0 in the graph. When I printed the graph, however, both trend lines suddenly do cross the 0! I checked on the ba... 2 20.08.2006 22:28:35 Saving print settings in multiple sheets I have a workbook with 70 worksheets. I need to print each worksheet seperately, but duplex. I thought (and have done in the past) that when I entered any print settings for one worksheet ,that setting would apply to all worksheets (by clicking the print icon on the toolbar), as long as the workbook remained open. However, now the print settings do not save, and in order to get each work... 4 19.08.2006 10:09:50 Printing Alternate Rows Using Excel 2000: You can select alternate rows by using the CTRL button (e.g.; select rows 2, 4, 6, 8, etc) but when you try to print your selection (File| Print | Selection) each row prints on a separate page. Is there something you can tweak to have as many alternate rows as possible print on the same page? -- LPS... 2 14.08.2006 18:37:52 Useful and very cool Is there a way of printing column headers on every page of the worksheet you want to print?... 2 14.08.2006 18:36:05 One sheet won't print I have a multi-tabbed spreadsheet that I use all the time. It printed fine on a all-in-one 5110 HP, but that printer died and I replaced it with a all-in-on 4315 HP and now one page of the spreadsheet will not print. Actually, what happens is that page prints extremely slow, or the printer will stop advancing the paper after about an inch of printing. The printer carts still go back and ... 2 14.08.2006 15:10:24 8 Pages: 1  2  3  4  5  6  7  8