|
|
|
|
#1
11-25-2011, 12:02 AM
|
|||
|
|||
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 |
Windows 7 
Office 2010 (Version 14.0)
Hybrid Mode