VBA Save as header page name

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA Save as header page name

FAQ

Thread Tools

Display Modes

11-25-2011, 12:02 AM

devcon

Windows 7

Office 2010 (Version 14.0)

Novice

Join Date: Jul 2010

Posts: 3

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:26 PM.