Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 11-25-2011, 12:02 AM
devcon devcon is offline Windows 7 Office 2010 (Version 14.0)
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.


ActiveWorkbook.SaveAs Filename:="C:\Users\Exon\Documents\AAA PDF Files" _
& "\" & ActiveCell.Value & ".xls", _
Reply With Quote

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

All times are GMT -7. The time now is 07:39 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft