Microsoft Office Forums - View Single Post - VBA Save as header page name

Thread: VBA Save as header page name

View Single Post

Old

11-25-2011, 12:02 AM

devcon

devcon is offline

devcon uses Windows 7

Windows 7

devcon uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Novice

The original poster

Join Date: Jul 2010

Posts: 3

devcon is on a distinguished road

Default

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

Reply With Quote