#1
|
|||
|
|||
VBA Save as header page name
I need your help to save the spreadsheet with the name of center header name.
Example Code:
ActiveWorkbook.SaveAs Filename:="C:\Users\Exon\Documents\AAA PDF Files" _ & "\" & ActiveCell.Value & ".xls", _ FileFormat:=xlWorkbookNormal ActiveWorkbook.Close |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to save the current page in a new file with all the page settings (header, footer | Jamal NUMAN | Word | 6 | 03-15-2012 03:27 PM |
Page does not show header & footer | Ron O'Brien | Word | 5 | 01-04-2012 07:34 AM |
Header after page break | mashtonsmith | Word | 1 | 03-11-2011 10:21 AM |
Header disappear on 1st page; fix please? | deonholt | Word | 2 | 10-25-2010 12:47 AM |
Excel 2003 - Different Header for each page | franklyorange | Excel | 0 | 08-26-2008 02:26 PM |