Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

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

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 09:55 PM.


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