This will loop through Word docs in a folder, open them, then copy and paste the header, content and footer into Sheet1 of the Excel file. Each time the code pastes the contents, the code will find the last row with data, move to that row, then copy + paste and repeat. Feel free to update to your needs. Show Edunread, Mar 18, 2009, 7:45:35 PM3/18/09 to I've set up an Excel 2008 spreadsheet to print Column & Row Headings. How can accomplish this seemingly simple task? Thanks for your help. Ed CyberTazunread, Mar 19, 2009, 12:34:46 AM3/19/09 to Sorry, Ed, but I don't think you'll get that to happen. The Headings bars, HTH |:>) On 3/18/09 7:45 PM, in article Edunread, Mar 19, 2009, 7:17:27 AM3/19/09 to On Mar 19, 12:34 am, CyberTaz <> wrote: > , "Ed" > Thanks. Ed macropodunread, Mar 19, 2009, 11:11:01 AM3/19/09 to Hi Ed, As Bob says, you can't do that. However, if you're prepared to paste the Excel data into Word as a Word table, there is a way to You can then shade the left column & top row to simulate the Excel row/column headings. If you prefer, you can
use SEQ fields to generate the row/column headings: Note: The field brace pairs (ie '{ }') for the above example are created via Cmd-F9 - you can't simply type them or copy & paste --
Carl Witthoftunread, Mar 19, 2009, 5:03:44 PM3/19/09 to There is a different way, but it requires you to paste a Picture rather So, in Excel, use PageSetup to "print row/column headers" , then (at
> Hi Ed, -- CyberTazunread, Mar 19, 2009, 6:45:40 PM3/19/09 to Yep - the feature is still there in 2008, I just didn't think of it :-} Regards |:>)
On 3/19/09 5:03 PM, in article Edunread, Mar 19, 2009, 7:03:10 PM3/19/09 to On Mar 19, 5:03 pm, Carl Witthoft <> wrote: > In article <>, > Carl, How do I import a header into Excel?On the Insert tab, in the Text group, click Header & Footer. Excel displays the Page Setup dialog box. Click Custom Header or Custom Footer. Use the buttons in the Header or Footer dialog box to insert specific header and footer elements.
How do you copy and paste a header in Excel?In the Header & Footer Tools section, click on Edit Header or Edit Footer. Select all of the text and images in the header or footer. Press Ctrl + C (Windows) or Command + C (Mac) to copy. Click on the worksheet tab for the sheet you want to paste the headers/footers into.
How do I copy a letterhead from Word to Excel?How to Put Letterheads in Excel. Check the file extension of the file containing the letterhead you wish to use for your Excel spreadsheet. ... . Launch Excel. ... . Browse your computer to locate your letterhead file, select it, then click "Insert." Your letterhead appears in your spreadsheet within a few seconds.. How do I copy an entire header in Word?Use the controls in the Navigation group to display the header or footer you want to copy. Select all the elements (text and graphics) in the header or footer. Press Ctrl+C. This copies the header or footer information to the Clipboard.
|